Search Discussions
-
I am pleased to announce that Xuefu Zhang has been elected to the Hive Project Management Committee. Please join me in congratulating Xuefu! Thanks. Carl
Carl Steinbach
Feb 28, 2014 at 9:21 am
Feb 28, 2014 at 7:53 pm -
Dear experts, I want to move my hive tables from one cluster to another cluster. how can i do it? Thanks Soniya.
soniya B
Feb 28, 2014 at 2:08 am
Mar 4, 2014 at 9:05 pm -
Hi, It might happen that hiveserver2 memory gets exhausted. Similarly there would be many other things to monitor for hiveserver2. Is there any monitoring tool available in the market? I am using ...
Shouvanik Haldar
Feb 20, 2014 at 11:47 pm
Feb 21, 2014 at 5:25 pm -
Hi, I have a UDTF which works fine except when I do a query like the following : select e.* from mytable LATERAL VIEW myfunc(p1,p2,p3,p4) e as f1,f2,f3,f4 where lang=123and e.f3 < null; The error I ...
Kumar V
Feb 21, 2014 at 3:19 pm
Feb 27, 2014 at 7:06 pm -
Hi folks, We are running CDH 4.3.0 Hive (0.10.0+121) with a MySQL metastore. In Hive, we have an external table backed by HDFS which has a 3-level partitioning scheme that currently has 15000+ ...
Norbert Burger
Feb 22, 2014 at 3:06 am
Feb 27, 2014 at 2:32 pm -
Hello All, I have a use case where a table say TABLE_SQL is geting updated like. 1st Update Command update TABLE_SQL a set BALANCE = b.prev from TABLE_SQL_2 b where a.key = b.key and a.code = "1" 2nd ...
Yogesh dhari
Feb 18, 2014 at 12:40 pm
Feb 20, 2014 at 7:05 am -
i have two queries 1. select * from tab1 limit 3; this returns the 3 rows quickly withoput launcing any map reduce jobs; 2. INSERT OVERWRITE LOCAL DIRECTORY "/tmp/query1/" select * from tab1 limit ...
Sreenath
Feb 14, 2014 at 10:43 am
Feb 14, 2014 at 11:45 am -
Hi all, I'm running a query that scans a file stored in ORC format and extracts some columns. My file is about 92 GB, uncompressed. I kept the default stripe size. The MapReduce job generates 363 map ...
Avrilia Floratou
Feb 10, 2014 at 8:50 am
Feb 10, 2014 at 10:54 pm -
Hi, I am using java reducer reading from a table, and then write to another one: FROM ( FROM ( SELECT column1,... FROM table1 WHERE ( partition 6 and partition < 12 ) ) A MAP A.column1,A.... USING ...
Chen Wang
Feb 3, 2014 at 6:14 am
Feb 26, 2014 at 3:42 pm -
Hi , I have created a external table and when I provide the location of the data for this table I get the following error: FAILED: Error in metadata ...
Rishabh Bhardwaj
Feb 27, 2014 at 7:26 am
Mar 5, 2014 at 9:50 am -
Hi, I am new with Hadoop and Hive, and I am trying to figure out what is = going wrong. In my application I connect successfully to the Hive and I am able to = load data into it. When I try to run a ...
Jone Lura
Feb 21, 2014 at 9:26 am
Feb 21, 2014 at 10:09 am -
I'm working with an HBase database with a column of the form 'cf:q1:q2' where 'cf' is the column family 'q1:q2' is the column qualifier. When trying to map this in Hive I'm using a statement like the ...
Den
Feb 14, 2014 at 3:47 pm
Feb 20, 2014 at 2:12 am -
Hello, Has anyone implemented Kerberos authentication for Apache Hive? Kerberos authentication for Hadoop is documented very well, and I am able to do it. Connecting databases like MongoDb, ...
Anilkumar Kalshetti
Feb 11, 2014 at 10:33 am
Feb 17, 2014 at 5:28 pm -
Hello. I am running Hive 0.12.0 & Hadoop 2.2.0. I attempted to apply the fix described in the patch here: https://issues.apache.org/jira/secure/attachment/12617931/HIVE-5991.1.patch I applied the ...
Bryan Jeffrey
Feb 12, 2014 at 7:36 pm
Feb 13, 2014 at 6:40 pm -
Reading the Wiki (cwiki.apache.org/confluence/display/Hive/GettingStarted), it states "It does not work on Cygwin." Do further details exist or hints to make work on Windows?
Ian Jackson
Feb 4, 2014 at 4:55 pm
Feb 5, 2014 at 10:06 pm -
The Apache Hive PMC has voted to make Remus Rusanu a committer on the Apache Hive Project. Please join me in congratulating Remus! Thanks. Carl
Carl Steinbach
Feb 26, 2014 at 4:59 pm
Feb 26, 2014 at 5:23 pm -
Hello! all I wish to find a function that returns hive day of the week (Monday, Tuesday .. etc) to enter a parameter (timestamp). Anyone have an idea of how to do it? -- [image: BEEVA] *Eduardo Parra ...
Eduardo Parra Valdes | BEEVA
Feb 10, 2014 at 4:33 pm
Feb 11, 2014 at 2:31 pm -
Hi, How can I just find out the physical location of a partitioned table in Hive. Show partitions <tab name gives me just the partition column info. I want the location of the hdfs directory / files ...
Raj Hadoop
Feb 6, 2014 at 6:24 pm
Feb 6, 2014 at 8:20 pm -
Hi, I am planning to use hive for my use case, but I am confused between hive 0.12 and hive 0.11. Hive 0.12 has been there for reasonable amount of time , while hive 0.11 has been marked as stable ...
Twinkle sachdeva
Feb 27, 2014 at 7:12 am
Feb 27, 2014 at 11:00 am -
I have a partitioned table on timestamp_dt: OK ddnamesyskg string totalcount int timestamp_dt string hive select * from daily_count_per_kg_domain; OK sys_kg_band 224 20140219 sys_kg_event 3435 ...
Manish
Feb 25, 2014 at 9:14 pm
Feb 27, 2014 at 12:11 am -
I am trying to upgrade from Hive 0.10 to 0.12, but I am stuck trying to debug an error I keep getting. I have a couple of SerDes that I have developed, but when I try to query tables with these ...
Andreas Koch
Feb 23, 2014 at 12:06 pm
Feb 26, 2014 at 7:57 am -
I am trying to load 1.4M records in a 7 column CSV file into hbase. Question 1: Is this feasible? Question 2: What type of tuning on hbase and or hdfs would be needed? I am using apache hbase 0.94.15 ...
Kennedy, Sean C.
Feb 14, 2014 at 4:00 pm
Feb 17, 2014 at 2:37 pm -
Hi, I have been unsuccessful trying to setup Hive 0.12 with HBase 0.96.1.1. I am able to get both Hive and HBase to work independently of each other, but when I attempt to map a Hive table to an ...
Josh Draner
Feb 12, 2014 at 3:06 am
Feb 16, 2014 at 7:20 pm -
Hi, I am facing this situation for the below mentioned hql file - the directory) ---------- -- database pp_test_hive_metastore drop database if exists pp_test_hive_metastore cascade; create database ...
Naga Vijay
Feb 2, 2014 at 7:11 am
Feb 3, 2014 at 1:03 am -
Hi all, (Running Hive 12.0) I have two tables and both are stored as ORC. I attempted to insert via select from tbl1 to tbl2 using 'BETWEEN' in my where clause to narrow down some dates. Something ...
Martin, Nick
Feb 26, 2014 at 4:56 pm
Feb 28, 2014 at 12:38 am -
Hi, I am trying to read hive table using PIG script but when I run a pig code to read a table in hive its giving me following error 2014-02-12 15:48:36,143 [main] WARN ...
Chhaya Vishwakarma
Feb 12, 2014 at 10:33 am
Feb 26, 2014 at 6:04 pm -
Hi, I have encountered a problem when I try to deploy my application on Jetty. In my Junit test environment everything works fine, whilst deploying the same application in Jetty I receive the ...
Jone Lura
Feb 21, 2014 at 1:31 pm
Feb 26, 2014 at 12:02 pm -
Hi, I am loading data to HDFS files through sqoop and creating a Hive table to point to these files. The mapper files through sqoop example are generated like this below. part-m-00000 part-m-00001 ...
Raj Hadoop
Feb 26, 2014 at 1:45 am
Feb 26, 2014 at 3:36 am -
I am trying to create a Hive partition like 'tr_date=2014-01-01' FAILED: ParseException line 1:58 mismatched input '-' expecting ) near '2014' in add partition statement hive_ret_val: 64 Errors while ...
Raj Hadoop
Feb 26, 2014 at 1:19 am
Feb 26, 2014 at 1:38 am -
Hi, Is the Hive 0.12 release still not considered "stable"? The stable directory in the apache mirrors show Hive 0.11 as the stable version. I am testing it with Hadoop 2.2.0 and Oozie 4.0.0 which is ...
Bhaskar Dutta
Feb 25, 2014 at 2:57 pm
Feb 25, 2014 at 5:55 pm -
Hi Hive Users , I have used below 2 variables to override the location of log files. Default location is /tmp * hiveconf hive.log.dir * hiveconf hive.querylog.location= It works fine, but when I have ...
Arafat, Moiz
Feb 21, 2014 at 12:07 pm
Feb 24, 2014 at 9:50 am -
Hi, I have tried some variations of queries with aggregation function such as the following query; select max(total) from my_table; and select id, sum(total) from my_table group by id In my junit ...
Jone Lura
Feb 21, 2014 at 7:36 pm
Feb 24, 2014 at 7:54 am -
Hi, HiveServer2 is getting crashed every now and then, within an interval to 2 days or so. Is this related to memory leak or something? Developers are executing very complex queries which they ...
Shouvanik Haldar
Feb 18, 2014 at 11:19 pm
Feb 20, 2014 at 12:24 am -
Hi, I'd like to contribute update Hive's wiki. Could you give me a permission to write it? As described in HIVE-4232, we need to set "auth=noSasl" option to connect hiveserver2 from beeline. We ...
Tsuyoshi OZAWA
Feb 18, 2014 at 4:42 am
Feb 18, 2014 at 4:07 pm -
Hey all So, what I'm looking to do is get N randomly-sampled distinct values from a column in a table. I'm kind of flummoxed by how to do this without using TABLESAMPLE, which would require me to add ...
Oliver Keyes
Feb 11, 2014 at 9:08 pm
Feb 14, 2014 at 10:54 am -
Hello: While running the hive query : hive select "Actor", count (*) from metrics where array_contains(type_tuple, "Actor") and checkAttributes (attribute_tuple, "p1", "Actor") ; I get this error ...
Manish
Feb 13, 2014 at 5:16 pm
Feb 13, 2014 at 7:59 pm -
I'm working on a UDAF that takes in a constant string that defines what the final output of the UDAF will be. In the mode=PARTIAL1 call to the init function all the parameters are available and the ...
John Meagher
Feb 10, 2014 at 9:27 pm
Feb 12, 2014 at 7:33 pm -
Hi, My requirement is a typical Datawarehouse and ETL requirement. I need to accomplish 1) Daily Insert transaction records to a Hive table or a HDFS file. This table or file is not a big table ( ...
Raj Hadoop
Feb 10, 2014 at 2:46 am
Feb 10, 2014 at 1:24 pm -
I have come across a strange situation in hive and I want to know if there is an explanation. The CASE operation below does not work when the operator is != but does work then the operator is = ...
Blaine Elliott
Feb 5, 2014 at 6:50 pm
Feb 9, 2014 at 8:01 am -
Hey all, So, I'm new to hive (I come to it from MySQL/MariaDB) and I've spent the last couple of days banging my head against the problem of trying to retrieve data from a join of two tables in ...
Oliver Keyes
Feb 7, 2014 at 12:26 am
Feb 7, 2014 at 1:19 am -
I am trying to create a Hive sequence file from another table by running the following - Your query has the following error(s): OK FAILED: ParseException line 5:0 cannot recognize input near 'STORED' ...
Raj Hadoop
Feb 5, 2014 at 5:08 pm
Feb 5, 2014 at 9:15 pm -
Dear all, I created a compact index for a table with several hundred million records as follows. The table is partitioned by the month. The index on A and B was created successfully, but I can't see ...
Thilina Gunarathne
Feb 3, 2014 at 4:09 pm
Feb 4, 2014 at 3:26 pm -
Our platform has a 40GB raw data file that was compressed lzo (12GB compressed) to reduce network IO between S3. Without indexing the file is unsplittable resulting in 1 map task and poor cluster ...
KingDavies
Feb 3, 2014 at 6:20 pm
Feb 4, 2014 at 1:34 pm -
I have two clusters, but small dev clusters, and I loaded the same dataset into both of them. The data size on disk is within 2000 Bytes. Both are ORC, one is Hive 11 and one is Hive 12. One is ...
John Omernik
Feb 3, 2014 at 1:26 am
Feb 4, 2014 at 1:16 am -
Looks like hive_test is 1) mainly built to test hive only apps 2) specified for hadoop 0.2x Any one running hive_test in different environments? If so and any hints would love to adopt it ... We've ...
Jay Vyas
Feb 1, 2014 at 1:35 pm
Feb 1, 2014 at 3:23 pm -
Hi all GBK encoding data files, but the hive is UTF-8 encoding select * from table display normal I try to modify the following configuration system:file.encoding=UTF-8 system:sun.jnu.encoding=UTF-8 ...
Kun yan
Feb 20, 2014 at 3:22 am
Mar 4, 2014 at 8:09 am -
Hi, Hive 12 has added the functionality of parallel order by. I have a few queries regarding the working of it. partition table needs to created which is provided as an input to ...
Vaibhav Jain
Feb 21, 2014 at 4:32 am
Mar 4, 2014 at 8:07 am -
Hi, I'm have a flume stream that stores data in a directory which is source for an external table in hive. However flume creates tmp file that cannot be read by hive and query breaks. Is there any ...
P lva
Feb 28, 2014 at 7:09 pm
Feb 28, 2014 at 7:35 pm -
Hi all, we've experienced a bug which seems to be caused by having a query constraint involving partitioned columns. The following query results in "FAILED: NullPointerException null" being returned ...
Krishna Rao
Feb 27, 2014 at 12:45 pm
Feb 27, 2014 at 6:44 pm
Group Overview
group | user |
categories | hive, hadoop |
discussions | 93 |
posts | 301 |
users | 98 |
website | hive.apache.org |
98 users for February 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)