ticker_create.sql

CREATE EXTERNAL TABLE `ticker_symbols`(
  `ticker_symbol` string, 
  `sector` string, 
  `change` double, 
  `price` double, 
  `firehose` struct<record_id:string,timestamp:bigint>
)
PARTITIONED BY ( 
  `year` string, 
  `month` string, 
  `day` string, 
  `hour` string)
ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe' 
STORED AS 
  INPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat' 
  OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION 's3://stream-o-matic.data.dev/tables/ticker_symbols'
TBLPROPERTIES (
  'firehose_automation'='true', 
  'firehose_buffering_mb'='64', 
  'firehose_buffering_seconds'='60'
)