Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
New Contributor

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?

4 REPLIES 4

avatar
Contributor

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

avatar
Champion

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 .



 

 

avatar
Contributor
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.

avatar
Champion

@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.