· 7 years ago · Feb 22, 2019, 03:40 PM
1CREATE EXTERNAL TABLE IF NOT EXISTS TEST_TABLE 2test_attributes STRUCT<id:STRING, name:STRING, data:MAP<STRING, STRING>> 3STORED AS ORC 4LOCATION '/user/test/test_table';