IIRC sorted by is only supported on bucketed tables.
From: Mich Talebzadeh <[email protected]<mailto:[email protected]>>
Reply-To: "[email protected]<mailto:[email protected]>"
<[email protected]<mailto:[email protected]>>
Date: Tuesday, November 3, 2015 at 01:23
To: "[email protected]<mailto:[email protected]>"
<[email protected]<mailto:[email protected]>>
Subject: create table as ORC with SORTED BY fails
Hi,
Any idea why this simple create table fails?
hive> create table test (
> owner varchar(30)
> ,object_name varchar(30)
> ,object_id bigint
> )
> SORTED BY (object_id)
> STORED AS ORC
> TBLPROPERTIES ("orc.compress"="SNAPPY"
> ,"orc.create,index"="true");
FAILED: ParseException line 6:0 missing EOF at 'SORTED' near ')'
If I remove SORTED BY clause it works!
Thanks
http://talebzadehmich.wordpress.com<http://talebzadehmich.wordpress.com/>
NOTE: The information in this email is proprietary and confidential. This
message is for the designated recipient only, if you are not the intended
recipient, you should destroy it immediately. Any information in this message
shall not be understood as given or endorsed by Peridale Technology Ltd, its
subsidiaries or their employees, unless expressly so stated. It is the
responsibility of the recipient to ensure that this email is virus free,
therefore neither Peridale Ltd, its subsidiaries nor their employees accept any
responsibility.
