Hive tables do not have a 1-1 mapping to tables in MySQL. In other words, your
hive table "abcd" will NOT be a table within the MySQL "metastore" database.
If you want to see what is going on in the MySQL metastore, you can do the
following:
mysql> use metastore;
mysql> show tables;
You should
Sorry It was a typo..
I used "Load data local inpath 'path/to/abcd.txt' into table abcd;" only
Thanks for pointing it out Stephen.
Regards,
Aditya
From: Stephen Boesch [mailto:java...@gmail.com]
Sent: Tuesday, November 22, 2011 12:32 PM
To: user@hive.apache.org
Subject: Re: Mysql metastore co
Skew join did seem to work but I'm thinking other strategies would work better
like partitioning the table and/or changing the query. I got distracted with
other things though.
-Ayon
See My Photos on Flickr
Also check out my Blog for answers to commonly asked questions.
_
Was that code above *verbatim? *
because there is a typo
Hive> Load *s*ata local inpath ‘path/to/abcd.txt’ into table abcd;
(load sata not load data)
2011/11/21 Aditya Singh30
> Hi Everybody,
>
> I am using Apache’s Hadoop-0.20.2 and
> Apache’s Hive-0.7.0.
Hi Everybody,
I am using Apache's Hadoop-0.20.2 and Apache's
Hive-0.7.0. I have a 2 node cluster. One Redhat Linux 6.0(Hadoop Server) and
other Windows 7 using Cygwin. The Hadoop cluster is working fine. I have
checked by executing various examples provided with H
Hi Ayon,
Were you able to solve this issue? I am facing the same problem. The last
reducer of my query has been running for more than 2 hours now.
Thanks
Mohit
On Fri, Nov 18, 2011 at 9:33 AM, Mark Grover wrote:
> Rohan,
> I took a look at the source code and wanted to share a couple of things: