I tried removing the CLUSTERED directive and get the same results :( I also removed SORTED, same deal.
I'm going to try removign partitioning all together for now. On Mon, Apr 21, 2014 at 4:58 AM, Mayur Rustagi <mayur.rust...@gmail.com>wrote: > Clustering is not supported. Can you remove that & give it a go. > > Mayur Rustagi > Ph: +1 (760) 203 3257 > http://www.sigmoidanalytics.com > @mayur_rustagi <https://twitter.com/mayur_rustagi> > > > > On Mon, Apr 21, 2014 at 3:20 AM, Brad Heller <brad.hel...@gmail.com>wrote: > >> Hey list, >> >> I've got some CSV data I'm importing from S3. I can create the external >> table well enough, and I can also do a CREATE TABLE ... AS SELECT ... from >> it to pull the data internal to Spark. >> >> Here's the HQL for my external table: >> https://gist.github.com/bradhe/11126024 >> >> Now I'd like to add partitioning and clustering to my permanent table. >> So, I create a new table and try to do an INSERT ... SELECT >> >> Here's the HQL for my internal, partitioned table and the insert select: >> https://gist.github.com/bradhe/11126047 >> >> Oddly, the query is scheduled...but it never makes any progress! >> http://i.imgur.com/vXvgpzD.png >> >> Is this a bug? Am I doing something dumb? >> >> Thanks, >> Brad Heller >> > >
