create 2 tables T1 and T2.
T1 has the schema of the file - no partitioning column (say c1,c2,store#)
T2 is partitioned on (store#) - and the schema is 1 less column (c1, c2
partitioned by store#)
load the data into T1
Then
insert into T2 partition(store#) select c1,c2,store# from T1
___
On Fri, Sep 3, 2010 at 7:29 PM, Edward Capriolo wrote:
> Interesting, as you may know the web interface code is a dupe of the
> cli logic. I know at one point the vector changed from returning
> columns to returning rows, or it could have been an oversight on my
> part. No unit tests return 1000 r
Hi,
My data files have a single line (first line) of header information
followed by many lines of actual data. I am able to load the data into
hive table using RegexSerDe. But I want to save the information in the
header with every data row or use it to partition the table. How do I do
it?
Interesting, as you may know the web interface code is a dupe of the
cli logic. I know at one point the vector changed from returning
columns to returning rows, or it could have been an oversight on my
part. No unit tests return 1000 rows so no code coverage there.
I was not aware of this this tic
Hi Hive Users,
Not sure if closed jiras are attended or not I am submitting the comment
posted here (https://issues.apache.org/jira/browse/HIVE-716) to to user list
as well:
I think we might have bug in HWISessionItem.java.
I am referring to this change:
> http://svn.apache.org/viewvc/hadoop/hive
I've created two new wiki pages for a couple of topics on which questions are
coming up often now. These are just collections of links for now; feel free to
add more links/resources and expand the pages.
The various security efforts I'm aware of:
http://wiki.apache.org/hadoop/Hive/Security
Ho
On Mon, Apr 5, 2010 at 7:23 PM, Sagar Naik wrote:
> Thanks for responses,
> I am still not able to get it running
> Comments inline, Just to make sure, I did all u suggested
> Pl advise
> -Sagr
> On Apr 5, 2010, at 1:51 PM, Arvind Prabhakar wrote:
>
> Hi Sagar,
>> As a trial, I am trying to setu
