step_trainer_landing.sql

CREATE EXTERNAL TABLE IF NOT EXISTS `lakehouse`.`step_trainer_landing` (
  `sensorReadingTime` timestamp,
  `serialNumber` string,
  `distanceFromObject` int
)
ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'
WITH SERDEPROPERTIES (
  'ignore.malformed.json' = 'FALSE',
  'dots.in.keys' = 'FALSE',
  'case.insensitive' = 'TRUE',
  'mapping' = 'TRUE'
)
STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION 's3://udacity-vgonzenb-lake-house/step_trainer/landing/'
TBLPROPERTIES ('classification' = 'json');