Good Day This is Cazen
Is there a good way to write dynamic-skewed table?
For example, skewed table has to be set keys properties when create table
CREATE TABLE (SCHEMA) SKEWED BY (keys) ON ('c1', 'c2') [STORED AS
DIRECTORIES];
But, when I need recent 1week data to partitions, and others go ‘
External table can create without exact location or no location.
So, I guess you didn't set the location or it doesn't exist the file system
Did you set the location of table?
CREATE EXTERNAL TABLE IF NOT EXIST test_table
(
a STRING
)
LOCATION '*hdfs://aa:port/location*';
If you set the locat
