Search Discussions
-
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 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 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 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 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 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 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 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-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 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 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 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 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 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 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á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: ...
Maha
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 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 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, 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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, 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 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 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 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 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 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 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 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 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 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 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 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 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 v
Sep 27, 2010 at 7:12 pm
Sep 27, 2010 at 7:22 pm
Group Overview
group | user |
categories | hive, hadoop |
discussions | 77 |
posts | 254 |
users | 66 |
website | hive.apache.org |
66 users for September 2010
Archives
- June 2016 (177)
- May 2016 (265)
- April 2016 (244)
- March 2016 (368)
- February 2016 (323)
- January 2016 (323)
- December 2015 (347)
- November 2015 (305)
- October 2015 (279)
- September 2015 (386)
- August 2015 (291)
- July 2015 (176)
- June 2015 (305)
- May 2015 (227)
- April 2015 (345)
- March 2015 (332)
- February 2015 (230)
- January 2015 (129)
- December 2014 (252)
- November 2014 (196)
- October 2014 (252)
- September 2014 (288)
- August 2014 (265)
- July 2014 (389)
- June 2014 (274)
- May 2014 (203)
- April 2014 (296)
- March 2014 (270)
- February 2014 (301)
- January 2014 (252)
- December 2013 (230)
- November 2013 (222)
- October 2013 (275)
- September 2013 (315)
- August 2013 (364)
- July 2013 (419)
- June 2013 (407)
- May 2013 (319)
- April 2013 (206)
- March 2013 (344)
- February 2013 (268)
- January 2013 (318)
- December 2012 (313)
- November 2012 (244)
- October 2012 (318)
- September 2012 (373)
- August 2012 (380)
- July 2012 (487)
- June 2012 (454)
- May 2012 (458)
- April 2012 (343)
- March 2012 (337)
- February 2012 (207)
- January 2012 (265)
- December 2011 (235)
- November 2011 (182)
- October 2011 (199)
- September 2011 (211)
- August 2011 (277)
- July 2011 (152)
- June 2011 (149)
- May 2011 (244)
- April 2011 (127)
- March 2011 (265)
- February 2011 (284)
- January 2011 (235)
- December 2010 (143)
- November 2010 (137)
- October 2010 (231)
- September 2010 (254)
- August 2010 (278)
- July 2010 (161)
- June 2010 (262)
- May 2010 (132)
- April 2010 (126)
- March 2010 (178)
- February 2010 (366)
- January 2010 (156)
- December 2009 (110)
- November 2009 (146)
- October 2009 (252)
- September 2009 (215)
- August 2009 (187)
- July 2009 (322)
- June 2009 (106)
- May 2009 (97)
- April 2009 (160)
- March 2009 (173)
- February 2009 (139)
- January 2009 (152)
- December 2008 (105)
- November 2008 (33)