...@gmail.com]
*Sent:* Monday, August 03, 2015 10:50 AM
*To:* user@hive.apache.org
*Subject:* Re: External sorted tables
Based off the ddl it is required to have buckets, I was wondering if there
was a way to get around it?
Thinking as a hack I could try bucket=1, but if there is a better way
.
*From:* David Capwell [mailto:dcapw...@gmail.com]
*Sent:* Monday, August 03, 2015 11:59 AM
*To:* user@hive.apache.org
*Subject:* RE: External sorted tables
Mostly wanted to tell hive it's sorted so it could use more efficient
joins like a map side join. No other reason
On Aug 3, 2015 10:47 AM
if you can execute a mapjoin.
From: David Capwell [mailto:dcapw...@gmail.com]
Sent: Monday, August 03, 2015 11:59 AM
To: user@hive.apache.org
Subject: RE: External sorted tables
Mostly wanted to tell hive it's sorted so it could use more efficient joins
like a map side join. No other reason
Based off the ddl it is required to have buckets, I was wondering if there
was a way to get around it?
Thinking as a hack I could try bucket=1, but if there is a better way would
love to know
On Aug 2, 2015 6:18 PM, Takahiko Saito tysa...@gmail.com wrote:
Hi,
Is it possible that 'create table
, leave
out the 'sorted by' statement and you should be fine.
From: David Capwell [mailto:dcapw...@gmail.com]
Sent: Monday, August 03, 2015 10:50 AM
To: user@hive.apache.org
Subject: Re: External sorted tables
Based off the ddl it is required to have buckets, I was wondering if there was
a way
Hi,
Is it possible that 'create table sorted by' must have buckets?
I found the below statements in
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL:
The CLUSTERED BY and SORTED BY creation commands do not affect how data is
inserted into a table – only how it is read. This