Skip to content

Instantly share code, notes, and snippets.

View ghalimi's full-sized avatar

Ismael Ghalimi ghalimi

View GitHub Profile
# query -> SELECT * FROM table
{
"select_query" : {
"select_node" : {
"projection_list": [
{
"type": "star_expression"
}
],
"from_clause": [
{
"visual" : [
{
"id" : "overview",
"name" : "Overview",
"options" : [
{
"id" : "title",
"name" : "Title",
"datatype" : "string"
{
"bonbon": {
"visual": "table",
"axes": ["columns", "rows", "color", "symbol"]
},
"chocolate": {
"visual": "table",
"axes": ["columns", "rows", "symbol"]
},
"gradient": {
[
{ "dimensions": ["incremental"], "measures": ["differential"], "visual": "tape" },
{ "dimensions": ["nominal"], "measures": ["differential"], "visual": "train" },
{ "dimensions": ["incremental"], "measures": ["quantizable"], "visual": "castle" },
{ "dimensions": ["nominal"], "measures": ["quantizable"], "visual": "dot" },
{ "dimensions": ["incremental", "nominal"], "measures": ["quantizable"], "visual": "stair" },
{ "dimensions": ["nominal", "nominal"], "measures": ["quantizable"], "visual": "scale" },
{ "dimensions": ["incremental"], "measures": ["cardinal"], "visual": "castle" },
{ "dimensions": ["nominal"], "measures": ["cardinal"], "visual": "dot" },
{ "dimensions": ["incremental", "incremental"], "measures": ["cardinal"], "visual": "contour" },
{
"name" : "Quakes",
"id" : "/quakes",
"version" : "0.0.1",
"description" : "All recorded earthquakes with a magnitude of 6 or greater from 1900 to 2013.",
"author" : "Ismael Chang Ghalimi @ghalimi",
"license" : "MIT",
"sheets" : [
{
"name" : "Recordings",
@ghalimi
ghalimi / types.json
Last active September 24, 2015 00:15
{
"types": {
"int8" : { "name": "Signed 8 bits integer" , "c": "int8_t" },
"int16" : { "name": "Signed 16 bits integer" , "c": "int16_t" },
"int32" : { "name": "Signed 32 bits integer" , "c": "int32_t" },
"int64" : { "name": "Signed 64 bits integer" , "c": "int64_t" },
"uint8" : { "name": "Unsigned 8 bits integer" , "c": "uint8_t" },
"uint16" : { "name": "Unsigned 16 bits integer" , "c": "uint16_t" },
"uint32" : { "name": "Unsigned 32 bits integer" , "c": "uint32_t" },
"uint64" : { "name": "Unsigned 64 bits integer" , "c": "uint64_t" },
{
"name": "My Pipeline",
"id": "my_pipeline",
"parameters": {},
"transforms": [
{
"operation": "CREATE",
"type": "table",
"id": "MyTable",
"once": true,
We can't make this file beautiful and searchable because it's too large.
ID,Network,Country,Place,Timestamp,Date,Time,Updated,Latitude,Longitude,Depth,Magnitude,Type,Reports,Gap,Distance,RMS
centennial19000105190000,centennial,,"southern Sumatra, Indonesia",1900-01-05T19:00:00.000Z,1/5/1900,7:00:00 PM,2013-07-09T19:07:15.000Z,-3,102,0,7,ms,0,,,
centennial19000111090700,centennial,,Bismarck Sea,1900-01-11T09:07:00.000Z,1/11/1900,9:07:00 AM,2013-07-09T19:07:15.000Z,-5,148,0,7,ms,0,,,
centennial19000118074600,centennial,,Kuril Islands,1900-01-18T07:46:00.000Z,1/18/1900,7:46:00 AM,2013-07-09T19:07:15.000Z,44.5,148.5,35,6.7,mj,0,,,
centennial19000120063300,centennial,,"Jalisco, Mexico",1900-01-20T06:33:00.000Z,1/20/1900,6:33:00 AM,2013-07-09T19:07:15.000Z,20,-105,0,7.3,mw,0,,,
centennial19000131192200,centennial,,northwest of the Kuril Islands,1900-01-31T19:22:00.000Z,1/31/1900,7:22:00 PM,2013-07-09T19:07:15.000Z,48,146,450,7.5,mj,0,,,
centennial19000424231600,centennial,,"northwest of the Ryukyu Islands, Japan",1900-04-24T23:16:00.000Z,4/24/1900,11:16:00 PM,2013-07-09T19:07:15.000Z,27
{
"name" : "Earthquakes",
"id" : "/earthquakes",
"version" : "0.2.0",
"description" : "All recorded earthquakes with a magnitude of 6 or greater from 1900 to 2013.",
"author" : "Ismael Chang Ghalimi @ghalimi",
"license" : "MIT",
"dependencies" : {},
"template" : null,
"sheets" : [
{
"canvas": {
"background": {
"discrete": {
"first": {
"bucket": "columns"
},
"next": {
"bucket": "columns"
}