Re: Hive Problem

2011-11-29 Thread Miguel Cabero
Hi Jurgen, May be you can find some hints in http://www.slideshare.net/kate_ting/habits-of-effective-sqoop-users Regards, Miguel On 29 Nov 2011, at 00:44, arv...@cloudera.com wrote: > Hi Jurgen, > > What version of Hive and Sqoop are you using? Also, please look under > /tmp/${USER}/hive.lo

Re: Converting Array to a String

2011-11-18 Thread Miguel Cabero
Hi, The easyest way I found to convert an array into a string in Hive is = something like : 1) ALTER TABLE table_name CHANGE COLUMN array_col_old_name = string_col_new_name string; 2) SELECT REPLACE(string_col_new_name, '\002', ', ') FROM table_name; Regards, Miguel On 19 Nov 2011, at 00:5

java.lang.ClassCastException: org.apache.hadoop.hive.serde2.lazy.objectinspector.LazyListObjectInspector

2011-10-17 Thread Miguel Cabero
Hello [14:39] Running a job on AWS EMR, I got the following error: java.lang.ClassCastException: org.apache.hadoop.hive.serde2.lazy.objectinspector.LazyListObjectInspector cannot be cast to org.apache.hadoop.hive.serde2.objectinspector.StandardListObjectInspector Any clues? Here is my query :

Re: "Path Is Not Legal" when loading HDFS->S3

2011-09-26 Thread Miguel Cabero
Hi Bradford, For tables stored on s3, you have to specify : create EXTERNAL table events … Regards, Miguel On 27 Sep 2011, at 00:28, Jonathan Seidman wrote: > Hey Bradford - from my experience that error occurs when there's a conflict > between the "default.fs.name" setting and the value in t

Re: Hive in EC2

2011-08-30 Thread Miguel Cabero
Hi, I set up my clusters on EC2 via with Cloudera Whirr. My hadoop.properties file is like : whirr.hardware-id=m1.xlarge # Ubuntu 10.04 LTS Lucid. See http://alestic.com/ whirr.image-id=eu-west-1/ami-1e34016a whirr.location-id=eu-west-1 whirr.service-name=hadoop whirr.cluster-name=myhadoopcluster