D7Za4xwW

1ADD JAR hdfs:///user/my-serde.jar;
2CREATE EXTERNAL TABLE IF NOT EXISTS dev_db.expand_data_using_serde (
3  key1        STRING,
4  key2        STRING
5) PARTITIONED BY (
6  ds          STRING
7)
8ROW FORMAT SERDE 'com.....MySerDeClass'
9WITH SERDEPROPERTIES (
10  "key1" = "extract_json",
11  "key2" = "multiply_by_5"
12)
13STORED AS ORC
14LOCATION 'hdfs://dev.db/underlying_table_stored_as_orc';
15
16USE dev_db;
17MSCK REPAIR TABLE expand_data_using_serde;
18	
19SELECT key1 FROM dev_db.expand_data_using_serde;