eting the data along with sorting it, or try it
> without 'sorted by' and see 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
ted by' and see 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
t;
>
> *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 to get around
, 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
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" wrote:
> Hi,
>
> Is it possible that 'create table sorted by' m
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 m
We are trying to create a external table in hive. This data is sorted,
so wanted to tell hive about this. When I do, it complains about
parsing the create.
> CREATE EXTERNAL TABLE IF NOT EXISTS store.testing (
...
. . . . . . . . . . . . . . . . . . .> timestamp bigint,
...)
. . . . . . . . . .
