Skip to content

Instantly share code, notes, and snippets.

@a2ndrade

a2ndrade/tpch.json

Last active July 28, 2016 00:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save a2ndrade/e98856202696acb35e1f05260e09fe6c to your computer and use it in GitHub Desktop.
Save a2ndrade/e98856202696acb35e1f05260e09fe6c to your computer and use it in GitHub Desktop.
Download ZIP
Sample JSON data for TPC-H schema
Raw
tpch.json
[
{
"entityId": -101,
"entityDt": "customerDt",
"c_name": "Customer#000000001",
"c_address": "IVhzIApeRb ot,c,E",
"c_nationkey": -2015,
"c_phone": "25-989-741-2988",
"c_acctbal": 711.56,
"c_mktsegment": "BUILDING",
"c_comment": "to the even, regular platelets. regular, ironic epitaphs nag e"
},
{
"entityId": -102,
"entityDt": "customerDt",
"c_name": "Customer#000000002",
"c_address": "XSTf4,NCwDVaWNe6tEgvwfmRchLXak",
"c_nationkey": -2013,
"c_phone": "23-768-687-3665",
"c_acctbal": 121.65,
"c_mktsegment": "AUTOMOBILE",
"c_comment": "l accounts. blithely ironic theodolites integrate boldly: caref"
},
{
"entityId": -103,
"entityDt": "customerDt",
"c_name": "Customer#000000003",
"c_address": "MG9kdTD2WBHm",
"c_nationkey": -201,
"c_phone": "11-719-748-3364",
"c_acctbal": 7498.12,
"c_mktsegment": "AUTOMOBILE",
"c_comment": " deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov"
},
{
"entityId": -104,
"entityDt": "customerDt",
"c_name": "Customer#000000004",
"c_address": "XxVSJsLAGtn",
"c_nationkey": -204,
"c_phone": "14-128-190-5944",
"c_acctbal": 2866.83,
"c_mktsegment": "MACHINERY",
"c_comment": " requests. final, regular ideas sleep final accou"
},
{
"entityId": -105,
"entityDt": "customerDt",
"c_name": "Customer#000000005",
"c_address": "KvpyuHCplrB84WgAiGV6sYpZq7Tj",
"c_nationkey": -203,
"c_phone": "13-750-942-6364",
"c_acctbal": 794.47,
"c_mktsegment": "HOUSEHOLD",
"c_comment": "n accounts will have to unwind. foxes cajole accor"
},
{
"entityId": -106,
"entityDt": "customerDt",
"c_name": "Customer#000000006",
"c_address": "sKZz0CsnMD7mp4Xd0YrBvx,LREYKUWAh yVn",
"c_nationkey": -2020,
"c_phone": "30-114-968-4951",
"c_acctbal": 7638.57,
"c_mktsegment": "AUTOMOBILE",
"c_comment": "tions. even deposits boost according to the slyly bold packages. final accounts cajole requests. furious"
},
{
"entityId": -107,
"entityDt": "customerDt",
"c_name": "Customer#000000007",
"c_address": "TcGe5gaZNgVePxU5kRrvXBfkasDTea",
"c_nationkey": -2018,
"c_phone": "28-190-982-9759",
"c_acctbal": 9561.95,
"c_mktsegment": "AUTOMOBILE",
"c_comment": "ainst the ironic, express theodolites. express, even pinto beans among the exp"
},
{
"entityId": -108,
"entityDt": "customerDt",
"c_name": "Customer#000000008",
"c_address": "I0B10bB0AymmC, 0PrRYBCP1yGJ8xcBPmWhl5",
"c_nationkey": -2017,
"c_phone": "27-147-574-9335",
"c_acctbal": 6819.74,
"c_mktsegment": "BUILDING",
"c_comment": "among the slyly regular theodolites kindle blithely courts. carefully even theodolites haggle slyly along the ide"
},
{
"entityId": -109,
"entityDt": "customerDt",
"c_name": "Customer#000000009",
"c_address": "xKiAFTjUsCuxfeleNqefumTrjS",
"c_nationkey": -208,
"c_phone": "18-338-906-3675",
"c_acctbal": 8324.07,
"c_mktsegment": "FURNITURE",
"c_comment": "r theodolites according to the requests wake thinly excuses: pending requests haggle furiousl"
},
{
"entityId": -1010,
"entityDt": "customerDt",
"c_name": "Customer#000000010",
"c_address": "6LrEaV6KR6PLVcgl2ArL Q3rqzLzcT1 v2",
"c_nationkey": -205,
"c_phone": "15-741-346-9870",
"c_acctbal": 2753.54,
"c_mktsegment": "HOUSEHOLD",
"c_comment": "es regular deposits haggle. fur"
},
{
"entityId": -1011,
"entityDt": "customerDt",
"c_name": "Customer#000000011",
"c_address": "PkWS 3HlXqwTuzrKg633BEi",
"c_nationkey": -2023,
"c_phone": "33-464-151-3439",
"c_acctbal": -272.60,
"c_mktsegment": "BUILDING",
"c_comment": "ckages. requests sleep slyly. quickly even pinto beans promise above the slyly regular pinto beans. "
},
{
"entityId": -1012,
"entityDt": "customerDt",
"c_name": "Customer#000000012",
"c_address": "9PWKuhzT4Zr1Q",
"c_nationkey": -2013,
"c_phone": "23-791-276-1263",
"c_acctbal": 3396.49,
"c_mktsegment": "HOUSEHOLD",
"c_comment": " to the carefully final braids. blithely regular requests nag. ironic theodolites boost quickly along"
},
{
"entityId": -1013,
"entityDt": "customerDt",
"c_name": "Customer#000000013",
"c_address": "nsXQu0oVjD7PM659uC3SRSp",
"c_nationkey": -203,
"c_phone": "13-761-547-5974",
"c_acctbal": 3857.34,
"c_mktsegment": "BUILDING",
"c_comment": "ounts sleep carefully after the close frays. carefully bold notornis use ironic requests. blithely"
},
{
"entityId": -1014,
"entityDt": "customerDt",
"c_name": "Customer#000000014",
"c_address": "KXkletMlL2JQEA ",
"c_nationkey": -201,
"c_phone": "11-845-129-3851",
"c_acctbal": 5266.30,
"c_mktsegment": "FURNITURE",
"c_comment": ", ironic packages across the unus"
},
{
"entityId": -1015,
"entityDt": "customerDt",
"c_name": "Customer#000000015",
"c_address": "YtWggXoOLdwdo7b0y,BZaGUQMLJMX1Y,EC,6Dn",
"c_nationkey": -2023,
"c_phone": "33-687-542-7601",
"c_acctbal": 2788.52,
"c_mktsegment": "HOUSEHOLD",
"c_comment": " platelets. regular deposits detect asymptotes. blithely unusual packages nag slyly at the fluf"
},
{
"entityId": -1016,
"entityDt": "customerDt",
"c_name": "Customer#000000016",
"c_address": "cYiaeMLZSMAOQ2 d0W,",
"c_nationkey": -2010,
"c_phone": "20-781-609-3107",
"c_acctbal": 4681.03,
"c_mktsegment": "FURNITURE",
"c_comment": "kly silent courts. thinly regular theodolites sleep fluffily after "
},
{
"entityId": -1017,
"entityDt": "customerDt",
"c_name": "Customer#000000017",
"c_address": "izrh 6jdqtp2eqdtbkswDD8SG4SzXruMfIXyR7",
"c_nationkey": -202,
"c_phone": "12-970-682-3487",
"c_acctbal": 6.34,
"c_mktsegment": "AUTOMOBILE",
"c_comment": "packages wake! blithely even pint"
},
{
"entityId": -1018,
"entityDt": "customerDt",
"c_name": "Customer#000000018",
"c_address": "3txGO AiuFux3zT0Z9NYaFRnZt",
"c_nationkey": -206,
"c_phone": "16-155-215-1315",
"c_acctbal": 5494.43,
"c_mktsegment": "BUILDING",
"c_comment": "s sleep. carefully even instructions nag furiously alongside of t"
},
{
"entityId": -1019,
"entityDt": "customerDt",
"c_name": "Customer#000000019",
"c_address": "uc,3bHIx84H,wdrmLOjVsiqXCq2tr",
"c_nationkey": -2018,
"c_phone": "28-396-526-5053",
"c_acctbal": 8914.71,
"c_mktsegment": "HOUSEHOLD",
"c_comment": " nag. furiously careful packages are slyly at the accounts. furiously regular in"
},
{
"entityId": -1020,
"entityDt": "customerDt",
"c_name": "Customer#000000020",
"c_address": "JrPk8Pqplj4Ne",
"c_nationkey": -2022,
"c_phone": "32-957-234-8742",
"c_acctbal": 7603.40,
"c_mktsegment": "FURNITURE",
"c_comment": "g alongside of the special excuses-- fluffily enticing packages wake "
},
{
"entityId": -1021,
"entityDt": "customerDt",
"c_name": "Customer#000000021",
"c_address": "XYmVpr9yAHDEn",
"c_nationkey": -208,
"c_phone": "18-902-614-8344",
"c_acctbal": 1428.25,
"c_mktsegment": "MACHINERY",
"c_comment": " quickly final accounts integrate blithely furiously u"
},
{
"entityId": -1022,
"entityDt": "customerDt",
"c_name": "Customer#000000022",
"c_address": "QI6p41,FNs5k7RZoCCVPUTkUdYpB",
"c_nationkey": -203,
"c_phone": "13-806-545-9701",
"c_acctbal": 591.98,
"c_mktsegment": "MACHINERY",
"c_comment": "s nod furiously above the furiously ironic ideas. "
},
{
"entityId": -1023,
"entityDt": "customerDt",
"c_name": "Customer#000000023",
"c_address": "OdY W13N7Be3OC5MpgfmcYss0Wn6TKT",
"c_nationkey": -203,
"c_phone": "13-312-472-8245",
"c_acctbal": 3332.02,
"c_mktsegment": "HOUSEHOLD",
"c_comment": "deposits. special deposits cajole slyly. fluffily special deposits about the furiously "
},
{
"entityId": -1024,
"entityDt": "customerDt",
"c_name": "Customer#000000024",
"c_address": "HXAFgIAyjxtdqwimt13Y3OZO 4xeLe7U8PqG",
"c_nationkey": -2013,
"c_phone": "23-127-851-8031",
"c_acctbal": 9255.67,
"c_mktsegment": "MACHINERY",
"c_comment": "into beans. fluffily final ideas haggle fluffily"
},
{
"entityId": -1025,
"entityDt": "customerDt",
"c_name": "Customer#000000025",
"c_address": "Hp8GyFQgGHFYSilH5tBfe",
"c_nationkey": -2012,
"c_phone": "22-603-468-3533",
"c_acctbal": 7133.70,
"c_mktsegment": "FURNITURE",
"c_comment": "y. accounts sleep ruthlessly according to the regular theodolites. unusual instructions sleep. ironic, final"
}
,
{
"l_orderkey": -301,
"l_partkey": -401,
"l_suppkey": -601,
"entityDt": "lineItemDt",
"l_linenumber": 1,
"l_quantity": 17,
"l_extendedprice": 21168.23,
"l_discount": 0.04,
"l_tax": 0.02,
"l_returnflag": "N",
"l_linestatus": "O",
"l_shipdate": "1996-03-13",
"l_commitdate": "1996-02-12",
"l_receiptdate": "1996-03-22",
"l_shipinstruct": "DELIVER IN PERSON",
"l_shipmode": "TRUCK",
"l_comment": "egular courts above the"
},
{
"l_orderkey": -301,
"l_partkey": -402,
"l_suppkey": -601,
"entityDt": "lineItemDt",
"l_linenumber": 2,
"l_quantity": 36,
"l_extendedprice": 45983.16,
"l_discount": 0.09,
"l_tax": 0.06,
"l_returnflag": "N",
"l_linestatus": "O",
"l_shipdate": "1996-04-12",
"l_commitdate": "1996-02-28",
"l_receiptdate": "1996-04-20",
"l_shipinstruct": "TAKE BACK RETURN",
"l_shipmode": "MAIL",
"l_comment": "ly final dependencies: slyly bold "
},
{
"l_orderkey": -301,
"l_partkey": -403,
"l_suppkey": -603,
"entityDt": "lineItemDt",
"l_linenumber": 3,
"l_quantity": 8,
"l_extendedprice": 13309.60,
"l_discount": 0.10,
"l_tax": 0.02,
"l_returnflag": "N",
"l_linestatus": "O",
"l_shipdate": "1996-01-29",
"l_commitdate": "1996-03-05",
"l_receiptdate": "1996-01-31",
"l_shipinstruct": "TAKE BACK RETURN",
"l_shipmode": "REG AIR",
"l_comment": "riously. regular, express dep"
},
{
"l_orderkey": -301,
"l_partkey": -401,
"l_suppkey": -604,
"entityDt": "lineItemDt",
"l_linenumber": 4,
"l_quantity": 28,
"l_extendedprice": 28955.64,
"l_discount": 0.09,
"l_tax": 0.06,
"l_returnflag": "N",
"l_linestatus": "O",
"l_shipdate": "1996-04-21",
"l_commitdate": "1996-03-30",
"l_receiptdate": "1996-05-16",
"l_shipinstruct": "NONE",
"l_shipmode": "AIR",
"l_comment": "lites. fluffily even de"
},
{
"l_orderkey": -301,
"l_partkey": -404,
"l_suppkey": -607,
"entityDt": "lineItemDt",
"l_linenumber": 5,
"l_quantity": 24,
"l_extendedprice": 22824.48,
"l_discount": 0.10,
"l_tax": 0.04,
"l_returnflag": "N",
"l_linestatus": "O",
"l_shipdate": "1996-03-30",
"l_commitdate": "1996-03-14",
"l_receiptdate": "1996-04-01",
"l_shipinstruct": "NONE",
"l_shipmode": "FOB",
"l_comment": " pending foxes. slyly re"
},
{
"l_orderkey": -301,
"l_partkey": -408,
"l_suppkey": -6021,
"entityDt": "lineItemDt",
"l_linenumber": 6,
"l_quantity": 32,
"l_extendedprice": 49620.16,
"l_discount": 0.07,
"l_tax": 0.02,
"l_returnflag": "N",
"l_linestatus": "O",
"l_shipdate": "1996-01-30",
"l_commitdate": "1996-02-07",
"l_receiptdate": "1996-02-03",
"l_shipinstruct": "DELIVER IN PERSON",
"l_shipmode": "MAIL",
"l_comment": "arefully slyly ex"
},
{
"l_orderkey": -302,
"l_partkey": -408,
"l_suppkey": -6021,
"entityDt": "lineItemDt",
"l_linenumber": 1,
"l_quantity": 38,
"l_extendedprice": 44694.46,
"l_discount": 0.00,
"l_tax": 0.05,
"l_returnflag": "N",
"l_linestatus": "O",
"l_shipdate": "1997-01-28",
"l_commitdate": "1997-01-14",
"l_receiptdate": "1997-02-02",
"l_shipinstruct": "TAKE BACK RETURN",
"l_shipmode": "RAIL",
"l_comment": "ven requests. deposits breach a"
},
{
"l_orderkey": -303,
"l_partkey": -407,
"l_suppkey": -601,
"entityDt": "lineItemDt",
"l_linenumber": 1,
"l_quantity": 45,
"l_extendedprice": 54058.05,
"l_discount": 0.06,
"l_tax": 0.00,
"l_returnflag": "R",
"l_linestatus": "F",
"l_shipdate": "1994-02-02",
"l_commitdate": "1994-01-04",
"l_receiptdate": "1994-02-23",
"l_shipinstruct": "NONE",
"l_shipmode": "AIR",
"l_comment": "ongside of the furiously brave acco"
},
{
"l_orderkey": -303,
"l_partkey": -401,
"l_suppkey": -603,
"entityDt": "lineItemDt",
"l_linenumber": 2,
"l_quantity": 49,
"l_extendedprice": 46796.47,
"l_discount": 0.10,
"l_tax": 0.00,
"l_returnflag": "R",
"l_linestatus": "F",
"l_shipdate": "1993-11-09",
"l_commitdate": "1993-12-20",
"l_receiptdate": "1993-11-24",
"l_shipinstruct": "TAKE BACK RETURN",
"l_shipmode": "RAIL",
"l_comment": " unusual accounts. eve"
},
{
"l_orderkey": -303,
"l_partkey": -403,
"l_suppkey": -603,
"entityDt": "lineItemDt",
"l_linenumber": 3,
"l_quantity": 27,
"l_extendedprice": 39890.88,
"l_discount": 0.06,
"l_tax": 0.07,
"l_returnflag": "A",
"l_linestatus": "F",
"l_shipdate": "1994-01-16",
"l_commitdate": "1993-11-22",
"l_receiptdate": "1994-01-23",
"l_shipinstruct": "DELIVER IN PERSON",
"l_shipmode": "SHIP",
"l_comment": "nal foxes wake. "
},
{
"l_orderkey": -303,
"l_partkey": -404,
"l_suppkey": -607,
"entityDt": "lineItemDt",
"l_linenumber": 4,
"l_quantity": 2,
"l_extendedprice": 2618.76,
"l_discount": 0.01,
"l_tax": 0.06,
"l_returnflag": "A",
"l_linestatus": "F",
"l_shipdate": "1993-12-04",
"l_commitdate": "1994-01-07",
"l_receiptdate": "1994-01-01",
"l_shipinstruct": "NONE",
"l_shipmode": "TRUCK",
"l_comment": "y. fluffily pending d"
},
{
"l_orderkey": -303,
"l_partkey": -402,
"l_suppkey": -6024,
"entityDt": "lineItemDt",
"l_linenumber": 5,
"l_quantity": 28,
"l_extendedprice": 32986.52,
"l_discount": 0.04,
"l_tax": 0.00,
"l_returnflag": "R",
"l_linestatus": "F",
"l_shipdate": "1993-12-14",
"l_commitdate": "1994-01-10",
"l_receiptdate": "1994-01-01",
"l_shipinstruct": "TAKE BACK RETURN",
"l_shipmode": "FOB",
"l_comment": "ages nag slyly pending"
},
{
"l_orderkey": -303,
"l_partkey": -405,
"l_suppkey": -601,
"entityDt": "lineItemDt",
"l_linenumber": 6,
"l_quantity": 26,
"l_extendedprice": 28733.64,
"l_discount": 0.10,
"l_tax": 0.02,
"l_returnflag": "A",
"l_linestatus": "F",
"l_shipdate": "1993-10-29",
"l_commitdate": "1993-12-18",
"l_receiptdate": "1993-11-04",
"l_shipinstruct": "TAKE BACK RETURN",
"l_shipmode": "RAIL",
"l_comment": "ges sleep after the caref"
},
{
"l_orderkey": -304,
"l_partkey": -401,
"l_suppkey": -601,
"entityDt": "lineItemDt",
"l_linenumber": 1,
"l_quantity": 30,
"l_extendedprice": 30690.90,
"l_discount": 0.03,
"l_tax": 0.08,
"l_returnflag": "N",
"l_linestatus": "O",
"l_shipdate": "1996-01-10",
"l_commitdate": "1995-12-14",
"l_receiptdate": "1996-01-18",
"l_shipinstruct": "DELIVER IN PERSON",
"l_shipmode": "REG AIR",
"l_comment": "- quickly regular packages sleep. idly"
},
{
"l_orderkey": -305,
"l_partkey": -408,
"l_suppkey": -6021,
"entityDt": "lineItemDt",
"l_linenumber": 1,
"l_quantity": 15,
"l_extendedprice": 23678.55,
"l_discount": 0.02,
"l_tax": 0.04,
"l_returnflag": "R",
"l_linestatus": "F",
"l_shipdate": "1994-10-31",
"l_commitdate": "1994-08-31",
"l_receiptdate": "1994-11-20",
"l_shipinstruct": "NONE",
"l_shipmode": "AIR",
"l_comment": "ts wake furiously "
},
{
"l_orderkey": -305,
"l_partkey": -401,
"l_suppkey": -601,
"entityDt": "lineItemDt",
"l_linenumber": 2,
"l_quantity": 26,
"l_extendedprice": 50723.92,
"l_discount": 0.07,
"l_tax": 0.08,
"l_returnflag": "R",
"l_linestatus": "F",
"l_shipdate": "1994-10-16",
"l_commitdate": "1994-09-25",
"l_receiptdate": "1994-10-19",
"l_shipinstruct": "NONE",
"l_shipmode": "FOB",
"l_comment": "sts use slyly quickly special instruc"
},
{
"l_orderkey": -305,
"l_partkey": -402,
"l_suppkey": -601,
"entityDt": "lineItemDt",
"l_linenumber": 3,
"l_quantity": 50,
"l_extendedprice": 73426.50,
"l_discount": 0.08,
"l_tax": 0.03,
"l_returnflag": "A",
"l_linestatus": "F",
"l_shipdate": "1994-08-08",
"l_commitdate": "1994-10-13",
"l_receiptdate": "1994-08-26",
"l_shipinstruct": "DELIVER IN PERSON",
"l_shipmode": "AIR",
"l_comment": "eodolites. fluffily unusual"
},
{
"l_orderkey": -306,
"l_partkey": -405,
"l_suppkey": -6023,
"entityDt": "lineItemDt",
"l_linenumber": 1,
"l_quantity": 37,
"l_extendedprice": 61998.31,
"l_discount": 0.08,
"l_tax": 0.03,
"l_returnflag": "A",
"l_linestatus": "F",
"l_shipdate": "1992-04-27",
"l_commitdate": "1992-05-15",
"l_receiptdate": "1992-05-02",
"l_shipinstruct": "TAKE BACK RETURN",
"l_shipmode": "TRUCK",
"l_comment": "p furiously special foxes"
},
{
"l_orderkey": -307,
"l_partkey": -401,
"l_suppkey": -601,
"entityDt": "lineItemDt",
"l_linenumber": 1,
"l_quantity": 12,
"l_extendedprice": 13608.60,
"l_discount": 0.07,
"l_tax": 0.03,
"l_returnflag": "N",
"l_linestatus": "O",
"l_shipdate": "1996-05-07",
"l_commitdate": "1996-03-13",
"l_receiptdate": "1996-06-03",
"l_shipinstruct": "TAKE BACK RETURN",
"l_shipmode": "FOB",
"l_comment": "ss pinto beans wake against th"
},
{
"l_orderkey": -307,
"l_partkey": -402,
"l_suppkey": -601,
"entityDt": "lineItemDt",
"l_linenumber": 2,
"l_quantity": 9,
"l_extendedprice": 11594.16,
"l_discount": 0.08,
"l_tax": 0.08,
"l_returnflag": "N",
"l_linestatus": "O",
"l_shipdate": "1996-02-01",
"l_commitdate": "1996-03-02",
"l_receiptdate": "1996-02-19",
"l_shipinstruct": "TAKE BACK RETURN",
"l_shipmode": "SHIP",
"l_comment": "es. instructions"
},
{
"l_orderkey": -307,
"l_partkey": -403,
"l_suppkey": -601,
"entityDt": "lineItemDt",
"l_linenumber": 3,
"l_quantity": 46,
"l_extendedprice": 81639.88,
"l_discount": 0.10,
"l_tax": 0.07,
"l_returnflag": "N",
"l_linestatus": "O",
"l_shipdate": "1996-01-15",
"l_commitdate": "1996-03-27",
"l_receiptdate": "1996-02-03",
"l_shipinstruct": "COLLECT COD",
"l_shipmode": "MAIL",
"l_comment": " unusual reques"
},
{
"l_orderkey": -307,
"l_partkey": -405,
"l_suppkey": -601,
"entityDt": "lineItemDt",
"l_linenumber": 4,
"l_quantity": 28,
"l_extendedprice": 31809.96,
"l_discount": 0.03,
"l_tax": 0.04,
"l_returnflag": "N",
"l_linestatus": "O",
"l_shipdate": "1996-03-21",
"l_commitdate": "1996-04-08",
"l_receiptdate": "1996-04-20",
"l_shipinstruct": "NONE",
"l_shipmode": "FOB",
"l_comment": ". slyly special requests haggl"
},
{
"l_orderkey": -307,
"l_partkey": -407,
"l_suppkey": -601,
"entityDt": "lineItemDt",
"l_linenumber": 5,
"l_quantity": 38,
"l_extendedprice": 73943.82,
"l_discount": 0.08,
"l_tax": 0.01,
"l_returnflag": "N",
"l_linestatus": "O",
"l_shipdate": "1996-02-11",
"l_commitdate": "1996-02-24",
"l_receiptdate": "1996-02-18",
"l_shipinstruct": "DELIVER IN PERSON",
"l_shipmode": "TRUCK",
"l_comment": "ns haggle carefully ironic deposits. bl"
},
{
"l_orderkey": -307,
"l_partkey": -408,
"l_suppkey": -6021,
"entityDt": "lineItemDt",
"l_linenumber": 6,
"l_quantity": 35,
"l_extendedprice": 43058.75,
"l_discount": 0.06,
"l_tax": 0.03,
"l_returnflag": "N",
"l_linestatus": "O",
"l_shipdate": "1996-01-16",
"l_commitdate": "1996-02-23",
"l_receiptdate": "1996-01-22",
"l_shipinstruct": "TAKE BACK RETURN",
"l_shipmode": "FOB",
"l_comment": "jole. excuses wake carefully alongside of "
},
{
"l_orderkey": -307,
"l_partkey": -404,
"l_suppkey": -608,
"entityDt": "lineItemDt",
"l_linenumber": 7,
"l_quantity": 5,
"l_extendedprice": 6476.15,
"l_discount": 0.04,
"l_tax": 0.02,
"l_returnflag": "N",
"l_linestatus": "O",
"l_shipdate": "1996-02-10",
"l_commitdate": "1996-03-26",
"l_receiptdate": "1996-02-13",
"l_shipinstruct": "NONE",
"l_shipmode": "FOB",
"l_comment": "ithely regula"
}
,
{
"entityId": -200,
"entityDt": "nationDt",
"n_name": "ALGERIA",
"n_regionkey": -500,
"n_comment": " haggle. carefully final deposits detect slyly agai"
},
{
"entityId": -201,
"entityDt": "nationDt",
"n_name": "ARGENTINA",
"n_regionkey": -501,
"n_comment": "al foxes promise slyly according to the regular accounts. bold requests alon"
},
{
"entityId": -202,
"entityDt": "nationDt",
"n_name": "BRAZIL",
"n_regionkey": -501,
"n_comment": "y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special "
},
{
"entityId": -203,
"entityDt": "nationDt",
"n_name": "CANADA",
"n_regionkey": -501,
"n_comment": "eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold"
},
{
"entityId": -204,
"entityDt": "nationDt",
"n_name": "EGYPT",
"n_regionkey": -504,
"n_comment": "y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d"
},
{
"entityId": -205,
"entityDt": "nationDt",
"n_name": "ETHIOPIA",
"n_regionkey": -500,
"n_comment": "ven packages wake quickly. regu"
},
{
"entityId": -206,
"entityDt": "nationDt",
"n_name": "FRANCE",
"n_regionkey": -503,
"n_comment": "refully final requests. regular, ironi"
},
{
"entityId": -207,
"entityDt": "nationDt",
"n_name": "GERMANY",
"n_regionkey": -503,
"n_comment": "l platelets. regular accounts x-ray: unusual, regular acco"
},
{
"entityId": -208,
"entityDt": "nationDt",
"n_name": "INDIA",
"n_regionkey": -502,
"n_comment": "ss excuses cajole slyly across the packages. deposits print aroun"
},
{
"entityId": -209,
"entityDt": "nationDt",
"n_name": "INDONESIA",
"n_regionkey": -502,
"n_comment": " slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull"
},
{
"entityId": -2010,
"entityDt": "nationDt",
"n_name": "IRAN",
"n_regionkey": -504,
"n_comment": "efully alongside of the slyly final dependencies. "
},
{
"entityId": -2011,
"entityDt": "nationDt",
"n_name": "IRAQ",
"n_regionkey": -504,
"n_comment": "nic deposits boost atop the quickly final requests? quickly regula"
},
{
"entityId": -2012,
"entityDt": "nationDt",
"n_name": "JAPAN",
"n_regionkey": -502,
"n_comment": "ously. final, express gifts cajole a"
},
{
"entityId": -2013,
"entityDt": "nationDt",
"n_name": "JORDAN",
"n_regionkey": -504,
"n_comment": "ic deposits are blithely about the carefully regular pa"
},
{
"entityId": -2014,
"entityDt": "nationDt",
"n_name": "KENYA",
"n_regionkey": -500,
"n_comment": " pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t"
},
{
"entityId": -2015,
"entityDt": "nationDt",
"n_name": "MOROCCO",
"n_regionkey": -500,
"n_comment": "rns. blithely bold courts among the closely regular packages use furiously bold platelets?"
},
{
"entityId": -2016,
"entityDt": "nationDt",
"n_name": "MOZAMBIQUE",
"n_regionkey": -500,
"n_comment": "s. ironic, unusual asymptotes wake blithely r"
},
{
"entityId": -2017,
"entityDt": "nationDt",
"n_name": "PERU",
"n_regionkey": -501,
"n_comment": "platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun"
},
{
"entityId": -2018,
"entityDt": "nationDt",
"n_name": "CHINA",
"n_regionkey": -502,
"n_comment": "c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos"
},
{
"entityId": -2019,
"entityDt": "nationDt",
"n_name": "ROMANIA",
"n_regionkey": -503,
"n_comment": "ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account"
},
{
"entityId": -2020,
"entityDt": "nationDt",
"n_name": "SAUDI ARABIA",
"n_regionkey": -504,
"n_comment": "ts. silent requests haggle. closely express packages sleep across the blithely"
},
{
"entityId": -2021,
"entityDt": "nationDt",
"n_name": "VIETNAM",
"n_regionkey": -502,
"n_comment": "hely enticingly express accounts. even, final "
},
{
"entityId": -2022,
"entityDt": "nationDt",
"n_name": "RUSSIA",
"n_regionkey": -503,
"n_comment": " requests against the platelets use never according to the quickly regular pint"
},
{
"entityId": -2023,
"entityDt": "nationDt",
"n_name": "UNITED KINGDOM",
"n_regionkey": -503,
"n_comment": "eans boost carefully special requests. accounts are. carefull"
},
{
"entityId": -2024,
"entityDt": "nationDt",
"n_name": "UNITED STATES",
"n_regionkey": -501,
"n_comment": "y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be"
}
,
{
"entityId": -301,
"entityDt": "orderDt",
"o_custkey": -101,
"o_orderstatus": "O",
"o_totalprice": 173665.47,
"o_orderdate": "1996-01-02",
"o_order-priority": "5-LOW",
"o_clerk": "Clerk#000000951",
"o_ship-priority": 0,
"o_comment": "nstructions sleep furiously among "
},
{
"entityId": -302,
"entityDt": "orderDt",
"o_custkey": -101,
"o_orderstatus": "O",
"o_totalprice": 46929.18,
"o_orderdate": "1996-12-01",
"o_order-priority": "1-URGENT",
"o_clerk": "Clerk#000000880",
"o_ship-priority": 0,
"o_comment": " foxes. pending accounts at the pending, silent asymptot"
},
{
"entityId": -303,
"entityDt": "orderDt",
"o_custkey": -101,
"o_orderstatus": "F",
"o_totalprice": 193846.25,
"o_orderdate": "1993-10-14",
"o_order-priority": "5-LOW",
"o_clerk": "Clerk#000000955",
"o_ship-priority": 0,
"o_comment": "sly final accounts boost. carefully regular ideas cajole carefully. depos"
},
{
"entityId": -304,
"entityDt": "orderDt",
"o_custkey": -101,
"o_orderstatus": "O",
"o_totalprice": 32151.78,
"o_orderdate": "1995-10-11",
"o_order-priority": "5-LOW",
"o_clerk": "Clerk#000000124",
"o_ship-priority": 0,
"o_comment": "sits. slyly regular warthogs cajole. regular, regular theodolites acro"
},
{
"entityId": -305,
"entityDt": "orderDt",
"o_custkey": -102,
"o_orderstatus": "F",
"o_totalprice": 144659.20,
"o_orderdate": "1994-07-30",
"o_order-priority": "5-LOW",
"o_clerk": "Clerk#000000925",
"o_ship-priority": 0,
"o_comment": "quickly. bold deposits sleep slyly. packages use slyly"
},
{
"entityId": -306,
"entityDt": "orderDt",
"o_custkey": -103,
"o_orderstatus": "F",
"o_totalprice": 58749.59,
"o_orderdate": "1992-02-21",
"o_order-priority": "4-NOT SPECIFIED",
"o_clerk": "Clerk#000000058",
"o_ship-priority": 0,
"o_comment": "ggle. special, final requests are against the furiously specia"
},
{
"entityId": -307,
"entityDt": "orderDt",
"o_custkey": -1025,
"o_orderstatus": "O",
"o_totalprice": 252004.18,
"o_orderdate": "1996-01-10",
"o_order-priority": "2-HIGH",
"o_clerk": "Clerk#000000470",
"o_ship-priority": 0,
"o_comment": "ly special requests "
},
{
"entityId": -3032,
"entityDt": "orderDt",
"o_custkey": -1024,
"o_orderstatus": "O",
"o_totalprice": 208660.75,
"o_orderdate": "1995-07-16",
"o_order-priority": "2-HIGH",
"o_clerk": "Clerk#000000616",
"o_ship-priority": 0,
"o_comment": "ise blithely bold, regular requests. quickly unusual dep"
},
{
"entityId": -3033,
"entityDt": "orderDt",
"o_custkey": -1024,
"o_orderstatus": "F",
"o_totalprice": 163243.98,
"o_orderdate": "1993-10-27",
"o_order-priority": "3-MEDIUM",
"o_clerk": "Clerk#000000409",
"o_ship-priority": 0,
"o_comment": "uriously. furiously final request"
},
{
"entityId": -3034,
"entityDt": "orderDt",
"o_custkey": -104,
"o_orderstatus": "O",
"o_totalprice": 58949.67,
"o_orderdate": "1998-07-21",
"o_order-priority": "3-MEDIUM",
"o_clerk": "Clerk#000000223",
"o_ship-priority": 0,
"o_comment": "ly final packages. fluffily final deposits wake blithely ideas. spe"
},
{
"entityId": -3035,
"entityDt": "orderDt",
"o_custkey": -105,
"o_orderstatus": "O",
"o_totalprice": 253724.56,
"o_orderdate": "1995-10-23",
"o_order-priority": "4-NOT SPECIFIED",
"o_clerk": "Clerk#000000259",
"o_ship-priority": 0,
"o_comment": "zzle. carefully enticing deposits nag furio"
},
{
"entityId": -3036,
"entityDt": "orderDt",
"o_custkey": -106,
"o_orderstatus": "O",
"o_totalprice": 68289.96,
"o_orderdate": "1995-11-03",
"o_order-priority": "1-URGENT",
"o_clerk": "Clerk#000000358",
"o_ship-priority": 0,
"o_comment": " quick packages are blithely. slyly silent accounts wake qu"
},
{
"entityId": -3037,
"entityDt": "orderDt",
"o_custkey": -107,
"o_orderstatus": "F",
"o_totalprice": 206680.66,
"o_orderdate": "1992-06-03",
"o_order-priority": "3-MEDIUM",
"o_clerk": "Clerk#000000456",
"o_ship-priority": 0,
"o_comment": "kly regular pinto beans. carefully unusual waters cajole never"
},
{
"entityId": -3038,
"entityDt": "orderDt",
"o_custkey": -1023,
"o_orderstatus": "O",
"o_totalprice": 82500.05,
"o_orderdate": "1996-08-21",
"o_order-priority": "4-NOT SPECIFIED",
"o_clerk": "Clerk#000000604",
"o_ship-priority": 0,
"o_comment": "haggle blithely. furiously express ideas haggle blithely furiously regular re"
},
{
"entityId": -3039,
"entityDt": "orderDt",
"o_custkey": -1022,
"o_orderstatus": "O",
"o_totalprice": 341734.47,
"o_orderdate": "1996-09-20",
"o_order-priority": "3-MEDIUM",
"o_clerk": "Clerk#000000659",
"o_ship-priority": 0,
"o_comment": "ole express, ironic requests: ir"
},
{
"entityId": -3064,
"entityDt": "orderDt",
"o_custkey": -1022,
"o_orderstatus": "F",
"o_totalprice": 39414.99,
"o_orderdate": "1994-07-16",
"o_order-priority": "3-MEDIUM",
"o_clerk": "Clerk#000000661",
"o_ship-priority": 0,
"o_comment": "wake fluffily. sometimes ironic pinto beans about the dolphin"
},
{
"entityId": -3065,
"entityDt": "orderDt",
"o_custkey": -1022,
"o_orderstatus": "P",
"o_totalprice": 110643.60,
"o_orderdate": "1995-03-18",
"o_order-priority": "1-URGENT",
"o_clerk": "Clerk#000000632",
"o_ship-priority": 0,
"o_comment": "ular requests are blithely pending orbits-- even requests against the deposit"
},
{
"entityId": -3066,
"entityDt": "orderDt",
"o_custkey": -101,
"o_orderstatus": "F",
"o_totalprice": 103740.67,
"o_orderdate": "1994-01-20",
"o_order-priority": "5-LOW",
"o_clerk": "Clerk#000000743",
"o_ship-priority": 0,
"o_comment": "y pending requests integrate"
},
{
"entityId": -3067,
"entityDt": "orderDt",
"o_custkey": -1021,
"o_orderstatus": "O",
"o_totalprice": 169405.01,
"o_orderdate": "1996-12-19",
"o_order-priority": "4-NOT SPECIFIED",
"o_clerk": "Clerk#000000547",
"o_ship-priority": 0,
"o_comment": "symptotes haggle slyly around the furiously iron"
},
{
"entityId": -3068,
"entityDt": "orderDt",
"o_custkey": -107,
"o_orderstatus": "O",
"o_totalprice": 330793.52,
"o_orderdate": "1998-04-18",
"o_order-priority": "3-MEDIUM",
"o_clerk": "Clerk#000000440",
"o_ship-priority": 0,
"o_comment": " pinto beans sleep carefully. blithely ironic deposits haggle furiously acro"
},
{
"entityId": -3069,
"entityDt": "orderDt",
"o_custkey": -108,
"o_orderstatus": "F",
"o_totalprice": 197689.49,
"o_orderdate": "1994-06-04",
"o_order-priority": "4-NOT SPECIFIED",
"o_clerk": "Clerk#000000330",
"o_ship-priority": 0,
"o_comment": " depths atop the slyly thin deposits detect among the furiously silent accou"
},
{
"entityId": -3070,
"entityDt": "orderDt",
"o_custkey": -1020,
"o_orderstatus": "F",
"o_totalprice": 113534.42,
"o_orderdate": "1993-12-18",
"o_order-priority": "5-LOW",
"o_clerk": "Clerk#000000322",
"o_ship-priority": 0,
"o_comment": " carefully ironic request"
},
{
"entityId": -3071,
"entityDt": "orderDt",
"o_custkey": -1020,
"o_orderstatus": "O",
"o_totalprice": 276992.74,
"o_orderdate": "1998-01-24",
"o_order-priority": "4-NOT SPECIFIED",
"o_clerk": "Clerk#000000271",
"o_ship-priority": 0,
"o_comment": " express deposits along the blithely regul"
},
{
"entityId": -3096,
"entityDt": "orderDt",
"o_custkey": -101,
"o_orderstatus": "F",
"o_totalprice": 68989.90,
"o_orderdate": "1994-04-17",
"o_order-priority": "2-HIGH",
"o_clerk": "Clerk#000000395",
"o_ship-priority": 0,
"o_comment": "oost furiously. pinto"
},
{
"entityId": -3097,
"entityDt": "orderDt",
"o_custkey": -1020,
"o_orderstatus": "F",
"o_totalprice": 110512.84,
"o_orderdate": "1993-01-29",
"o_order-priority": "3-MEDIUM",
"o_clerk": "Clerk#000000547",
"o_ship-priority": 0,
"o_comment": "hang blithely along the regular accounts. furiously even ideas after the"
}
,
{
"entityId": -401,
"entityDt": "partDt",
"p_name": "goldenrod lavender spring chocolate lace",
"p_mfgr": "Manufacturer#1",
"p_brand": "Brand#13",
"p_type": "PROMO BURNISHED COPPER",
"p_size": 7,
"p_container": "JUMBO PKG",
"p_retailprice": 901.00,
"p_comment": "ly. slyly ironi"
},
{
"entityId": -402,
"entityDt": "partDt",
"p_name": "maroon sky cream royal snow",
"p_mfgr": "Manufacturer#1",
"p_brand": "Brand#13",
"p_type": "LARGE BRUSHED BRASS",
"p_size": 1,
"p_container": "LG CASE",
"p_retailprice": 902.00,
"p_comment": "lar accounts amo"
},
{
"entityId": -403,
"entityDt": "partDt",
"p_name": "brown blue puff midnight black",
"p_mfgr": "Manufacturer#4",
"p_brand": "Brand#42",
"p_type": "STANDARD POLISHED BRASS",
"p_size": 21,
"p_container": "WRAP CASE",
"p_retailprice": 903.00,
"p_comment": "egular deposits hag"
},
{
"entityId": -404,
"entityDt": "partDt",
"p_name": "orange goldenrod peach misty seashell",
"p_mfgr": "Manufacturer#3",
"p_brand": "Brand#34",
"p_type": "SMALL PLATED BRASS",
"p_size": 14,
"p_container": "MED DRUM",
"p_retailprice": 904.00,
"p_comment": "p furiously r"
},
{
"entityId": -405,
"entityDt": "partDt",
"p_name": "midnight linen almond tomato plum",
"p_mfgr": "Manufacturer#3",
"p_brand": "Brand#32",
"p_type": "STANDARD POLISHED TIN",
"p_size": 15,
"p_container": "SM PKG",
"p_retailprice": 905.00,
"p_comment": " wake carefully "
},
{
"entityId": -406,
"entityDt": "partDt",
"p_name": "deep ivory light pink cream",
"p_mfgr": "Manufacturer#2",
"p_brand": "Brand#24",
"p_type": "PROMO PLATED STEEL",
"p_size": 4,
"p_container": "MED BAG",
"p_retailprice": 906.00,
"p_comment": "sual a"
},
{
"entityId": -407,
"entityDt": "partDt",
"p_name": "smoke magenta midnight purple blanched",
"p_mfgr": "Manufacturer#1",
"p_brand": "Brand#11",
"p_type": "SMALL PLATED COPPER",
"p_size": 45,
"p_container": "SM BAG",
"p_retailprice": 907.00,
"p_comment": "lyly. ex"
},
{
"entityId": -408,
"entityDt": "partDt",
"p_name": "floral moccasin violet yellow sky",
"p_mfgr": "Manufacturer#4",
"p_brand": "Brand#44",
"p_type": "PROMO BURNISHED TIN",
"p_size": 41,
"p_container": "LG DRUM",
"p_retailprice": 908.00,
"p_comment": "eposi"
},
{
"entityId": -409,
"entityDt": "partDt",
"p_name": "coral chiffon rose red saddle",
"p_mfgr": "Manufacturer#4",
"p_brand": "Brand#43",
"p_type": "SMALL BURNISHED STEEL",
"p_size": 12,
"p_container": "WRAP CASE",
"p_retailprice": 909.00,
"p_comment": "ironic foxe"
},
{
"entityId": -4010,
"entityDt": "partDt",
"p_name": "grey orchid mint purple misty",
"p_mfgr": "Manufacturer#5",
"p_brand": "Brand#54",
"p_type": "LARGE BURNISHED STEEL",
"p_size": 44,
"p_container": "LG CAN",
"p_retailprice": 910.01,
"p_comment": "ithely final deposit"
},
{
"entityId": -4011,
"entityDt": "partDt",
"p_name": "tomato navy linen grey maroon",
"p_mfgr": "Manufacturer#2",
"p_brand": "Brand#25",
"p_type": "STANDARD BURNISHED NICKEL",
"p_size": 43,
"p_container": "WRAP BOX",
"p_retailprice": 911.01,
"p_comment": "ng gr"
},
{
"entityId": -4012,
"entityDt": "partDt",
"p_name": "yellow salmon wheat blanched purple",
"p_mfgr": "Manufacturer#3",
"p_brand": "Brand#33",
"p_type": "MEDIUM ANODIZED STEEL",
"p_size": 25,
"p_container": "JUMBO CASE",
"p_retailprice": 912.01,
"p_comment": " quickly"
},
{
"entityId": -4013,
"entityDt": "partDt",
"p_name": "steel black tomato lemon aquamarine",
"p_mfgr": "Manufacturer#5",
"p_brand": "Brand#55",
"p_type": "MEDIUM BURNISHED NICKEL",
"p_size": 1,
"p_container": "JUMBO PACK",
"p_retailprice": 913.01,
"p_comment": "osits."
},
{
"entityId": -4014,
"entityDt": "partDt",
"p_name": "sienna gainsboro cornsilk lavender blush",
"p_mfgr": "Manufacturer#1",
"p_brand": "Brand#13",
"p_type": "SMALL POLISHED STEEL",
"p_size": 28,
"p_container": "JUMBO BOX",
"p_retailprice": 914.01,
"p_comment": "kages c"
},
{
"entityId": -4015,
"entityDt": "partDt",
"p_name": "ivory khaki black plum medium",
"p_mfgr": "Manufacturer#1",
"p_brand": "Brand#15",
"p_type": "LARGE ANODIZED BRASS",
"p_size": 45,
"p_container": "LG CASE",
"p_retailprice": 915.01,
"p_comment": "usual ac"
},
{
"entityId": -4016,
"entityDt": "partDt",
"p_name": "maroon cornsilk steel slate navy",
"p_mfgr": "Manufacturer#3",
"p_brand": "Brand#32",
"p_type": "PROMO PLATED TIN",
"p_size": 2,
"p_container": "MED PACK",
"p_retailprice": 916.01,
"p_comment": "unts a"
},
{
"entityId": -4017,
"entityDt": "partDt",
"p_name": "spring grey turquoise cyan magenta",
"p_mfgr": "Manufacturer#4",
"p_brand": "Brand#43",
"p_type": "ECONOMY BRUSHED STEEL",
"p_size": 16,
"p_container": "LG BOX",
"p_retailprice": 917.01,
"p_comment": " regular accounts"
},
{
"entityId": -4018,
"entityDt": "partDt",
"p_name": "pale lace powder dim ivory",
"p_mfgr": "Manufacturer#1",
"p_brand": "Brand#11",
"p_type": "SMALL BURNISHED STEEL",
"p_size": 42,
"p_container": "JUMBO PACK",
"p_retailprice": 918.01,
"p_comment": "s cajole slyly a"
},
{
"entityId": -4019,
"entityDt": "partDt",
"p_name": "hot aquamarine green khaki light",
"p_mfgr": "Manufacturer#2",
"p_brand": "Brand#23",
"p_type": "SMALL ANODIZED NICKEL",
"p_size": 33,
"p_container": "WRAP BOX",
"p_retailprice": 919.01,
"p_comment": " pending acc"
},
{
"entityId": -4020,
"entityDt": "partDt",
"p_name": "sky chiffon burnished spring powder",
"p_mfgr": "Manufacturer#1",
"p_brand": "Brand#12",
"p_type": "LARGE POLISHED NICKEL",
"p_size": 48,
"p_container": "MED BAG",
"p_retailprice": 920.02,
"p_comment": "are across the asympt"
},
{
"entityId": -4021,
"entityDt": "partDt",
"p_name": "yellow snow spring sandy antique",
"p_mfgr": "Manufacturer#3",
"p_brand": "Brand#33",
"p_type": "SMALL BURNISHED TIN",
"p_size": 31,
"p_container": "MED BAG",
"p_retailprice": 921.02,
"p_comment": "ss packages. pendin"
},
{
"entityId": -4022,
"entityDt": "partDt",
"p_name": "dark gainsboro medium cream burnished",
"p_mfgr": "Manufacturer#4",
"p_brand": "Brand#43",
"p_type": "PROMO POLISHED BRASS",
"p_size": 19,
"p_container": "LG DRUM",
"p_retailprice": 922.02,
"p_comment": " even p"
},
{
"entityId": -4023,
"entityDt": "partDt",
"p_name": "pale seashell olive chartreuse tomato",
"p_mfgr": "Manufacturer#3",
"p_brand": "Brand#35",
"p_type": "MEDIUM BURNISHED TIN",
"p_size": 42,
"p_container": "JUMBO JAR",
"p_retailprice": 923.02,
"p_comment": "nic, fina"
},
{
"entityId": -4024,
"entityDt": "partDt",
"p_name": "violet lemon grey navajo turquoise",
"p_mfgr": "Manufacturer#5",
"p_brand": "Brand#52",
"p_type": "MEDIUM PLATED STEEL",
"p_size": 20,
"p_container": "MED CASE",
"p_retailprice": 924.02,
"p_comment": " final the"
},
{
"entityId": -4025,
"entityDt": "partDt",
"p_name": "grey chocolate antique dark ghost",
"p_mfgr": "Manufacturer#5",
"p_brand": "Brand#55",
"p_type": "STANDARD BRUSHED COPPER",
"p_size": 3,
"p_container": "JUMBO BAG",
"p_retailprice": 925.02,
"p_comment": "requests wake"
}
,
{
"ps_partkey": -401,
"ps_suppkey": -601,
"entityDt": "partSupplierDt",
"ps_availqty": 3325,
"ps_supplycost": 771.64,
"ps_comment": ", even theodolites. regular, final theodolites eat after the carefully pending foxes. furiously regular deposits sleep slyly. carefully bold realms above the ironic dependencies haggle careful"
},
{
"ps_partkey": -401,
"ps_suppkey": -602,
"entityDt": "partSupplierDt",
"ps_availqty": 8076,
"ps_supplycost": 993.49,
"ps_comment": "ven ideas. quickly even packages print. pending multipliers must have to are fluff"
},
{
"ps_partkey": -401,
"ps_suppkey": -603,
"entityDt": "partSupplierDt",
"ps_availqty": 3956,
"ps_supplycost": 337.09,
"ps_comment": "after the fluffily ironic deposits? blithely special dependencies integrate furiously even excuses. blithely silent theodolites could have to haggle pending, express requests; fu"
},
{
"ps_partkey": -401,
"ps_suppkey": -604,
"entityDt": "partSupplierDt",
"ps_availqty": 4069,
"ps_supplycost": 357.84,
"ps_comment": "al, regular dependencies serve carefully after the quickly final pinto beans. furiously even deposits sleep quickly final, silent pinto beans. fluffily reg"
},
{
"ps_partkey": -402,
"ps_suppkey": -601,
"entityDt": "partSupplierDt",
"ps_availqty": 8895,
"ps_supplycost": 378.49,
"ps_comment": "nic accounts. final accounts sleep furiously about the ironic, bold packages. regular, regular accounts"
},
{
"ps_partkey": -402,
"ps_suppkey": -602,
"entityDt": "partSupplierDt",
"ps_availqty": 4969,
"ps_supplycost": 915.27,
"ps_comment": "ptotes. quickly pending dependencies integrate furiously. fluffily ironic ideas impress blithely above the express accounts. furiously even epitaphs need to wak"
},
{
"ps_partkey": -402,
"ps_suppkey": -6025,
"entityDt": "partSupplierDt",
"ps_availqty": 8539,
"ps_supplycost": 438.37,
"ps_comment": "blithely bold ideas. furiously stealthy packages sleep fluffily. slyly special deposits snooze furiously carefully regular accounts. regular deposits according to the accounts nag carefully slyl"
},
{
"ps_partkey": -402,
"ps_suppkey": -6024,
"entityDt": "partSupplierDt",
"ps_availqty": 3025,
"ps_supplycost": 306.39,
"ps_comment": "olites. deposits wake carefully. even, express requests cajole. carefully regular ex"
},
{
"ps_partkey": -403,
"ps_suppkey": -601,
"entityDt": "partSupplierDt",
"ps_availqty": 4651,
"ps_supplycost": 920.92,
"ps_comment": "ilent foxes affix furiously quickly unusual requests. even packages across the carefully even theodolites nag above the sp"
},
{
"ps_partkey": -403,
"ps_suppkey": -603,
"entityDt": "partSupplierDt",
"ps_availqty": 4093,
"ps_supplycost": 498.13,
"ps_comment": "ending dependencies haggle fluffily. regular deposits boost quickly carefully regular requests. deposits affix furiously around the pinto beans. ironic, unusual platelets across the p"
},
{
"ps_partkey": -403,
"ps_suppkey": -604,
"entityDt": "partSupplierDt",
"ps_availqty": 3917,
"ps_supplycost": 645.40,
"ps_comment": "of the blithely regular theodolites. final theodolites haggle blithely carefully unusual ideas. blithely even f"
},
{
"ps_partkey": -403,
"ps_suppkey": -605,
"entityDt": "partSupplierDt",
"ps_availqty": 9942,
"ps_supplycost": 191.92,
"ps_comment": " unusual, ironic foxes according to the ideas detect furiously alongside of the even, express requests. blithely regular the"
},
{
"ps_partkey": -404,
"ps_suppkey": -606,
"entityDt": "partSupplierDt",
"ps_availqty": 1339,
"ps_supplycost": 113.97,
"ps_comment": " carefully unusual ideas. packages use slyly. blithely final pinto beans cajole along the furiously express requests. regular orbits haggle carefully. care"
},
{
"ps_partkey": -404,
"ps_suppkey": -607,
"entityDt": "partSupplierDt",
"ps_availqty": 6377,
"ps_supplycost": 591.18,
"ps_comment": "ly final courts haggle carefully regular accounts. carefully regular accounts could integrate slyly. slyly express packages about the accounts wake slyly"
},
{
"ps_partkey": -404,
"ps_suppkey": -608,
"entityDt": "partSupplierDt",
"ps_availqty": 2694,
"ps_supplycost": 51.37,
"ps_comment": "g, regular deposits: quick instructions run across the carefully ironic theodolites-- final dependencies haggle into the dependencies. f"
},
{
"ps_partkey": -404,
"ps_suppkey": -6025,
"entityDt": "partSupplierDt",
"ps_availqty": 2480,
"ps_supplycost": 444.37,
"ps_comment": "requests sleep quickly regular accounts. theodolites detect. carefully final depths w"
},
{
"ps_partkey": -405,
"ps_suppkey": -601,
"entityDt": "partSupplierDt",
"ps_availqty": 3735,
"ps_supplycost": 255.88,
"ps_comment": "arefully even requests. ironic requests cajole carefully even dolphin"
},
{
"ps_partkey": -405,
"ps_suppkey": -6023,
"entityDt": "partSupplierDt",
"ps_availqty": 9653,
"ps_supplycost": 50.52,
"ps_comment": "y stealthy deposits. furiously final pinto beans wake furiou"
},
{
"ps_partkey": -405,
"ps_suppkey": -6022,
"entityDt": "partSupplierDt",
"ps_availqty": 1329,
"ps_supplycost": 219.83,
"ps_comment": "iously regular deposits wake deposits. pending pinto beans promise ironic dependencies. even, regular pinto beans integrate"
},
{
"ps_partkey": -405,
"ps_suppkey": -602,
"entityDt": "partSupplierDt",
"ps_availqty": 6925,
"ps_supplycost": 537.98,
"ps_comment": "sits. quickly fluffy packages wake quickly beyond the blithely regular requests. pending requests cajole among the final pinto beans. carefully busy theodolites affix quickly stealthily "
},
{
"ps_partkey": -406,
"ps_suppkey": -602,
"entityDt": "partSupplierDt",
"ps_availqty": 8851,
"ps_supplycost": 130.72,
"ps_comment": "usly final packages. slyly ironic accounts poach across the even, sly requests. carefully pending request"
},
{
"ps_partkey": -406,
"ps_suppkey": -603,
"entityDt": "partSupplierDt",
"ps_availqty": 1627,
"ps_supplycost": 424.25,
"ps_comment": " quick packages. ironic deposits print. furiously silent platelets across the carefully final requests are slyly along the furiously even instructi"
},
{
"ps_partkey": -406,
"ps_suppkey": -604,
"entityDt": "partSupplierDt",
"ps_availqty": 3336,
"ps_supplycost": 642.13,
"ps_comment": "final instructions. courts wake packages. blithely unusual realms along the multipliers nag "
},
{
"ps_partkey": -407,
"ps_suppkey": -601,
"entityDt": "partSupplierDt",
"ps_availqty": 6451,
"ps_supplycost": 175.32,
"ps_comment": " accounts alongside of the slyly even accounts wake carefully final instructions-- ruthless platelets wake carefully ideas. even deposits are quickly final,"
},
{
"ps_partkey": -408,
"ps_suppkey": -6021,
"entityDt": "partSupplierDt",
"ps_availqty": 7454,
"ps_supplycost": 763.98,
"ps_comment": "y express tithes haggle furiously even foxes. furiously ironic deposits sleep toward the furiously unusual"
}
,
{
"entityId": -500,
"entityDt": "regionDt",
"r_name": "AFRICA",
"r_comment": "lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to "
},
{
"entityId": -501,
"entityDt": "regionDt",
"r_name": "AMERICA",
"r_comment": "hs use ironic, even requests. s"
},
{
"entityId": -502,
"entityDt": "regionDt",
"r_name": "ASIA",
"r_comment": "ges. thinly even pinto beans ca"
},
{
"entityId": -503,
"entityDt": "regionDt",
"r_name": "EUROPE",
"r_comment": "ly final courts cajole furiously final excuse"
},
{
"entityId": -504,
"entityDt": "regionDt",
"r_name": "MIDDLE EAST",
"r_comment": "uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl"
}
,
{
"entityId": -601,
"entityDt": "supplierDt",
"s_name": "Supplier#000000001",
"s_address": " N kD4on9OM Ipw3,gf0JBoQDd7tgrzrddZ",
"s_nationkey": -2017,
"s_phone": "27-918-335-1736",
"s_acctbal": 5755.94,
"s_comment": "each slyly above the careful"
},
{
"entityId": -602,
"entityDt": "supplierDt",
"s_name": "Supplier#000000002",
"s_address": "89eJ5ksX3ImxJQBvxObC,",
"s_nationkey": -205,
"s_phone": "15-679-861-2259",
"s_acctbal": 4032.68,
"s_comment": " slyly bold instructions. idle dependen"
},
{
"entityId": -603,
"entityDt": "supplierDt",
"s_name": "Supplier#000000003",
"s_address": "q1,G3Pj6OjIuUYfUoH18BFTKP5aU9bEV3",
"s_nationkey": -201,
"s_phone": "11-383-516-1199",
"s_acctbal": 4192.40,
"s_comment": "blithely silent requests after the express dependencies are sl"
},
{
"entityId": -604,
"entityDt": "supplierDt",
"s_name": "Supplier#000000004",
"s_address": "Bk7ah4CK8SYQTepEmvMkkgMwg",
"s_nationkey": -2015,
"s_phone": "25-843-787-7479",
"s_acctbal": 4641.08,
"s_comment": "riously even requests above the exp"
},
{
"entityId": -605,
"entityDt": "supplierDt",
"s_name": "Supplier#000000005",
"s_address": "Gcdm2rJRzl5qlTVzc",
"s_nationkey": -2011,
"s_phone": "21-151-690-3663",
"s_acctbal": -283.84,
"s_comment": ". slyly regular pinto bea"
},
{
"entityId": -606,
"entityDt": "supplierDt",
"s_name": "Supplier#000000006",
"s_address": "tQxuVm7s7CnK",
"s_nationkey": -2014,
"s_phone": "24-696-997-4969",
"s_acctbal": 1365.79,
"s_comment": "final accounts. regular dolphins use against the furiously ironic decoys. "
},
{
"entityId": -607,
"entityDt": "supplierDt",
"s_name": "Supplier#000000007",
"s_address": "s,4TicNGB4uO6PaSqNBUq",
"s_nationkey": -2023,
"s_phone": "33-990-965-2201",
"s_acctbal": 6820.35,
"s_comment": "s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit"
},
{
"entityId": -608,
"entityDt": "supplierDt",
"s_name": "Supplier#000000008",
"s_address": "9Sq4bBH2FQEmaFOocY45sRTxo6yuoG",
"s_nationkey": -2017,
"s_phone": "27-498-742-3860",
"s_acctbal": 7627.85,
"s_comment": "al pinto beans. asymptotes haggl"
},
{
"entityId": -609,
"entityDt": "supplierDt",
"s_name": "Supplier#000000009",
"s_address": "1KhUgZegwM3ua7dsYmekYBsK",
"s_nationkey": -2010,
"s_phone": "20-403-398-8662",
"s_acctbal": 5302.37,
"s_comment": "s. unusual, even requests along the furiously regular pac"
},
{
"entityId": -6010,
"entityDt": "supplierDt",
"s_name": "Supplier#000000010",
"s_address": "Saygah3gYWMp72i PY",
"s_nationkey": -2024,
"s_phone": "34-852-489-8585",
"s_acctbal": 3891.91,
"s_comment": "ing waters. regular requests ar"
},
{
"entityId": -6011,
"entityDt": "supplierDt",
"s_name": "Supplier#000000011",
"s_address": "JfwTs,LZrV, M,9C",
"s_nationkey": -2018,
"s_phone": "28-613-996-1505",
"s_acctbal": 3393.08,
"s_comment": "y ironic packages. slyly ironic accounts affix furiously; ironically unusual excuses across the flu"
},
{
"entityId": -6012,
"entityDt": "supplierDt",
"s_name": "Supplier#000000012",
"s_address": "aLIW q0HYd",
"s_nationkey": -208,
"s_phone": "18-179-925-7181",
"s_acctbal": 1432.69,
"s_comment": "al packages nag alongside of the bold instructions. express, daring accounts"
},
{
"entityId": -6013,
"entityDt": "supplierDt",
"s_name": "Supplier#000000013",
"s_address": "HK71HQyWoqRWOX8GI FpgAifW,2PoH",
"s_nationkey": -203,
"s_phone": "13-727-620-7813",
"s_acctbal": 9107.22,
"s_comment": "requests engage regularly instructions. furiously special requests ar"
},
{
"entityId": -6014,
"entityDt": "supplierDt",
"s_name": "Supplier#000000014",
"s_address": "EXsnO5pTNj4iZRm",
"s_nationkey": -2015,
"s_phone": "25-656-247-5058",
"s_acctbal": 9189.82,
"s_comment": "l accounts boost. fluffily bold warhorses wake"
},
{
"entityId": -6015,
"entityDt": "supplierDt",
"s_name": "Supplier#000000015",
"s_address": "olXVbNBfVzRqgokr1T,Ie",
"s_nationkey": -208,
"s_phone": "18-453-357-6394",
"s_acctbal": 308.56,
"s_comment": " across the furiously regular platelets wake even deposits. quickly express she"
},
{
"entityId": -6016,
"entityDt": "supplierDt",
"s_name": "Supplier#000000016",
"s_address": "YjP5C55zHDXL7LalK27zfQnwejdpin4AMpvh",
"s_nationkey": -2022,
"s_phone": "32-822-502-4215",
"s_acctbal": 2972.26,
"s_comment": "ously express ideas haggle quickly dugouts? fu"
},
{
"entityId": -6017,
"entityDt": "supplierDt",
"s_name": "Supplier#000000017",
"s_address": "c2d,ESHRSkK3WYnxpgw6aOqN0q",
"s_nationkey": -2019,
"s_phone": "29-601-884-9219",
"s_acctbal": 1687.81,
"s_comment": "eep against the furiously bold ideas. fluffily bold packa"
},
{
"entityId": -6018,
"entityDt": "supplierDt",
"s_name": "Supplier#000000018",
"s_address": "PGGVE5PWAMwKDZw ",
"s_nationkey": -2016,
"s_phone": "26-729-551-1115",
"s_acctbal": 7040.82,
"s_comment": "accounts snooze slyly furiously bold "
},
{
"entityId": -6019,
"entityDt": "supplierDt",
"s_name": "Supplier#000000019",
"s_address": "edZT3es,nBFD8lBXTGeTl",
"s_nationkey": -2024,
"s_phone": "34-278-310-2731",
"s_acctbal": 6150.38,
"s_comment": "refully final foxes across the dogged theodolites sleep slyly abou"
},
{
"entityId": -6020,
"entityDt": "supplierDt",
"s_name": "Supplier#000000020",
"s_address": "iybAE,RmTymrZVYaFZva2SH,j",
"s_nationkey": -203,
"s_phone": "13-715-945-6730",
"s_acctbal": 530.82,
"s_comment": "n, ironic ideas would nag blithely about the slyly regular accounts. silent, expr"
},
{
"entityId": -6021,
"entityDt": "supplierDt",
"s_name": "Supplier#000000021",
"s_address": "81CavellcrJ0PQ3CPBID0Z0JwyJm0ka5igEs",
"s_nationkey": -202,
"s_phone": "12-253-590-5816",
"s_acctbal": 9365.80,
"s_comment": "d. instructions integrate sometimes slyly pending instructions. accounts nag among the "
},
{
"entityId": -6022,
"entityDt": "supplierDt",
"s_name": "Supplier#000000022",
"s_address": "okiiQFk 8lm6EVX6Q0,bEcO",
"s_nationkey": -204,
"s_phone": "14-144-830-2814",
"s_acctbal": -966.20,
"s_comment": " ironically among the deposits. closely expre"
},
{
"entityId": -6023,
"entityDt": "supplierDt",
"s_name": "Supplier#000000023",
"s_address": "ssetugTcXc096qlD7 2TL5crEEeS3zk",
"s_nationkey": -209,
"s_phone": "19-559-422-5776",
"s_acctbal": 5926.41,
"s_comment": "ges could have to are ironic deposits. regular, even request"
},
{
"entityId": -6024,
"entityDt": "supplierDt",
"s_name": "Supplier#000000024",
"s_address": "C4nPvLrVmKPPabFCj",
"s_nationkey": -200,
"s_phone": "10-620-939-2254",
"s_acctbal": 9170.71,
"s_comment": "usly pending deposits. slyly final accounts run "
},
{
"entityId": -6025,
"entityDt": "supplierDt",
"s_name": "Supplier#000000025",
"s_address": "RCQKONXMFnrodzz6w7fObFVV6CUm2q",
"s_nationkey": -2022,
"s_phone": "32-431-945-3541",
"s_acctbal": 9198.31,
"s_comment": "ely regular deposits. carefully regular sauternes engage furiously above the regular accounts. idly "
}
]
Raw
tpch.sh
#!/usr/bin/env bash
#git clone git@github.com:stratosphere/stratosphere-sopremo.git && cd stratosphere-sopremo/meteor/meteor-example/resources/tpch.json/
# join into a single file
echo '[' > o
for i in *.json; do
sed -e '1d' -e '$d' $i >> o
echo ',' >> o
done
sed -i '' -e '$d' o
echo ']' >> o
# make primary/foreign keys negative and unique
updateIds() {
sed -i '' -e "s/\($1\": \)/\1$2/g" o
}
updateIds "custkey" "-10"
updateIds "nationkey" "-20"
updateIds "orderkey" "-30"
updateIds "partkey" "-40"
updateIds "regionkey" "-50"
updateIds "suppkey" "-60"
# rename primary key fields to "entityId" & add "entityDt"
updateFields() {
addEntityDt $1 $2
renamePrimaryKey $1
}
addEntityDt() {
sed -i '' -e "/\"$1/ a\\
\ \"entityDt\": \"$2\",
" o
}
renamePrimaryKey() {
sed -i '' -e "s/\"$1/\"entityId/g" o
}
updateFields "c_custkey" "customerDt"
updateFields "n_nationkey" "nationDt"
updateFields "o_orderkey" "orderDt"
updateFields "p_partkey" "partDt"
updateFields "r_regionkey" "regionDt"
updateFields "s_suppkey" "supplierDt"
addEntityDt "ps_suppkey" "partSupplierDt"
addEntityDt "l_suppkey" "lineItemDt"
# generate output
mv o tpch.json
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment