Re: Best way to import complex data into Hive?

2011-10-05 Thread Mark Kerzner
Wow, Steve, who could have thought?! That's hidden and undocumented, but useful. I guess "read the code, stupid" applies to me in this case. Thank you, Mark On Wed, Oct 5, 2011 at 8:12 PM, Steven Wong wrote: > > http://mail-archives.apache.org/mod_mbox/hadoop-hive-user/201009.mbox/%3c4f6b25aff

RE: Best way to import complex data into Hive?

2011-10-05 Thread Steven Wong
http://mail-archives.apache.org/mod_mbox/hadoop-hive-user/201009.mbox/%3c4f6b25afffcafe44b6259a412d5f9b101c07a...@exchmbx104.netflix.com%3E is a similar situation. Basically you have to use the default delimiters. From: Mark Kerzner [mailto:mark.kerz...@shmsoft.com] Sent: Wednesday, October 05,

Re: LOAD data into hive table

2011-10-05 Thread Mapred Learn
Yes it does Sent from my iPhone On Oct 5, 2011, at 4:21 PM, "Navin Gupta" wrote: > Do you know if partition work for external tables ? > > > > Thanks > > > > From: Mapred Learn [mailto:mapred.le...@gmail.com] > Sent: Wednesday, October 05, 2011 12:16 PM > To: user@hive.apache.org > Cc

RE: LOAD data into hive table

2011-10-05 Thread Navin Gupta
Do you know if partition work for external tables ? Thanks From: Mapred Learn [mailto:mapred.le...@gmail.com] Sent: Wednesday, October 05, 2011 12:16 PM To: user@hive.apache.org Cc: Subject: Re: LOAD data into hive table Hive external table is your solution Sent from my iPhone O

RE: ALTER TABLE tablename

2011-10-05 Thread Navin Gupta
I mean it restricts all tables to be in default database. Seems like it should work. From: Navin Gupta Sent: Wednesday, October 05, 2011 4:17 PM To: 'user@hive.apache.org' Subject: ALTER TABLE tablename Hi, Alter Table name doesn't seem to like database name prepended to it. Is there a

ALTER TABLE tablename

2011-10-05 Thread Navin Gupta
Hi, Alter Table name doesn't seem to like database name prepended to it. Is there a workaround ? thanks, Navin

Best way to import complex data into Hive?

2011-10-05 Thread Mark Kerzner
Hi, I have some transactional data, which has a few map elements, but one more complex - array of maps. Something like this CREATE EXTERNAL TABLE mytable ( log_timestamp string, price map , opt array > ) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' COLLECTION ITEMS TERMINATED BY '\004' MAP

Re: Hive Web UI 404

2011-10-05 Thread Edward Capriolo
On Wed, Oct 5, 2011 at 12:23 PM, Chalcy Raja wrote: > I second Loren's opinion. > > I had used hwi before and now using HUE. If you are considering using HUE, > here is the installation guide by Cloudera, > http://archive.cloudera.com/cdh/3/hue/manual.html > > Hope this helps, > Chalcy > > -O

Re: DDL execution error

2011-10-05 Thread Igor Tatarinov
The standard answer is Hive doesn't work on cygwin. Perhaps, some day Microsoft will make its Cosmos/Scope map-reduce project open-source (probably not). igor decide.com On Wed, Aug 17, 2011 at 3:32 PM, Siddharth tiwari wrote: > please help me out in following error, I encounter it on cygwin

DDL execution error

2011-10-05 Thread Siddharth tiwari
please help me out in following error, I encounter it on cygwin hive> show tables > ; FAILED: Hive Internal Error: java.lang.IllegalArgumentException(java.net.URISyntaxException: Relative path in absolute URI: file 03-11-05_208_1818592223695168110) java.lang.IllegalArgumentException: java.ne

Re: LOAD data into hive table

2011-10-05 Thread Mapred Learn
Hive external table is your solution Sent from my iPhone On Oct 5, 2011, at 11:29 AM, "Navin Gupta" wrote: > Hi, > >The loading of data into hive table currently moves the data if the > location is hdfs (NON LOCAL). Is there an option that would allow to copy the > data instead ? > >

LOAD data into hive table

2011-10-05 Thread Navin Gupta
Hi, The loading of data into hive table currently moves the data if the location is hdfs (NON LOCAL). Is there an option that would allow to copy the data instead ? thanks, Navin

Hadoop-Hive and sessionization

2011-10-05 Thread Ronak Bhatt
Hi - I want to use Hadoop-Hive for web log processing especially Sessionization. Can someone point me to existing available solution for the same? *thanks, ronak* * *

RE: Hive Web UI 404

2011-10-05 Thread Chalcy Raja
I second Loren's opinion. I had used hwi before and now using HUE. If you are considering using HUE, here is the installation guide by Cloudera, http://archive.cloudera.com/cdh/3/hue/manual.html Hope this helps, Chalcy -Original Message- From: Loren Siebert [mailto:lo...@siebert.org

Re: Hive Web UI 404

2011-10-05 Thread Loren Siebert
Not sure if you are interested in alternative solutions to HWI, but you might want to check out Beeswax in Hue (https://ccp.cloudera.com/display/HUE/Beeswax). On Oct 5, 2011, at 9:10 AM, wrote: > Hi, > > Trying to get the Hive Web UI running, but it 404s. Everything seems to > be configured co

Hive Web UI 404

2011-10-05 Thread jcfolsom
Hi, Trying to get the Hive Web UI running, but it 404s. Everything seems to be configured correctly running: hive --service hwi 11/10/05 11:02:43 INFO hwi.HWIServer: HWI is starting up 11/10/05 11:02:43 INFO mortbay.log: Logging to org.slf4j.impl.Log4jLoggerAdapter(org.mortbay.log) via org.mortba

set Hive DATABASE username and password

2011-10-05 Thread Ankit Jain
Hi all, I have created new database 'test' in hive. I have to authenticate this database. Thanks, Ankit

Multi character delimited output in hive

2011-10-05 Thread Bejoy Ks
Hi Experts         I'm on a hive requirement to have my output with a particular delimiter. My hive tables are with '\t' as the field delimiter and there are nearly 10 of them doing the job well in production systems. As a new requirement, we need the delimiter as a multi character string, I did