e looking for. It has an import
option to load data from from any jdbc compliant database into hive. It even
creates the hive table for you by refering to the source db table.
Hope It helps!..
Regards
Bejoy K S
____
From: Aditya Singh30
mailto:aditya_sing...@infosys.c
Hi,
I want to know if there is any way to load data directly from
some other DB, say Oracle/MySQL etc., into hive tables, without getting the
data from DB into a text/rcfile/sequence file in a specific format and then
loading the data from that file into hive table.
Regards,
Adi
elect * from abcd, show tables, describe abcd, then it works
fine.
What am I doing wrong.
Thanks,
Aditya
From: Aditya Singh30
Sent: Tuesday, November 22, 2011 2:03 PM
To: 'user@hive.apache.org'
Cc: 'Sriram Krishnan'
Subject: RE: Mysql metastore configuration error.
I checked the
re are any
obvious errors. Looks like people have seen errors like this before
(http://mail-archives.apache.org/mod_mbox/hive-user/201012.mbox/%3c4d102af4.6060...@orkash.com%3E).
Are you able to run regular Hadoop jobs (I.e. non-Hive)? If you can't run
regular Hadoop jobs, you might want to star
Re: Mysql metastore configuration error.
Was that code above verbatim?
because there is a typo
Hive> Load sata local inpath 'path/to/abcd.txt' into table abcd;
(load sata not load data)
2011/11/21 Aditya Singh30
mailto:aditya_sing...@infosys.com>>
Hi Everybody,
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,
I checked the column names and the values. They are same as
they are in the table.
Do we need to install hive or add some hive libraries in hadoop's classpath on
the datanode-machines also. If yes then please guide me.
Thanks & Regards,
Aditya
From: Aditya Sin
VALUE'
regards
Vikas Srivastava
On Tue, Nov 8, 2011 at 5:17 PM, Aditya Singh30
mailto:aditya_sing...@infosys.com>> wrote:
Hi,
I have setup a two node hadoop cluster, and tested it by
running examples provided with Hadoop. Examples are working fine. then I tried
to
Hi,
I have setup a two node hadoop cluster, and tested it by
running examples provided with Hadoop. Examples are working fine. then I tried
to run hive on the cluster. I was able to create tables and load data into
tables. And also the query : "select * from tablename" is working
