RE: RDBS and Hive

Thanks Andrew, I would really like to try the patch... From: Andrew Wilson [mailto:awil...@conductor.com] Sent: Tuesday, May 31, 2011 6:22 PM To: user@hive.apache.org Subject: Re: RDBS and Hive Yes, here is the ticket: https://issues.apache.org/jira/browse/HIVE-1555?page=com.atlassian.stream

Issue with Hive remote connection to mysql metastore

Hello All, I'm having an issue while connecting hive on (client machine) to Hadoop server running mysql based metastore. My client side configuration for hive-site.xml file are below. I'm not sure about the value i'm using for hive.metastore.uris I did not find much info on this. I saw mails usin

Hive basic questions

Hi All, I am new to Hive and have been reading http://wiki.apache.org/hadoop/Hive/Tutorial to get better understanding of Hive I am sorry for really basic questions, but I have some confusion, here are couple of questions: 1. what is difference between internal and external table in Hive?

Re: RDBS and Hive

Yes, here is the ticket: https://issues.apache.org/jira/browse/HIVE-1555?page=com.atlassian.streams.streams-jira-plugin%3Aactivity-stream-issue-tab#issue-tabs We us

Re: RDBS and Hive

There is a ticket open for a JDBC storage handler. I envision this as a sqoop on demand. Edward On Tue, May 31, 2011 at 8:31 AM, Guy Doulberg wrote: > Hey friends, > > > > I have been using Hive to explore my HDFS for a while now. > > > > In my organization we have some applicative information i

RDBS and Hive

Hey friends, I have been using Hive to explore my HDFS for a while now. In my organization we have some applicative information in SqlServer that occasionally I need to join with data I have in the HDFS. When I need to do such a join, I import the data from the SqlServer using sqoop. I wanted

question about number of map tasks for small file

Hi Guys I use flume to store log file , and use hive to query. Flume always store the small file with suffix .seq Now I have over 35 thousand seq files. Every time when I launch query script, 35 thousand map tasks will be created and it's so long time to wait for completing. I also try to set Co

Re: Question about create hive tables.

Hi dujinhang, See, http://wiki.apache.org/hadoop/Hive/UserGuide add jar ../build/contrib/hive_contrib.jar; CREATE TABLE apachelog ( host STRING, identity STRING, user STRING, time STRING, request STRING, status STRING, size STRING, referer STRING, agent STRING) ROW FORMAT SERDE

Re: Question about create hive tables.

How does the columns in the table match the "input.regex" ? In other words, which part of the regex matches the columns of the table? Will anybody offer some help? 2011/5/30 YUYANG LAN > hi, how about this ? > > (.+)&&&(.+?)(?:\^\^.*)? > > On Mon, May 30, 2011 at 6:07 PM, jinhang du wrote: