Skip to content

Instantly share code, notes, and snippets.

@tsusanto
Last active February 17, 2017 21:38
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 tsusanto/855263dd836b21ed3b71fc52424ba3c7 to your computer and use it in GitHub Desktop.
Save tsusanto/855263dd836b21ed3b71fc52424ba3c7 to your computer and use it in GitHub Desktop.
CREATE TABLE sales_lines_tenny
(
LineID STRING,
TransactionID STRING,
RetailStoreID BIGINT,
WorkstationID BIGINT,
SequenceNumber BIGINT,
BusinessDayDate STRING,
OperatorName STRING,
LineItemSequenceNumber BIGINT,
POSIDType STRING,
POSItemID STRING,
Description STRING,
TaxAmount DOUBLE,
RegularSalesUnitPrice DOUBLE,
ExtendedAmount DOUBLE,
DiscountAmount DOUBLE,
ExtendedDiscountAmount DOUBLE,
Quantity DOUBLE ,
PRIMARY KEY(LineID)
)
PARTITION BY HASH PARTITIONS 16
STORED AS KUDU
TBLPROPERTIES(
'kudu.table_name' = 'sales_lines_tenny',
'kudu.master_addresses' = 'your-kudu-master-server:7051'
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment