Advertisement
Guest User

Untitled

a guest
Jan 20th, 2020
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Scala 0.39 KB | None | 0 0
  1.  CREATE TABLE `fakty_f` (
  2.  `date` date,
  3.  `state` string,
  4.  `severity` int,
  5.  `distance_id` int,
  6.  `weather_id` int,
  7.  `accidents_count` int,
  8.  `distance_sum` int,
  9.  `duration_sum` int)
  10. ROW FORMAT SERDE
  11.  'org.apache.hadoop.hive.ql.io.orc.OrcSerde'
  12. STORED AS INPUTFORMAT
  13.  'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat'
  14. OUTPUTFORMAT
  15.  'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement