Created 08-28-2017 12:35 PM
I've created a table in Impala, stored as Kudu using Hue interface and trying to load data into the same from a csv file located on my HDFS folder.
However, the same is failing with the error message:
AnalysisException: LOAD DATA only supported for HDFS tables: bit_nnet.feature_matrix_100
The following is the CREATE TABLE command using:
create table if not exists bit_nnet.feature_matrix_100 ( tan string not null, ... primary key(tan) ) partition by hash(tan) partitions 4 stored as kudu;
The following is the LOAD DATA command I am using:
load data inpath '/data/feature_matrix_100.csv' into table bit_nnet.feature_matrix_100;
Created 08-28-2017 03:36 PM
As you saw in the error message, the "LOAD DATA" statement doesn't work for Kudu tables. Its documentation says as much.
I'm no Impala expert, but perhaps you can build an HDFS table around '/data/feature_matrix_100.csv' first, then SELECT that data into your Kudu table?
Created 12-02-2018 07:26 PM
Did you have solve this problem? I encounterd this also. Could you share your experience?
Created 12-06-2018 12:38 AM
You can perform CTAS - please refer the below reference
CREATE TABLE new_table PRIMARY KEY (ts, name) PARTITION BY HASH(name) PARTITIONS 8 STORED AS KUDU AS SELECT ts, name, value FROM old_table;