RE: create table as ORC with SORTED BY fails

onsibility of the recipient to ensure that this email is virus free, therefore neither Peridale Ltd, its subsidiaries nor their employees accept any responsibility. From: Prasanth Jayachandran [mailto:pjayachand...@hortonworks.com] Sent: 03 November 2015 21:15 To: user@hive.apache.org Subject: Re: cr

Re: create table as ORC with SORTED BY fails

Yes. SORTED BY can only be used with CLUSTERED BY .. into ’n’ buckets If you want to insert data in a sorted order on a specific column, you can add ORDER BY/SORT BY to the select query for the column that you want to sort. ORDER BY will use single reducer but you will get global ordering where

Re: create table as ORC with SORTED BY fails

IIRC sorted by is only supported on bucketed tables. From: Mich Talebzadeh mailto:m...@peridale.co.uk>> Reply-To: "user@hive.apache.org" mailto:user@hive.apache.org>> Date: Tuesday, November 3, 2015 at 01:23 To: "user@hive.apache.org" mai