Reply
New Contributor
Posts: 3
Registered: ‎08-14-2017

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

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?

Explorer
Posts: 8
Registered: ‎04-26-2017

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

[ Edited ]

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

Champion
Posts: 564
Registered: ‎05-16-2016

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

[ Edited ]

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 .



 

 

New Contributor
Posts: 12
Registered: ‎09-09-2017

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

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.
Highlighted
Champion
Posts: 564
Registered: ‎05-16-2016

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

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

Announcements