Skip to content

Instantly share code, notes, and snippets.

View jgagnon1's full-sized avatar

Jerome Gagnon jgagnon1

View GitHub Profile
"settings": {
"analysis": {
"analyzer": {
"default": {
"char_filter": "html_strip",
"filter": [
"lowercase",
"asciifolding",
"stop",
],
@jgagnon1
jgagnon1 / gist:5f89ff18d89040c8ae9b
Last active August 29, 2015 14:25 — forked from joyofdata/gist:26e49e77285e35bc2439
Setting Up a Time Dimension Table in MySQL / comment
DROP TABLE IF EXISTS `T`;
CREATE TABLE `T` (
`n` int(11)
);
INSERT INTO `T`(n) SELECT @row := @row + 1 as row FROM
(select 0 union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t,
(select 0 union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t2,
(select 0 union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t3,
(select 0 union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t4,
@import url(https://fonts.googleapis.com/css?family=Open+Sans:400,700,500,300);@-webkit-keyframes rotating{from{-webkit-transform:rotate(0deg)}to{-webkit-transform:rotate(360deg)}}@keyframes rotating{from{transform:rotate(0deg)}to{transform:rotate(360deg)}}[src$='blue.png']{background-image:url(data:image/svg+xml;charset=UTF-8,%3Csvg%20height%3D%2218%22%20viewBox%3D%220%200%2024%2024%22%20width%3D%2218%22%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%3E%3Cpath%20d%3D%22M0%200h24v24H0z%22%20fill%3D%22none%22%2F%3E%3Cpath%20fill%3D%22%23009688%22%20d%3D%22M12%202C6.48%202%202%206.48%202%2012s4.48%2010%2010%2010%2010-4.48%2010-10S17.52%202%2012%202zm-2%2015l-5-5%201.41-1.41L10%2014.17l7.59-7.59L19%208l-9%209z%22%2F%3E%3C%2Fsvg%3E)}[src$='red.png']{background-image:url(data:image/svg+xml;charset=UTF-8,%3Csvg%20height%3D%2218%22%20viewBox%3D%220%200%2024%2024%22%20width%3D%2218%22%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%3E%3Cpath%20d%3D%22M0%200h24v24H0z%22%20fill%3D%22none%22%2F%3E%3Cpath%20fi

Keybase proof

I hereby claim:

  • I am jgagnon1 on github.
  • I am jgagnon (https://keybase.io/jgagnon) on keybase.
  • I have a public key ASDTcubz0FSGu1ERtr_fi344zEwdU_RzCfuVs2GnEClBNwo

To claim this, I am signing this object: