impala versoin: cdh5.10.0
kudu verson: 1.3.0-SNAPSHOT

Create the table by  kudu api, it is ok:
    builder = kudu.schema_builder()
    builder.add_column('key').type(kudu.int64).nullable(False).primary_key()
    builder.add_column('id1').type(kudu.int8).nullable(False)
    builder.add_column('id2').type(kudu.int32).nullable(False)
    builder.add_column('id3').type(kudu.int16).nullable(False)
    builder.add_column('id4').type(kudu.float).nullable(False)
    builder.add_column('id5').type(kudu.double).nullable(False)
    builder.add_column('id6').type(kudu.bool).nullable(False)
    builder.add_column('str', type_=kudu.string, nullable=False, 
compression='lz4')
    builder.add_column('time', type_=kudu.unixtime_micros, nullable=False, 
compression='lz4')
    schema = builder.build()


However, when I create a kudu table from impala-shell, I will report errors:
[db.sky.org:21000] > create table test(id int primary key,id2 binary) partition 
by hash partitions 8 stored as kudu;
Query: create table test(id int primary key,id2 binary) partition by hash 
partitions 8 stored as kudu
ERROR: AnalysisException: Unsupported data type: BINARY
[db.sky.org:21000] > create external table test stored as kudu 
TBLPROPERTIES('kudu.table_name'='test_type');
Query: create external table test stored as kudu 
TBLPROPERTIES('kudu.table_name'='test_type')
ERROR: 
ImpalaRuntimeException: Error loading schema of table 'test_type'
CAUSED BY: ImpalaRuntimeException: Kudu type 'bool' is not supported in Impala
[db.sky.org:21000] > 
I found that, in addition to integer and string type, the other kudu field 
types can not be supported in the impala-shell.why ?

Reply via email to