While creating a table in hive on CDH 5.8, its giving me error
ParseException Line missing ) at 'clustered' near '<EOF>'
The create table script is
create table test(id decimal, name varchar(100) ) clustered by (id) into 2 buckets stored as orc TBLPROPERTIES('transactional'='true');
I think it is more to do with hive version. Any pointers? Will this functionality work with CDH 5.12?
I tried this in CDH 5.12 and it worked perfectly fine. I am not sure of the problem you are facing though.
When ever we use ORC we go with String since it has vectorization which gives a , extra kick
try the below query sometimes copy / paste will cause issue because of the extra space that comes along with sometimes .
so type if you could
set hive.enforce.bucketing = true;
CREATE TABLE TEST (id DECIMAL,name STRING) CLUSTERED BY (id) INTO 2 BUCKETS
STORED AS ORC
I did not test query in my local vm please let me know if this helps .