problem while performing union on twotables

Hi, I am trying to perform union of two tables which are having identical schemas and distinct data.There are two tables 'oldtable' and 'newtable'. The old table contains the information of old users and the new table will conatin the information of new user. I am trying to update the new entry in

Hints on whether my data is "big enough"?

I'm considering a new project, for which I'm fairly sure that a conventional, relational Data Warehouse approach will be too "small-data." But everywhere I look, it seems like it's nowhere big enough to fit "big-data" approaches, like Hive or Hadoop. Is there some FAQ or blog or wiki or war-stor

RE: Hive Not Returning Column Names, even what not using 'When'??

Hi Mark, You can use JDBC driver provided by Amazon Elastic MapReduce service. When you use that driver with SQL Squirrel it returns column names. Here are the docs on how to get that driver: http://buyitnw.appspot.com/docs.amazonwebservices.com/ElasticMapReduce/latest/DeveloperGuide/index.htm

Re: does hive support Sequence File format ?

On Thu, Feb 17, 2011 at 5:48 PM, Karthik wrote: > I have a requirement to support data from the SequenceFile "KEY" (not the > "VALUE") to be used by Hive table.  How can I do this.  From the code, it > looks like the "VALUE" part is available for Hive.  Please help. > > Regards. > > __

Re: does hive support Sequence File format ?

I have a requirement to support data from the SequenceFile "KEY" (not the "VALUE") to be used by Hive table. How can I do this. From the code, it looks like the "VALUE" part is available for Hive. Please help. Regards. From: Mapred Learn To: "user@hive.ap

Re: does hive support Sequence File format ?

Thanks Ted ! Just found it few minutes ago. On Feb 17, 2011, at 1:46 PM, Ted Yu wrote: > Look under http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL#Create_Table > > On Thu, Feb 17, 2011 at 12:00 PM, Mapred Learn wrote: > Hi, > I was wondering if hive supports Sequence File format. If yes

Re: does hive support Sequence File format ?

Look under http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL#Create_Table On Thu, Feb 17, 2011 at 12:00 PM, Mapred Learn wrote: > Hi, > I was wondering if hive supports Sequence File format. If yes, could me > point me to some documentation about how to use Seq files in hive. > > Thanks, > -J

Hive Not Returning Column Names, even what not using 'When'??

When using either Hue or using Squirrel and jdbc, I get "_col0, _col1, _col2 ..." as my columns names when querying my hive tables. I see in https://issues.apache.org/jira/browse/HIVE-1346 that this is a known issue when using the where clause, but I get in circumstances other than using a wher

does hive support Sequence File format ?

Hi, I was wondering if hive supports Sequence File format. If yes, could me point me to some documentation about how to use Seq files in hive. Thanks, -JJ

Re: Importing a file wich includes delimiter like into HIVE

ah ... try : https://issues.apache.org/jira/browse/HIVE-136 it says that one can escape using: CREATE TABLE table1 (a STRING, b STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' ESCAPED BY '\\'; Cheers, Ajo 2011/2/17 안의건 > Dear All > > Thank you for who gave me advices, but it seems th

Re: Importing a file wich includes delimiter like into HIVE

Dear All Thank you for who gave me advices, but it seems that I didn't explained my problem exactly. I have asked a question regarding 'Imporing a file wich include delimiter into HIVE'. In this case, I need to import a file wich includes " | " pipe without terminating the importing process. As