Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `fakty_f` (
- `date` date,
- `state` string,
- `severity` int,
- `distance_id` int,
- `weather_id` int,
- `accidents_count` int,
- `distance_sum` int,
- `duration_sum` int)
- ROW FORMAT SERDE
- 'org.apache.hadoop.hive.ql.io.orc.OrcSerde'
- STORED AS INPUTFORMAT
- 'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat'
- OUTPUTFORMAT
- 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement