Skip to content

Instantly share code, notes, and snippets.

@wesm

wesm/sample-roundtrip.json

Created November 30, 2016 18:33
Show Gist options
  • Save wesm/3e3403ae09ac97770fc6e5aa9bce95bc to your computer and use it in GitHub Desktop.
Save wesm/3e3403ae09ac97770fc6e5aa9bce95bc to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sample-roundtrip.json
{
"schema" : {
"fields" : [{
"name" : "int8",
"nullable" : true,
"type" : {
"name" : "int",
"bitWidth" : 8,
"isSigned" : true
},
"children" : [ ],
"typeLayout" : {
"vectors" : [{
"type" : "VALIDITY",
"typeBitWidth" : 1
},{
"type" : "DATA",
"typeBitWidth" : 8
}]
}
},{
"name" : "int16",
"nullable" : true,
"type" : {
"name" : "int",
"bitWidth" : 16,
"isSigned" : true
},
"children" : [ ],
"typeLayout" : {
"vectors" : [{
"type" : "VALIDITY",
"typeBitWidth" : 1
},{
"type" : "DATA",
"typeBitWidth" : 16
}]
}
},{
"name" : "int32",
"nullable" : true,
"type" : {
"name" : "int",
"bitWidth" : 32,
"isSigned" : true
},
"children" : [ ],
"typeLayout" : {
"vectors" : [{
"type" : "VALIDITY",
"typeBitWidth" : 1
},{
"type" : "DATA",
"typeBitWidth" : 32
}]
}
},{
"name" : "int64",
"nullable" : true,
"type" : {
"name" : "int",
"bitWidth" : 64,
"isSigned" : true
},
"children" : [ ],
"typeLayout" : {
"vectors" : [{
"type" : "VALIDITY",
"typeBitWidth" : 1
},{
"type" : "DATA",
"typeBitWidth" : 64
}]
}
},{
"name" : "uint8",
"nullable" : true,
"type" : {
"name" : "int",
"bitWidth" : 8,
"isSigned" : false
},
"children" : [ ],
"typeLayout" : {
"vectors" : [{
"type" : "VALIDITY",
"typeBitWidth" : 1
},{
"type" : "DATA",
"typeBitWidth" : 8
}]
}
},{
"name" : "uint16",
"nullable" : true,
"type" : {
"name" : "int",
"bitWidth" : 16,
"isSigned" : false
},
"children" : [ ],
"typeLayout" : {
"vectors" : [{
"type" : "VALIDITY",
"typeBitWidth" : 1
},{
"type" : "DATA",
"typeBitWidth" : 16
}]
}
},{
"name" : "uint32",
"nullable" : true,
"type" : {
"name" : "int",
"bitWidth" : 32,
"isSigned" : false
},
"children" : [ ],
"typeLayout" : {
"vectors" : [{
"type" : "VALIDITY",
"typeBitWidth" : 1
},{
"type" : "DATA",
"typeBitWidth" : 32
}]
}
},{
"name" : "uint64",
"nullable" : true,
"type" : {
"name" : "int",
"bitWidth" : 64,
"isSigned" : false
},
"children" : [ ],
"typeLayout" : {
"vectors" : [{
"type" : "VALIDITY",
"typeBitWidth" : 1
},{
"type" : "DATA",
"typeBitWidth" : 64
}]
}
},{
"name" : "float32",
"nullable" : true,
"type" : {
"name" : "floatingpoint",
"precision" : "SINGLE"
},
"children" : [ ],
"typeLayout" : {
"vectors" : [{
"type" : "VALIDITY",
"typeBitWidth" : 1
},{
"type" : "DATA",
"typeBitWidth" : 32
}]
}
},{
"name" : "float64",
"nullable" : true,
"type" : {
"name" : "floatingpoint",
"precision" : "DOUBLE"
},
"children" : [ ],
"typeLayout" : {
"vectors" : [{
"type" : "VALIDITY",
"typeBitWidth" : 1
},{
"type" : "DATA",
"typeBitWidth" : 64
}]
}
}]
},
"batches" : [{
"count" : 10,
"columns" : [{
"name" : "int8",
"count" : 10,
"VALIDITY" : [1,0,1,0,0,1,1,1,1,0],
"DATA" : [121,-7,-123,121,-64,-102,101,61,-113,8]
},{
"name" : "int16",
"count" : 10,
"VALIDITY" : [0,0,0,0,1,0,1,0,1,1],
"DATA" : [29383,27161,27728,23855,7302,24985,-14254,2316,-5347,23467]
},{
"name" : "int32",
"count" : 10,
"VALIDITY" : [1,1,0,1,1,1,1,0,0,0],
"DATA" : [-836207204,808227607,-1761182973,1510384871,1638916633,583363142,-268562719,-341005036,-1223002328,1382814169]
},{
"name" : "int64",
"count" : 10,
"VALIDITY" : [0,0,0,0,0,1,1,0,1,0],
"DATA" : [1798197987,1127883384,579185757,104758115,151652776,767484291,943186244,-526783029,935484072,1798556173]
},{
"name" : "uint8",
"count" : 10,
"VALIDITY" : [0,1,0,0,1,1,1,1,0,1],
"DATA" : [-96,52,-100,-62,99,-81,-34,-98,13,114]
},{
"name" : "uint16",
"count" : 10,
"VALIDITY" : [1,1,0,1,1,1,1,1,0,1],
"DATA" : ["劯","ꉤ","菊","ٔ","ᴞ","ગ","","붹","࿘","㻧"]
},{
"name" : "uint32",
"count" : 10,
"VALIDITY" : [1,1,1,1,1,0,0,1,1,1],
"DATA" : [2039148331,1590823099,95486162,272340170,1275757088,1974084121,2073444842,570289741,247823279,1660174877]
},{
"name" : "uint64",
"count" : 10,
"VALIDITY" : [1,1,1,1,0,1,1,0,1,1],
"DATA" : [1327293803,1471991020,1647842870,16289581,1319338984,387379044,323204061,2140104676,1237086660,1468788237]
},{
"name" : "float32",
"count" : 10,
"VALIDITY" : [0,1,1,1,0,0,1,1,0,1],
"DATA" : [0.42554453,-0.59309036,-0.7149297,-0.053927753,-0.09953065,0.4080427,0.21979892,1.8269016,-1.4298322,1.110394]
},{
"name" : "float64",
"count" : 10,
"VALIDITY" : [1,1,0,0,0,1,1,0,1,1],
"DATA" : [-0.8956863666421725,-0.005534144168907178,0.28974696210148565,0.9773655383692914,0.5722654305618144,1.096198765159252,0.7061254775677759,0.33071951790472004,-1.7040702789359499,-0.5218699439467348]
}]
},{
"count" : 5,
"columns" : [{
"name" : "int8",
"count" : 5,
"VALIDITY" : [1,1,1,1,1],
"DATA" : [-25,123,87,38,30]
},{
"name" : "int16",
"count" : 5,
"VALIDITY" : [1,0,1,0,1],
"DATA" : [26580,20690,200,-3852,16511]
},{
"name" : "int32",
"count" : 5,
"VALIDITY" : [1,0,0,0,1],
"DATA" : [-468450171,1494531244,1653692196,748056729,1741848085]
},{
"name" : "int64",
"count" : 5,
"VALIDITY" : [0,0,0,0,0],
"DATA" : [1011368935,1708803648,-692047757,1656596999,2117404255]
},{
"name" : "uint8",
"count" : 5,
"VALIDITY" : [1,1,0,1,1],
"DATA" : [84,0,35,32,62]
},{
"name" : "uint16",
"count" : 5,
"VALIDITY" : [0,0,1,0,0],
"DATA" : ["c","⫫","⅐","宇","ቢ"]
},{
"name" : "uint32",
"count" : 5,
"VALIDITY" : [1,1,1,0,0],
"DATA" : [1953741090,1085913805,692134200,597961052,1819735935]
},{
"name" : "uint64",
"count" : 5,
"VALIDITY" : [0,0,0,1,1],
"DATA" : [655515792,955730496,1537918633,144686174,643862005]
},{
"name" : "float32",
"count" : 5,
"VALIDITY" : [1,1,0,0,1],
"DATA" : [0.4269456,-1.8184305,-0.18820402,0.7429486,1.254613]
},{
"name" : "float64",
"count" : 5,
"VALIDITY" : [0,1,0,0,0],
"DATA" : [1.7439835798013121,0.819406350831609,0.47766906360847283,-1.4850928178024771,1.9099843193216974]
}]
}]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment