Search Discussions
-
Hi, We have some files stored in MongoDB , mostly in key value format. We need to parse those files and store it into Hive tables. Any inputs on this will be appreciated. Thanks, Swagatika
Swagatika Tripathy
Mar 26, 2014 at 4:59 pm
Apr 1, 2014 at 8:25 am -
Im running hive from inside of maven, and am getting a weird exception: tate,fname,lname,hash(product) from cleaned1395942132407 Total MapReduce jobs = 3 Launching Job 1 out of 3 Number of reduce ...
Jay Vyas
Mar 27, 2014 at 5:44 pm
Mar 28, 2014 at 5:16 pm -
Hey everyone, before i write a lot of text, i just post something which is already written: http://www.sqlservercentral.com/Forums/Topic1328496-360-1.aspx The first posts adresses a pretty similar ...
Fab wol
Mar 5, 2014 at 1:17 pm
Mar 19, 2014 at 12:52 pm -
Hi , I have a table that has a partition column partition_hr . Data Type is int (partition_hr int) . When i run a sort on this column the output is like this. 1 10 11 12 13 14 15 16 17 18 19 2 20 21 ...
Arafat, Moiz
Mar 11, 2014 at 1:21 pm
Mar 14, 2014 at 4:15 pm -
Hi All, We have installed CDH4.2.0 and hive-0.10.0-cdh4.2.0. Both are working as desired. We need to set hive configuration parameter from Java while making JDBC connection. We have written a java ...
Garg, Rinku
Mar 4, 2014 at 11:44 am
Mar 10, 2014 at 3:00 am -
Hey everyone, I have a table with currently 5541 partitions. Daily there are 14 partitions added. I will switch the update for the metastore from "msck repair table" to "alter table add partition", ...
Fab wol
Mar 27, 2014 at 9:02 am
Mar 27, 2014 at 10:37 pm -
Hello, We are using Hive to query S3 data. For one of our tables named analyze, we generate data hierarchically. First level of hierarchy is date and second level is a field named *generated_by* ...
Saumitra Shahapure (Vizury)
Mar 25, 2014 at 10:52 am
Mar 25, 2014 at 5:30 pm -
Is there a way to read Hive Map datatype without knowing keys? According to Hive document, the only way to read a Map is to access through keys, ie: myMap['myKey']. However, in many cases, the keys ...
Frank Luo
Mar 17, 2014 at 10:06 pm
Mar 18, 2014 at 3:06 pm -
Hi, I'm trying to get the following query to work. The parser don't like it. Anybody aware of a workaround? SELECT * FROM mytable WHERE partitionCol IN my_udf("2014-03-10"); partitionCol is my ...
Petter von Dolwitz (Hem)
Mar 10, 2014 at 3:23 pm
Mar 11, 2014 at 2:22 pm -
Hi all, I'm trying to implement a udf which makes use of some data structures like binary tree. However, it seems that hive instantiates new udf object for each row in the table. Then the data ...
Sky880883368
Mar 24, 2014 at 4:34 pm
Mar 26, 2014 at 1:57 am -
Hi, I have a bunch of data already in place in a directory on HDFS containing many different logs of different types, so I'm attempting to load these externally like so: CREATE EXTERNAL TABLE mylogs ...
Oliver
Mar 24, 2014 at 3:18 pm
Mar 25, 2014 at 3:21 pm -
I have a table with 10 million rows and 2 columns - id (int) and element (string). I am trying to do a self join that finds any ids where the element values are the same, and my query looks like ...
Jeff Storey
Mar 20, 2014 at 2:04 pm
Mar 20, 2014 at 11:03 pm -
I have an input file in Sequence File format which has the format, <length of value <value which has the type <IntWritable <Text Then I created a table, CREATE TABLE if not exists TEST ( value ...
Kim Chew
Mar 8, 2014 at 1:27 am
Mar 10, 2014 at 8:40 pm -
Hello everyone, The HiveThrift Service was started succesfully. netstat -nl | grep 10000 tcp 0 0 0.0.0.0:10000 0.0.0.0:* LISTEN I am able to read tables from Hive through Tableau. When executing ...
Raj Hadoop
Mar 20, 2014 at 7:10 pm
Mar 20, 2014 at 9:52 pm -
Hi, Is it possible to write data to a local file system using Hive server 2 ? When I use 'insert overwrite local directory /tmp/hivedata ...............', it writes data in the directory on the box ...
Kumar V
Mar 14, 2014 at 12:43 pm
Mar 17, 2014 at 6:40 pm -
Hello everyone, I'm running Hive 0.12.0 and I thought that support for moving tables between database was added by using ALTER TABLE RENAME TO fully qualified name. Here is what I executing; ALTER ...
Clay McDonald
Mar 13, 2014 at 1:09 pm
Mar 14, 2014 at 2:34 pm -
I want to convert a table to a bucketed table, so I made a new table with the same schema as the old table and specified a cluster column: create table foo_bucketed ( a string, b int, c float ) ...
Keith Wiley
Mar 7, 2014 at 7:47 pm
Mar 8, 2014 at 3:45 am -
Query in HIVE I tried merge kind of operation in Hive to retain the existing records and append the new records instead of dropping the table and populating it again. If anyone can come help with any ...
Raj hadoop
Mar 6, 2014 at 8:30 am
Mar 6, 2014 at 9:16 am -
Without mapping /mounting the hbase table , how can I access and query hbase table ?
Manju M
Mar 31, 2014 at 7:12 pm
Apr 1, 2014 at 3:47 am -
Hi folks. I'm trying to wrap my head around the latest Hive architecture (as of 0.12 at least). From what I've gathered: - HiveServer2 is the new Thrift based Hive server. - We can use Thrift, JDBC, ...
Uber Slacker
Mar 28, 2014 at 3:29 pm
Mar 28, 2014 at 5:06 pm -
How can i scan one day's data from Hbase table and insert that into Hbase partition ( date) ? is it possible?
Manju M
Mar 28, 2014 at 6:34 am
Mar 28, 2014 at 9:09 am -
My join query is failing. Any suggestions on how I should troubleshoot this? 92651139753_0036_1_conf.xml to ...
Clay McDonald
Mar 24, 2014 at 6:08 pm
Mar 24, 2014 at 9:01 pm -
Hi, I'm testing out the REST interface to webhcat and stuck doing basic DDL operations. Background on installation: --I installed packages with apt-get --I'm on CDH4.5 I successfully have created and ...
Adam Silberstein
Mar 14, 2014 at 5:01 pm
Mar 19, 2014 at 7:14 pm -
Hi all, I've tried BigTop test for join_filters: CREATE TABLE myinput1(key int, value int); LOAD DATA LOCAL INPATH 'seed_data_files/in3.txt' INTO TABLE myinput1; where seed_data_files/in3.txt: 12 35 ...
Martin Kudlej
Mar 12, 2014 at 1:47 pm
Mar 13, 2014 at 1:03 am -
Hi, I have a table in hive which has data of three months old. I have partitioned the data and I got 90 partitions. Now when I get the new data from next day I want to replace the partition 1week old ...
Kasi Subrahmanyam
Mar 6, 2014 at 10:24 am
Mar 6, 2014 at 2:38 pm -
Hi team, following query hangs at 99.97% for one reducer, kindly help or point to what can be cause drop table if exists sample.dpi_short_lt;create table sample.dpi_short_lt asselect b.msisdn, ...
Siddharth Tiwari
Mar 2, 2014 at 11:09 pm
Mar 5, 2014 at 8:23 pm -
Hi, I have implemented a few custom input formats in Hive. It seems like only the getRecordReader() method of these input formats is being called though, i.e. there is no way of overriding the ...
Petter von Dolwitz (Hem)
Mar 3, 2014 at 2:14 pm
Mar 5, 2014 at 6:01 am -
I am trying to use the php hive thift client and there is name space and autoload issues. Autoload is not generated and I have not found any instructions how to properly generate it. Also some files ...
Jeremy
Mar 17, 2014 at 5:46 pm
Apr 23, 2014 at 6:07 pm -
Hello All, I have tow tables created in Hive, one read the data immidiately from Cassandra DB and the other takes the data from stored files (data already exported in somewhow from the same Cassandra ...
Amjad ALSHABANI
Mar 28, 2014 at 11:17 am
Mar 28, 2014 at 1:27 pm -
Hello, I'm trying to convert managed partitioned text table into compressed orc partitioned table. I created the a new table with the same schema but when I try inserting data the errors says there ...
P lva
Mar 26, 2014 at 3:19 pm
Mar 26, 2014 at 8:37 pm -
We use Hive-0.12 and are planning to use HiveServer2 with cloudera Hue. The scenario is like this. There are frequent additions of Hive UDFs by users and this requires frequent Hive deployment. To ...
Ashu Pachauri
Mar 11, 2014 at 11:57 pm
Mar 24, 2014 at 9:28 pm -
Hi All I am trying to query External Hive Table created on hbase ( hbase table is compressed using "gzip") . I am getting quick response, if I use "select * from hbase_acct_pref_dim_", but the query ...
Sunil Ranka
Mar 19, 2014 at 6:43 pm
Mar 22, 2014 at 2:47 am -
I'm executing a hive query in which one of the fields an array and writing it to a file using: INSERT OVERWRITE '/path/to/output' SELECT ... This query works well. I would like to load this data into ...
Jeff Storey
Mar 21, 2014 at 12:38 pm
Mar 21, 2014 at 1:19 pm -
Hello, I'm having trouble with loading data into a table with a dynamic partition with custom field delimiters. When I use tabs, it works, when I have fields delimited by '001' it does not. I'm using ...
Nurdin Premji
Mar 18, 2014 at 6:46 pm
Mar 19, 2014 at 6:27 am -
Hi, I'm using hive (with external tables) to process data stored on amazon S3. My data is partitioned as follows: DIR s3://test.com/2014-03-01/ DIR s3://test.com/2014-03-02/ DIR ...
Sherine Brisillal
Mar 11, 2014 at 7:28 am
Mar 11, 2014 at 10:54 am -
Hi, I import data from CVS files into an external ORC table. I don't have error when using those external table. Then I import those table into ORC Table. When I execute some requests I have ...
Philippe Kernévez
Mar 6, 2014 at 7:08 pm
Mar 7, 2014 at 3:42 pm -
Hi, Help required to merge data in hive, Ex: Today file ------------- Empno ename 1 abc 2 def 3 ghi Tomorrow file ----------------- Empno ename 5 abcd 6 defg 7 ghij Reg: should not drop the hive ...
Raj hadoop
Mar 5, 2014 at 12:17 pm
Mar 6, 2014 at 5:50 am -
All, I loaded data from an Oracle query through Sqoop to HDFS file. This is bzip compressed files partitioned by one column date. I created a Hive table to point to the above location. After loading ...
Raj Hadoop
Mar 4, 2014 at 10:24 pm
Mar 4, 2014 at 10:36 pm -
Hello All, I have a use case in RDBMS query which I have implemented in HIVE as.. *1.1) Update statement* *in RDBMS* update TABLE1 set Age= case when isnull(age,'') ='' then 'A= Current' else '240+ ...
Yogesh dhari
Mar 4, 2014 at 6:46 am
Mar 4, 2014 at 5:38 pm -
Hi All, I have a scenario where i have to load data into a hive table from a csv file. But the csv file is in a remote system. I am planning to use ftp to transfer the file to the system where hive ...
Vishnu Viswanath
Mar 4, 2014 at 5:04 am
Mar 4, 2014 at 7:59 am -
Congrats Xuefu! -- Lefty
Lefty Leverenz
Mar 1, 2014 at 5:38 am
Mar 3, 2014 at 6:02 pm -
Hi Team, I am seeing following error in hive in reduce phase,can you guide me on its cause and possible solution ? java.lang.RuntimeException: Hive Runtime Error while closing operators: Unable to ...
Siddharth Tiwari
Mar 1, 2014 at 9:03 am
Mar 2, 2014 at 2:50 am -
Hi, Could somebody grant me write access to the Hive wiki? I'd like to update some outdated information on the Hive Tutorial<https://cwiki.apache.org/confluence/display/Hive/Tutorial page. My Apache ...
Anthony Hsu
Mar 31, 2014 at 5:03 pm
Mar 31, 2014 at 5:08 pm -
hi,maillist: i find sometime hive drop table will take long time ,why? Time taken: 0.994 seconds hive (default) drop table t2; OK Time taken: 60.661 seconds hive (default) drop table t3; OK Time ...
Ch huang
Mar 31, 2014 at 3:03 am
Mar 31, 2014 at 5:06 am -
I have a join query where i am joining huge tables and i am trying to optimize this hive query. INSERT OVERWRITE TABLE result SELECT /*+ STREAMTABLE(product) */ i.IMAGE_ID, p.PRODUCT_NO, p.STORE_NO, ...
Srinivasan Ramaswamy
Mar 26, 2014 at 10:55 pm
Mar 28, 2014 at 10:01 am -
Are there any good documents on this? - Its easy to run hive in totally local JDBC with the 1.2 tarball, but its almost impossible it seems to run it with the 2.x hadoop tarballs. It seems like its ...
Jay Vyas
Mar 27, 2014 at 10:28 pm
Mar 27, 2014 at 10:58 pm -
Hi all, I have a table 'tabname' which has a field 'deleteDate' with type BIGINT.There are records with NULL value in this field.I want to retrieve all those records. But when I execute Query, select ...
Rishabh Bhardwaj
Mar 27, 2014 at 6:28 am
Mar 27, 2014 at 6:46 am -
Hi, Can you please help me in finding bulid.xml for installation of hive. I used following link for installation *https://cwiki.apache.org/confluence/display/Hive/AdminManual+Installation ...
Nagarjuna Vissarapu
Mar 25, 2014 at 3:42 pm
Mar 25, 2014 at 5:16 pm -
1
Hive 13
Hello. Is there a firm release date for Hive 13? I know there was talk several weeks ago about cutting a branch and looking at stability. Regards, Bryan JeffreyBryan Jeffrey
Mar 19, 2014 at 1:51 pm
Mar 21, 2014 at 6:15 pm -
just a public service announcement. I had a case where i had a nested json array in a string and i needed that to act like a first class array in hive. natively, you can pull it out but it'll just a ...
Stephen Sprague
Mar 12, 2014 at 9:21 pm
Mar 18, 2014 at 12:18 pm
Group Overview
group | user |
categories | hive, hadoop |
discussions | 87 |
posts | 270 |
users | 96 |
website | hive.apache.org |
96 users for March 2014
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)