Skip to content

Instantly share code, notes, and snippets.

View ajw0100's full-sized avatar

AJ ajw0100

4 followers · 1 following
  • Google
  • Boston
View GitHub Profile
@ajw0100
ajw0100 / z_order_curve.sql
Last active July 1, 2020 23:28
The Z-Order Curve and Amazon Redshift's Interleaved Sort Keys (https://chartio.com/blog/understanding-interleaved-sort-keys-in-amazon-redshift-part-1/)
with
years(year_id, year) as (
select i, 'Year ' || i
from generate_series(0, 3) i
),
regions(region_id, region) as (
select i, 'Region ' || i
from generate_series(0, 3) i
@ajw0100
ajw0100 / response.content
Created November 28, 2013 05:18
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">\n<html><head>\n<meta http-equiv="Content-Type" content="text/html; charset=utf-8">\n<title>ERROR: Cache Access Denied</title>\n<style type="text/css"><!-- \n /*\n Stylesheet for Squid Error pages\n Adapted from design by Free CSS Templates\n http://www.freecsstemplates.org\n Released for free under a Creative Commons Attribution 2.5 License\n*/\n\n/* Page basics */\n* {\n\tfont-family: verdana, sans-serif;\n}\n\nhtml body {\n\tmargin: 0;\n\tpadding: 0;\n\tbackground: #efefef;\n\tfont-size: 12px;\n\tcolor: #1e1e1e;\n}\n\n/* Page displayed title area */\n#titles {\n\tmargin-left: 15px;\n\tpadding: 10px;\n\tpadding-left: 100px;\n\tbackground: url(\'http://www.squid-cache.org/Artwork/SN.png\') no-repeat left;\n}\n\n/* initial title */\n#titles h1 {\n\tcolor: #000000;\n}\n#titles h2 {\n\tcolor: #000000;\n}\n\n/* special event: FTP success page titles */\n#titles ftpsuccess {\n\tbackground-color:#00ff00;\n\twidth:100%;\n}\n\n
@ajw0100
ajw0100 / gist:7686464
Created November 28, 2013 02:35
Packing version 1385605948
Deploying to project "1314" in http://dash.scrapinghub.com/api/scrapyd/addversion.json
Deploy failed (400):
{"status": "error", "message": "Error running 'scrapy list': Traceback (most recent call last):\n File \"/usr/lib/pymodules/python2.7/shub/web/apps/api/views.py\", line 42, in api_addversion\n spiders = listspiders(pm.project_id)\n File \"/usr/lib/pymodules/python2.7/shub/celerytasks.py\", line 9, in listspiders\n return send_task('hworker.list_spiders', args=[project_id]).wait(60)\n File \"/usr/lib/pymodules/python2.7/celery/result.py\", line 89, in wait\n interval=interval)\n File \"/usr/lib/pymodules/python2.7/celery/backends/amqp.py\", line 135, in wait_for\n meta = self.consume(task_id, timeout=timeout)\n File \"/usr/lib/pymodules/python2.7/celery/backends/amqp.py\", line 195, in consume\n channel = conn.channel()\n File \"/usr/lib/python2.7/dist-packages/kombu/connection.py\", line 159, in channel\n chan = self.transport.create_channel(self.connec
@ajw0100
ajw0100 / gist:7683957
Created November 27, 2013 22:00
Packing version 1385588855
Deploying to project "1314" in http://dash.scrapinghub.com/api/scrapyd/addversion.json
Deploy failed (400):
{"status": "error", "message": "Error running 'scrapy list': Traceback (most recent call last):\n File \"/usr/lib/pymodules/python2.7/shub/web/apps/api/views.py\", line 42, in api_addversion\n spiders = listspiders(pm.project_id)\n File \"/usr/lib/pymodules/python2.7/shub/celerytasks.py\", line 9, in listspiders\n return send_task('hworker.list_spiders', args=[project_id]).wait(60)\n File \"/usr/lib/pymodules/python2.7/celery/result.py\", line 89, in wait\n interval=interval)\n File \"/usr/lib/pymodules/python2.7/celery/backends/amqp.py\", line 137, in wait_for\n raise TimeoutError(\"The operation timed out.\")\nTimeoutError: The operation timed out.\n"}
@ajw0100
ajw0100 / gist:7605012
Created November 22, 2013 18:57
In [3]: sel.re(r'license_list\.cfm\?.*')
Out[3]:
[u'license_list.cfm?genreID=1&amp;cclicense=1&amp;sort=1&amp;page=2">2</a>\r',
u'license_list.cfm?genreID=1&amp;cclicense=1&amp;sort=1&amp;page=3">3</a>\r',
u'license_list.cfm?genreID=1&amp;cclicense=1&amp;sort=1&amp;page=4">4</a>\r',
u'license_list.cfm?genreID=1&amp;cclicense=1&amp;sort=1&amp;page=5">5</a>\r',
u'license_list.cfm?genreID=1&amp;cclicense=1&amp;sort=1&amp;page=6">6</a>\r',
u'license_list.cfm?genreID=1&amp;cclicense=1&amp;sort=1&amp;page=7">7</a>\r',
u'license_list.cfm?genreID=1&amp;cclicense=1&amp;sort=1&amp;page=8">8</a>\r',
u'license_list.cfm?genreID=1&amp;cclicense=1&amp;sort=1&amp;page=2">Next ></a></strong>\r']
@ajw0100
ajw0100 / gist:7258331
Created October 31, 2013 22:35
vagrant 14579 1 1 22:27 ? 00:00:00 /usr/bin/python /usr/bin/salt-master
vagrant 14580 14579 4 22:27 ? 00:00:00 /usr/bin/python /usr/bin/salt-master
vagrant 14587 14579 0 22:27 ? 00:00:00 /usr/bin/python /usr/bin/salt-master
vagrant 14590 14579 0 22:27 ? 00:00:00 /usr/bin/python /usr/bin/salt-master
vagrant 14593 14579 2 22:27 ? 00:00:00 /usr/bin/python /usr/bin/salt-master
vagrant 14594 14579 2 22:27 ? 00:00:00 /usr/bin/python /usr/bin/salt-master
vagrant 14599 14579 2 22:27 ? 00:00:00 /usr/bin/python /usr/bin/salt-master
vagrant 14600 14579 2 22:27 ? 00:00:00 /usr/bin/python /usr/bin/salt-master
vagrant 14601 14579 2 22:27 ? 00:00:00 /usr/bin/python /usr/bin/salt-master
@ajw0100
ajw0100 / gist:7093274
Last active December 26, 2015 04:29
vagrant@dev-vm:~$ sudo salt '*' state.highstate test=true
dev-vm:
----------
State: - no
Name: states
Function: None
Result: False
Comment: No Top file or external nodes data matches found
Changes:
@ajw0100
ajw0100 / 1
Last active December 25, 2015 21:39
1. Traceback 2. /etc/salt/master 3. salt '*' state.highstate -l debug test=true 4. master.sls 5. gitpython.sls
dev_vm:
Data failed to compile:
----------
Traceback (most recent call last):
File "/usr/lib/pymodules/python2.7/salt/state.py", line 2253, in call_highstate
top = self.get_top()
File "/usr/lib/pymodules/python2.7/salt/state.py", line 1865, in get_top
tops = self.get_tops()
File "/usr/lib/pymodules/python2.7/salt/state.py", line 1744, in get_tops
env
@ajw0100
ajw0100 / 1
Last active December 25, 2015 19:59
1: Traceback after calling sudo salt-call -l debug state.highstate 2: /srv/salt/top.sls 3: /srv/salt/edit/emacs/init.sls
vagrant@dev:~$ sudo salt-call -l debug state.highstate
[DEBUG ] Reading configuration from /etc/salt/minion
[DEBUG ] Guessing ID. The id can be explicitly in set /etc/salt/minion
[DEBUG ] loading log_handlers in ['/var/cache/salt/minion/extmods/log_handlers', '/usr/lib/pymodules/python2.7/salt/log/handlers']
[DEBUG ] Skipping /var/cache/salt/minion/extmods/log_handlers, it is not a directory
[DEBUG ] None of the required configuration sections, 'logstash_udp_handler' and 'logstash_zmq_handler', were found the in the configuration. Not loading the Logstash logging handlers module.
[DEBUG ] Configuration file path: /etc/salt/minion
[DEBUG ] Reading configuration from /etc/salt/minion
[DEBUG ] loading grain in ['/var/cache/salt/minion/extmods/grains', '/usr/lib/pymodules/python2.7/salt/grains']
[DEBUG ] Skipping /var/cache/salt/minion/extmods/grains, it is not a directory
@ajw0100
ajw0100 / gist:3832357
Created October 4, 2012 09:02
.PTChildPivotTable {
border-bottom:solid 3px #003799;
}
.PT_SI {
display: none;
}
.PTCHC0,.PTCHC1,.PTCHC2,.PTCHC3,.PTCHC4,.PTCHC5,.PTCHC6,.PTCHC7,.PTCHC8,.PTCHC9,.PTCHC10 {
font-weight:bold;
border-left:solid 0px #979991;
border-top:solid 0px #979991;