FAQ

Hive > user > September 2010

Search Discussions

77 discussions - 254 posts

  • Hi, I am trying to insert overwrite into a partitioned table reading data from a non partitioned table and seeing a failure in the second map reduce job - wonder if I am doing something wrong - any ...
    Pradeep KamathPradeep Kamath
    Sep 24, 2010 at 8:42 pm
    Sep 28, 2010 at 8:40 pm
  • I use hive0.6 version and execute 'select INPUT_FILE_NAME, BLOCK_OFFSET_INSIDE_FILE from person1' statement, hive0.6 throws below error: FAILED: Error in semantic analysis: line 1:7 Invalid Table ...
    Lei liuLei liu
    Sep 20, 2010 at 9:45 am
    Sep 20, 2010 at 6:13 pm
  • Dear all, I have encountered a serious problem while fetching Hive metadata through Eclipse. I am able to connect Hive through JDBC program in Eclipse and also able to fetch data from it. But when I ...
    Adarsh SharmaAdarsh Sharma
    Sep 20, 2010 at 6:42 am
    Nov 27, 2010 at 2:04 am
  • This worked at one time, but I now I'm having an issue: I have a basic python script for testing python/hive. The script just does a few simple things: -show tables -describe [a table] -select * from ...
    Matt TanquaryMatt Tanquary
    Sep 28, 2010 at 10:59 pm
    Sep 29, 2010 at 3:58 pm
  • Hi, hive-users, I am a new Hive users, install hive recently, when I type any query-related command in Hive cli, it throws the exception, but create table are ok: $ hive Hive history ...
    Tianqiang LiTianqiang Li
    Sep 14, 2010 at 8:42 pm
    Sep 19, 2010 at 3:50 am
  • Hi, I have quick questioin, are there any existing tools that are able to export hive table rows into table database like mysql ? I checked sqoop, but it seems it's for importing data to hadoop/hive, ...
    Tianqiang LiTianqiang Li
    Sep 20, 2010 at 8:16 pm
    Oct 4, 2010 at 5:07 pm
  • How can I control the logging level of Hive code that runs in the mappers/reducers? For example, how to set it to DEBUG? Thanks. Steven
    Steven WongSteven Wong
    Sep 26, 2010 at 6:27 am
    Sep 27, 2010 at 6:04 pm
  • Does anyone have a fix for the below error? I can see that it is caused by changes made in HIVE-675, but I can't find a patch or instructions for migrating that metastore_db that fixes the problem. ...
    Raviv M-GRaviv M-G
    Sep 28, 2010 at 6:58 am
    Sep 28, 2010 at 10:14 pm
  • Hi All, I am running hive ....version 0.5.0 (hive-default.xml: <value lib/hive-hwi-0.5.0.war</value ) When I tried to create index I've got the following message: FAILED: Parse Error: line 1:0 cannot ...
    Tali KTali K
    Sep 22, 2010 at 6:24 pm
    Sep 24, 2010 at 5:13 pm
  • Hi, i built Hive odbc driver following http://wiki.apache.org/hadoop/Hive/HiveODBC and wanted to test it with isql, but i get the following error: [ISQL]ERROR: Could not SQLAllocEnv I set ...
    Ariel LeivaAriel Leiva
    Sep 4, 2010 at 8:32 pm
    Sep 10, 2010 at 6:32 pm
  • Hi, My data files have a single line (first line) of header information followed by many lines of actual data. I am able to load the data into hive table using RegexSerDe. But I want to save the ...
    Sunil SubrahmanyamSunil Subrahmanyam
    Sep 4, 2010 at 3:12 am
    Sep 8, 2010 at 10:24 pm
  • Hi, We have Python code currently to load log data into Hive. The steps it follows are: 1) Copy log files (.gz files) to a staging directory in HDFS. We're mounting HDFS using fuse-dfs (as per ...
    Ken BarclayKen Barclay
    Sep 24, 2010 at 10:07 pm
    Sep 30, 2010 at 7:48 pm
  • Hi guys, I'm trying to create a textfile for a table with a Map<string, Map<string, string column: CREATE EXTERNAL TABLE map_test (id int, m MAP<string, MAP<string, string ) row format delimited ...
    Sammy YuSammy Yu
    Sep 10, 2010 at 6:13 pm
    Sep 11, 2010 at 2:43 am
  • I can confirm the HBase table is populated via "SELECT *" or the hbase shell. But, when I read or copy the table via a mapreduce job, there are no rows returned. I'm hoping someone would recognize ...
    Phil youngPhil young
    Sep 4, 2010 at 11:37 pm
    Sep 7, 2010 at 5:01 pm
  • Hello, I got the following exception when I made a simple query in my table. I made the table to store email header data with the following command: CREATE TABLE mytable (xfrom STRING, xto STRING, ...
    Hock ZoltánHock Zoltán
    Sep 30, 2010 at 3:46 pm
    Oct 1, 2010 at 6:15 pm
  • Hi everyone, Please this is an easy question for all of you experienced Hive Squads, why am I getting this error: <hive-bin-path $bin/hive Missing Hive Execution Jar: ...
    MahaMaha
    Sep 29, 2010 at 5:48 am
    Sep 29, 2010 at 8:15 pm
  • Hi, I am using hadoop version 0.20.2 While running query "select count(*) from table;" on Hive,i am getting this error FAILED: Execution Error, return code 2 from ...
    Vaibhav negiVaibhav negi
    Sep 28, 2010 at 2:38 pm
    Sep 29, 2010 at 6:09 am
  • Hi, Is it possible to prefix the output filenames in a hive insert query? Instead of: part-00000 I want to have: $prefix_part-00000 Regards, Gaurav Jain
    Gaurav jainGaurav jain
    Sep 28, 2010 at 10:37 pm
    Sep 28, 2010 at 11:13 pm
  • Hi, I am very new to hive, have just been able to load some data into it. I am running hadoop on a old Pentium 4 box with 4 gb RAM. It's a single node cluster, and configured based on tutorials from ...
    Sharma, RaghvendraSharma, Raghvendra
    Sep 23, 2010 at 8:25 am
    Sep 27, 2010 at 4:22 am
  • Hi, Can we insert data into a column of complex type (eg map type) through hive command line? The only related article I can find is at ...
    Ping ZhuPing Zhu
    Sep 24, 2010 at 12:12 am
    Sep 24, 2010 at 5:56 pm
  • Hi, I have customized InputFormat class to read our log format in our hadoop job and Pig, which is built on top of Hadoop 0.20 api, now I'd like to re-use this inputformat to load data into Hive ...
    Tianqiang LiTianqiang Li
    Sep 22, 2010 at 4:07 am
    Sep 22, 2010 at 6:17 am
  • I use below statement to create one table: CREATE TABLE page_view(viewTime INT, userid BIGINT, page_url STRING, referrer_url STRING, ip STRING COMMENT 'IP Address of the User') COMMENT 'This is the ...
    Lei liuLei liu
    Sep 19, 2010 at 2:14 am
    Sep 20, 2010 at 1:51 am
  • Hi all, I am new to Hive. I followed the Hive wiki tutorial but not able to insert data individually in Hive-0.5 version. As we did in Sql by insert into table values("a",11); etc Hive loads data by ...
    Adarsh SharmaAdarsh Sharma
    Sep 16, 2010 at 6:40 am
    Sep 16, 2010 at 2:08 pm
  • Hi All, We have been using Hadoop (0.20.2+320) and Hive (0.5.0+20) for about a month now to see if we could migrate our existing MySQL DB into a Hadoop/Hive architecture (hadoop/hive rock BTW! :) ). ...
    Paul ZimdarsPaul Zimdars
    Sep 14, 2010 at 5:42 am
    Sep 14, 2010 at 10:40 pm
  • I am new to Hive. I am trying to connect to Hive from a Windows JDBC client. The Hive server is running on a Linux machine. I'm getting the following error: Caused by: java.sql.SQLException: Invalid ...
    Michael StylesMichael Styles
    Sep 14, 2010 at 1:48 pm
    Sep 14, 2010 at 5:14 pm
  • Probably a silly question, If I want to apply a patch to a version I am running and there are multiple patches attached to the Jira - which one should I pick? The latest one? Example: ...
    Shrijeet PaliwalShrijeet Paliwal
    Sep 7, 2010 at 5:34 pm
    Sep 7, 2010 at 6:51 pm
  • I have two tables: pages( title, domain, url ) top_domains(domain) top_domains was created from a group by domain operation on the pages table. Because the pages table is very large, I only want to ...
    Tommy ChhengTommy Chheng
    Sep 28, 2010 at 12:51 am
    Oct 1, 2010 at 6:21 pm
  • I can create and load data into an HBase table as per the instructions from Hive/HBase Integration wiki page using something like create table ... STORED BY ...
    Leo AlekseyevLeo Alekseyev
    Sep 29, 2010 at 2:50 am
    Oct 1, 2010 at 1:45 am
  • Dear all, I have set up a Hadoop cluster of 10 nodes. I want to know that how we can read/write file from HDFS (simple). Yes I know there are commands, i read the whole HDFS commands. bin/hadoop ...
    Adarsh SharmaAdarsh Sharma
    Sep 30, 2010 at 11:59 am
    Sep 30, 2010 at 9:53 pm
  • Hi, I have noticed an issue with the JSON serde path when reviewing some code. The Json Serde include was from: add jar s3://elasticmapreduce/samples/hive-ads/libs/jsonserde.jar; and used a statement ...
    Damien AllisonDamien Allison
    Sep 30, 2010 at 1:44 pm
    Sep 30, 2010 at 7:57 pm
  • Hi all, We are sometimes getting file not found exceptions while running large queries on hive. During these large queries we also import data on the partitions we are querying which raises a ...
    Bennie SchutBennie Schut
    Sep 20, 2010 at 7:00 am
    Sep 26, 2010 at 2:12 am
  • Hi All, We are trying to fet hive 5.0 to use postgresql as a metastore, and are getting the following error: FAILED: Error in metadata: javax.jdo.JDOFatalInternalException: Error creating ...
    Tali KTali K
    Sep 23, 2010 at 10:17 pm
    Sep 23, 2010 at 11:00 pm
  • Hi, I've just started on Hive by following the wiki and trying to set it up. As mentioned in the wiki, I run "ant package". But when its run, I find that there are several versions of hadoop tarballs ...
    Chaitanya KrishnaChaitanya Krishna
    Sep 20, 2010 at 6:25 am
    Sep 20, 2010 at 5:47 pm
  • I use hive0.6 ,I want to create index on one table, how can I do ti?
    Lei liuLei liu
    Sep 20, 2010 at 10:53 am
    Sep 20, 2010 at 5:38 pm
  • hello everyone, hadoop:0.20.2 hive:0.5.0 how to solve the problem? hive create table test(AA STRING, BB STRING); Exception in thread "main" java.lang.NoSuchMethodError: ...
    ZhangGang bertzhangZhangGang bertzhang
    Sep 17, 2010 at 8:30 am
    Sep 17, 2010 at 8:33 am
  • Hi , I am running hive on hadoop 0.20.2 with 2 node cluster. I had created hadoop user and loaded data into hive. But now after two days when i am (logging with hadoop user) starting hive and running ...
    Vaibhav negiVaibhav negi
    Sep 2, 2010 at 7:37 am
    Sep 16, 2010 at 2:10 pm
  • Is it possible to specify multiple LOCATIONs for an external table. For example, if I have sequence files in the following locations: /user/abc /user/def How can I specify 2 or more hdfs_paths in the ...
    Rodriguez, JohnRodriguez, John
    Sep 15, 2010 at 4:46 pm
    Sep 15, 2010 at 6:39 pm
  • Hi guys, I'm a graduate student in University of California, Irvine. We are working on a tool to help and improve Hive query debugging experience. We'd like to understand the Hive query debugging ...
    Yingyi BuYingyi Bu
    Sep 1, 2010 at 10:45 pm
    Sep 13, 2010 at 5:35 pm
  • Hi, I'm trying to build Hive. I have CDH3 hadoop installed on my machine. My build command is: *ant package -Dtarget.dir=/home/sanjit/build/hive -Dhadoop.version=0.20.2+320 ...
    Sanjit JhalaSanjit Jhala
    Sep 10, 2010 at 9:57 pm
    Sep 13, 2010 at 5:13 pm
  • Hi Hive Users, Not sure if closed jiras are attended or not I am submitting the comment posted here (https://issues.apache.org/jira/browse/HIVE-716) to to user list as well: I think we might have bug ...
    Shrijeet PaliwalShrijeet Paliwal
    Sep 3, 2010 at 10:02 pm
    Sep 4, 2010 at 5:00 am
  • Dear all, I did not find any related statements regarding this issue either online or within trunk documentation. Anyone can confirm about this? Thanks. Ping
    Ping ZhuPing Zhu
    Sep 2, 2010 at 4:04 pm
    Sep 3, 2010 at 5:55 am
  • Hello, I'm relative new to hive & hadoop and I have written a custom InputFormat to be able to read our logfiles. I think I got everything right but when I try to execute a query on a Amazon EMR ...
    Robert HennigRobert Hennig
    Sep 1, 2010 at 1:14 pm
    Sep 2, 2010 at 10:59 am
  • Hi, I have a relatively complicated hive query using CombinedHiveInputFormat: set hive.exec.dynamic.partition.mode=nonstrict; set hive.exec.dynamic.partition=true; set ...
    Sammy YuSammy Yu
    Sep 1, 2010 at 11:34 pm
    Sep 2, 2010 at 12:40 am
  • I'm wondering if it's possible to get a sort-merge bucketized join to work when outering to a partitioned table. My goal is to be able to do an outer join from a table with 10 million rows to one ...
    Phil youngPhil young
    Sep 1, 2010 at 3:54 am
    Sep 1, 2010 at 6:01 pm
  • Hi all, Can anyone tell me how to prevent hive from deleting the intermediate outputs produced while executing an SQL query.. While running the job I can list them in the tmp/ folder but they are ...
    Bharath vBharath v
    Sep 28, 2010 at 7:58 am
    Oct 11, 2010 at 7:56 am
  • Dear hive-user's, I've written my own custom SerDe to handle some log files in a custom format and as I'd quite like to (eventually) use the JDBC driver down the line, I'd quite like to retain the ...
    Jamie CockrillJamie Cockrill
    Sep 30, 2010 at 9:21 am
    Oct 1, 2010 at 1:57 pm
  • Hi, I see the following when I compile hive trunk: model-enhance: [datanucleusenhancer] log4j:WARN No appenders could be found for logger (DataNucleus.Enhancer). [datanucleusenhancer] log4j:WARN ...
    Ted YuTed Yu
    Sep 30, 2010 at 4:44 pm
    Sep 30, 2010 at 5:08 pm
  • Hi, I am using hadoop version 0.20.2 While running query "select count(*) from table;" on Hive,i am getting this error FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql. ...
    Vaibhav negiVaibhav negi
    Sep 29, 2010 at 12:01 pm
    Sep 30, 2010 at 11:54 am
  • Hi, Do I have access to hadoop counters or JobClient if I am using a hive query either thru HIVE CLI or HIVE Java API? -- Looked into HIVE code base and looks like there are no public interfaces. ...
    Gaurav jainGaurav jain
    Sep 16, 2010 at 11:42 pm
    Sep 28, 2010 at 10:44 pm
  • Hi all, Has anyone tried compiling hive trunk for hadoop 0.21.0 ? If so can you please share the results ... I want to run hive for hadoop 0.21.0 and the website mentions that 0.5.0 works for hadoop ...
    Bharath vBharath v
    Sep 27, 2010 at 7:12 pm
    Sep 27, 2010 at 7:22 pm
Sep 2010
12
Group Navigation
period‹ prev | Sep 2010 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions77
posts254
users66
websitehive.apache.org

66 users for September 2010

Edward Capriolo: 17 posts Ning Zhang: 16 posts John Sichi: 12 posts Lei liu: 11 posts Steven Wong: 11 posts Carl Steinbach: 10 posts Yongqiang he: 10 posts Adarsh Sharma: 9 posts Pradeep Kamath: 9 posts Tianqiang Li: 9 posts Shrijeet Paliwal: 8 posts Vaibhav negi: 8 posts Phil young: 7 posts Rodriguez, John: 6 posts Leo Alekseyev: 5 posts Raviv M-G: 5 posts Sammy Yu: 5 posts Tali K: 5 posts Ariel Leiva: 4 posts Bennie Schut: 4 posts
show more
Archives