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;
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?
12-06-2018 12:38 AM