Impala
1. Creating a partitioned table in parquet format directly from an unpartitioned table in different format. create external table dbname.partitioned_table PARTITIONED BY ( col5,col6 ) STORED AS PARQUET LOCATION 'hdfs://nameservice/path/partitioned_table' AS select col1 , col2 , col3, col4 col5, col6 from dbname.unpartitioned_table 2. Error while accessing HIVE TEXTFILE format table in Impala. Create a TEXTFILE format table in HIVE. CREATE EXTERNAL TABLE test_impala_do ( category STRING, segment STRING, level_1 STRING, group_code INT, d_xuid_count INT, segment_code INT, datetime STRING COMMENT 'DATETIME', source_file STRING COMMENT 'SOURCE_FILE' ) PARTITIONED BY ( akey STRING COMMENT 'AKEY AS...