ParseException Line missing ) at 'clustered' near '<EOF>'

[#1]

Hi,

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?

[#2]

Hi,

I tried this in CDH 5.12 and it worked perfectly fine. I am not sure of the problem you are facing though.

Thanks,
Ravi

[#3]

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 

Method 1


set hive.enforce.bucketing = true;

CREATE TABLE TEST (id DECIMAL,name STRING) CLUSTERED BY (id) INTO 2 BUCKETS 
STORED AS ORC 
TBLPROPERTIES("transactional"="true");


Note - 
I did not test query  in my local vm please let me know if this helps . 



 

[#4]

Can you check two things:
1. No extra tab character in your DDL.
2. Does Decimal without precision work? I remember, we give decimal(15,2) in this format. I am not able to execute it now. I can try tomorrow and update.

[#5]

@manuspark3 @SupriyaPS

 If scale is not specified, it defaults to 0 . If no precision is supplied , it defaults to 10.

Yes decimal works without precison.