FAQ

Search Discussions

63 discussions - 196 posts

  • Hi, The 0.14.0 distribution does not come up with the hwi .war file, but I end up with the following error when trying to build myself [xiaobogu@lix3 hwi]$ pwd ...
    Guxiaobo1982Guxiaobo1982
    Nov 29, 2014 at 12:49 pm
    Dec 4, 2014 at 7:12 am
  • Hi Users, *my cluster(1+8) configuration*: RAM : 32 GB each HDFS : 1.5 TB SSD CPU : 8 core each ----------------------------------------------- I am trying to query on 300GB of table but I am able to ...
    Amit BeheraAmit Behera
    Nov 24, 2014 at 4:50 pm
    Nov 24, 2014 at 8:28 pm
  • Hi I am using hive -0.14.0 which support UPDATE statement but I am getting an error once I did this Command UPDATE Emp SET salary = 50000 WHERE employeeid = 19; FAILED: SemanticException [Error ...
    Unmesha sreeveniUnmesha sreeveni
    Nov 24, 2014 at 8:13 am
    Dec 3, 2014 at 4:26 am
  • Hi, I have a table which ended up having 3K+ columns. The building of the table wasn't that painful, but the part where things suck is when creating VIEWs on top of that table. 1 of the views that I ...
    Viral BajariaViral Bajaria
    Nov 26, 2014 at 7:24 pm
    Dec 10, 2014 at 11:08 pm
  • Hi All, I am using Hive 0.13.1 and Hadoop 2.5.1 and trying to create an external table so data can me loaded from Hive to Elasticsearch. However I keep getting the following error. I have tried with ...
    Atul Paldhikar (apaldhik)Atul Paldhikar (apaldhik)
    Nov 27, 2014 at 7:58 am
    Nov 28, 2014 at 7:39 am
  • Sorry for the (as per subject) basic, dumb getting started question but: I'm trying to just set up Hive on a single node. Hadoop is set up and running happily, but following the directions on the ...
    Nicholas MurphyNicholas Murphy
    Nov 12, 2014 at 9:30 pm
    Nov 13, 2014 at 8:38 pm
  • Hi I am trying to build hive with spark engine but getting maven build failure Please help. Following is the error. [INFO] Tests are skipped. [INFO] [INFO] --- maven-jar-plugin:2.2:jar (default-jar) ...
    Somnath PandeyaSomnath Pandeya
    Nov 26, 2014 at 9:06 am
    Nov 28, 2014 at 2:07 pm
  • The Apache Hive team is proud to announce the the release of Apache Hive version 0.14.0. The Apache Hive (TM) data warehouse software facilitates querying and managing large datasets residing in ...
    Gunther HagleitnerGunther Hagleitner
    Nov 13, 2014 at 2:49 am
    Nov 17, 2014 at 11:35 pm
  • Hello, I am trying to parse hive queries so that I can get the table names on which the query is dependent on. I have tried the following : 1) downloaded the grammer and used ANTLR to generate the ...
    Ritesh GautamRitesh Gautam
    Nov 5, 2014 at 12:19 pm
    Nov 6, 2014 at 3:29 pm
  • Hi , Is anyone tried hive 0.14 configuration.I built it using maven from github. Insert is working fine but when i use update/delete i got the error.First i created table and inserted rows. CREATE ...
    Mahesh kumarMahesh kumar
    Nov 4, 2014 at 6:41 am
    Nov 5, 2014 at 1:15 am
  • Hi , I am writing a java program to connect with hive and query the data from hive. From my program i am connecting to hive as follows private static String driverName = ...
    Prasad bezavadaPrasad bezavada
    Nov 28, 2014 at 10:05 am
    Nov 30, 2014 at 5:25 pm
  • Hi I am trying to use "SET" keyword in queries running using JDBC. For example: SET hive.exec.dynamic.partition.mode=nonstrict; SET hive.exec.dynamic.partition=true; SET ...
    Guy DoulbergGuy Doulberg
    Nov 25, 2014 at 10:11 am
    Nov 26, 2014 at 11:35 am
  • Cany anyone suggest, how to use the Lead and lag function in Hive. I am using Hive* 0.10 version*. Is there any way to make it work in 0.10 version. I have used the below code in Oracle, But it is ...
    Ravi PrasadRavi Prasad
    Nov 14, 2014 at 8:10 am
    Nov 17, 2014 at 3:34 pm
  • I created a Hive table with *partition* and inserted data into Partioned Hive table. Refered site <https://blog.safaribooksonline.com/2012/12/03/tip-partitioning-data-in-hive/ 1. *Initially created ...
    Unmesha sreeveniUnmesha sreeveni
    Nov 17, 2014 at 4:31 am
    Nov 17, 2014 at 5:22 am
  • hi All, Please find attached a simple shell script to dynamically determine the active namenode in the HA Cluster and subsequently run the Hive job / query via Talend OS generated workflows. It was ...
    Devopam MittraDevopam Mittra
    Nov 5, 2014 at 4:33 am
    Nov 5, 2014 at 12:00 pm
  • I need to encrypt few columns (like SSN, Credit Card Number etc) in Hive Table. Is there a built-in feature available in Hive? I see a Jira at https://issues.apache.org/jira/browse/HIVE-6329 which is ...
    Venkat, AnkamVenkat, Ankam
    Nov 19, 2014 at 9:19 pm
    Nov 22, 2014 at 2:02 am
  • Based on the documentation https://cwiki.apache.org/confluence/display/Hive/DynamicPartitions the following CTAS should work: CREATE TABLE dropme(key int, value string) PARTITIONED BY (yr int, mth ...
    MaciekMaciek
    Nov 5, 2014 at 5:30 pm
    Nov 10, 2014 at 10:04 am
  • Hi users, I have hive set up at multi node hadoop cluster. I want to run multiple queries on top of a table from different machines. So please help how to achieve multiple access on hive to run ...
    Amit BeheraAmit Behera
    Nov 7, 2014 at 2:01 pm
    Nov 8, 2014 at 6:00 pm
  • I have a simple query with grouping. Something similar to bellow: SELECT col1, col2, col3, min(date), count(*) FROM tblX WHERE partitionDate="20141107" GROUP BY col1, col2, col3; When I run this ...
    Ja SamJa Sam
    Nov 7, 2014 at 2:28 pm
    Nov 8, 2014 at 7:34 am
  • I have a secured and HA hdfs cluster, and I have been trying to execute a join operation with beeline CLI. My issue is that it try to execute mapreduce localy instead by yarn. I set parameters ...
    Juan CarlosJuan Carlos
    Nov 5, 2014 at 8:47 am
    Nov 6, 2014 at 12:14 pm
  • Hi All, I am running into a strange issue since last week. Would request your help. I have a remote client from where in I ant to connect to hive via beeline. I have two hadoop clusters one with ...
    Konark modiKonark modi
    Nov 3, 2014 at 8:34 am
    Nov 3, 2014 at 5:32 pm
  • Is there a concept of creating database links in Hive? I see a jira https://issues.apache.org/jira/browse/HIVE-2989 but not sure what's the status of it. Regards, Venkat This communication is the ...
    Venkat, AnkamVenkat, Ankam
    Nov 19, 2014 at 9:25 pm
    Nov 20, 2014 at 6:39 pm
  • Hi, select row_number() over (PARTITION BY country,state,department,branch_name) from Employee_details; select count(*) over (PARTITION BY country,state,department,branch_name) from ...
    karthik Srivasthavakarthik Srivasthava
    Nov 10, 2014 at 6:17 am
    Nov 10, 2014 at 6:57 am
  • Hi All, So I have a table, say *test_table*. It has 3 columns, "a", "b", and "c". For simplicity, let's say all are of type STRING. Say the table, when created, was partitioned on fields "a" and ...
    Nishant KelkarNishant Kelkar
    Nov 3, 2014 at 6:27 am
    Nov 3, 2014 at 6:39 am
  • Hi, I need to change my email address in my profile 'mladenkov' held on the confluence wiki for cwiki.apache.org. It says that modifying profile preferences is disabled and to contact the infra ...
    Mladen KovacevicMladen Kovacevic
    Nov 27, 2014 at 8:48 pm
    Nov 28, 2014 at 4:25 am
  • Hi, everybody We use Hadoop CDH4.6.0, now i try to upgrade only hive to 0.13.1-cdh5.2.0,something puzzles me: because it isn't compatible with protobuf 2.5.0, so i rebuild hive-0.13.1-cdh5.2.0 using ...
    Jander gJander g
    Nov 27, 2014 at 7:27 am
    Nov 27, 2014 at 7:13 pm
  • we are currently using hive on spark, when reading a small int field, it reports error: Cannot get field 'i16Val' because union is currently set to i32Val I googled and find only source code of ...
    诺铁诺铁
    Nov 27, 2014 at 7:21 am
    Nov 27, 2014 at 12:47 pm
  • Hi friends Where can I find details on how update is performed in Hive. ​1. When an update is performed,whether HDFS will write that block elsewhere with the new value. 2. whether the old block is ...
    Unmesha sreeveniUnmesha sreeveni
    Nov 27, 2014 at 10:44 am
    Nov 27, 2014 at 12:07 pm
  • Hello,list The background: Hive 0.13.1 with security enabled. The HiveServer2 using SQL Standards authorization with doAs setting to false. Remote Meta Store using storage based authorization. Impala ...
    LoudongfengLoudongfeng
    Nov 25, 2014 at 12:14 pm
    Nov 25, 2014 at 12:54 pm
  • Hi All I am trying to run 'Show current roles' on Apache hive 0.13.1 but getting following error, hive SHOW CURRENT ROLES; Error in role operation show_current_role on role name null, error message ...
    Ravi KumarRavi Kumar
    Nov 17, 2014 at 1:51 pm
    Nov 20, 2014 at 11:07 am
  • Hi All, I am testing the different explain plan output and found it hard to find the difference between Bucket Map Join(non sort merged) and normal Map Join. The tested hive version is 0.13. To ...
    Hao ZhuHao Zhu
    Nov 18, 2014 at 10:21 pm
    Nov 19, 2014 at 10:21 pm
  • Username: ctang.ma Full name: chaoyu tang Thanks
    Chaoyu TangChaoyu Tang
    Nov 19, 2014 at 1:34 pm
    Nov 19, 2014 at 10:13 pm
  • Hi, My question is that does Hive able to compare same column between rows. For instance, I have a table which contains data like below. name, value a, 1 a, 2 b, 1 c, 1 a, 13 b, 11 What I need is to ...
    Mungeol HeoMungeol Heo
    Nov 18, 2014 at 12:16 am
    Nov 18, 2014 at 3:36 am
  • Hello hive users , I am trying to use hive2 jdbc connection for the first time . publicclass MyHiveJDBCClient { privatestatic String driverName = "org.apache.hive.jdbc.HiveDriver"; private static ...
    Sathi ChowdhurySathi Chowdhury
    Nov 11, 2014 at 1:09 am
    Nov 11, 2014 at 3:23 pm
  • Hi Fellow Hive Users! Has anyone tried to access Hive (which is on the Linux box) using Ipython / Python? I am using windows 7 64 bit machine and I am trying to use some python packages likes ...
    Viral ParikhViral Parikh
    Nov 11, 2014 at 9:40 am
    Nov 11, 2014 at 2:41 pm
  • Hi All, I am trying to run my oozie job but its giving below error user@ubuntu:~/hive_oozie$ oozie job -oozie http://ubuntu:11000/oozie -config job.properties -run Error: E0501 : E0501: Could not ...
    Rahul ChanneRahul Channe
    Nov 4, 2014 at 9:11 pm
    Nov 9, 2014 at 5:40 pm
  • <span class="m_body_email_addr" title="d523b5dffcffffbf4a16781aa6033cbd" xuzl@infobird.com</span
    XuzlXuzl
    Nov 7, 2014 at 8:08 am
    Nov 7, 2014 at 9:02 am
  • Hey All, I was looking into integration testing Hive for some of my code. What I need is something that creates an in-memory HDFS ecosystem, and an on-the-fly HiveServer2 instance along with the Hive ...
    Nishant KelkarNishant Kelkar
    Nov 5, 2014 at 8:30 am
    Nov 5, 2014 at 8:32 am
  • I have a problem to run hql from shell script. I can run partition query just like "use myDB; show partitions myTbl;" But I have a problem count query just like "use myDB; select count(*) from myTbl ...
    Jihyun SuhJihyun Suh
    Nov 5, 2014 at 5:44 am
    Nov 5, 2014 at 6:08 am
  • Hi, Currently we can only user hive --service metastore to start the metastore service, and the hiveserver2 command to start hiveserver2, but both services will keep the terminal open, althrough we ...
    Guxiaobo1982Guxiaobo1982
    Nov 28, 2014 at 1:27 am
    Nov 28, 2014 at 1:27 am
  • Hi, everybody We use Hadoop CDH4.6.0, now i try to upgrade only hive to 0.13.1-cdh5.2.0,something puzzles me: because it isn't compatible with protobuf 2.5.0, so i rebuild hive-0.13.1-cdh5.2.0 using ...
    Jander gJander g
    Nov 27, 2014 at 7:21 am
    Nov 27, 2014 at 7:21 am
  • Hi User, I am running a join query on 100GB table with 10 GB table. My query got stuck without giving any error like below. 2014-11-26 20:19:53,893 Stage-1 map = 99%, reduce = 10%, Cumulative CPU ...
    Amit BeheraAmit Behera
    Nov 26, 2014 at 3:02 pm
    Nov 26, 2014 at 3:02 pm
  • Hi Hope this link helps for those who are trying to do practise ACID properties in hive 0.14. http://unmeshasreeveni.blogspot.in/2014/11/updatedeleteinsert-in-hive-0140.html -- *Thanks & Regards * ...
    Unmesha sreeveniUnmesha sreeveni
    Nov 25, 2014 at 8:48 am
    Nov 25, 2014 at 8:48 am
  • Hi, After upgrading to hive 0.14 any query I run I hit the following message: . . . . . . . . . . . . . . . . ; INFO : Tez session hasn't been created yet. Opening session Error: Error while ...
    Daniel HavivDaniel Haviv
    Nov 22, 2014 at 6:30 pm
    Nov 22, 2014 at 6:30 pm
  • Hi All, I am trying to connect hiveserver2 through beeline remote client. I followed following steps but not able to connect through Remote Client with HiveServer2 TCP Transport Mode and SASL ...
    Ravi KumarRavi Kumar
    Nov 19, 2014 at 3:25 pm
    Nov 19, 2014 at 3:25 pm
  • Hi This is a blog on Hive updating for older version (hive -0.12.0) http://unmeshasreeveni.blogspot.in/2014/11/updating-partition-table-using-insert.html Hope it helps someone. -- *Thanks & Regards * ...
    Unmesha sreeveniUnmesha sreeveni
    Nov 19, 2014 at 6:57 am
    Nov 19, 2014 at 6:57 am
  • Hi, This is a blog on Hive partitioning. http://unmeshasreeveni.blogspot.in/2014/11/hive-partitioning.html Hope it helps someone. -- *Thanks & Regards * *Unmesha Sreeveni U.B* *Hadoop, Bigdata ...
    Unmesha sreeveniUnmesha sreeveni
    Nov 19, 2014 at 5:38 am
    Nov 19, 2014 at 5:38 am
  • Can Hive optimizer take advantage of tables CLUSTERED BY … SORTED BY … when performing aggregations or analytic functions (window aggregations)? If so, how? more details at SO: optimize Hive table ...
    MaciekMaciek
    Nov 18, 2014 at 8:38 pm
    Nov 18, 2014 at 8:38 pm
  • Hi, I'm trying to load Hive view into withing Pig script using org.apache.hive.hcatalog.pig.HCatLoader. I'm using Hortonworks HDP2.2 with hive-hcatalog-pig-adapter-0.14.0.2.2.0.0-1084.jar (I also ...
    Sasha OstrikovSasha Ostrikov
    Nov 16, 2014 at 12:55 pm
    Nov 16, 2014 at 12:55 pm
  • Hi all, I use hive 0.13.1 and encountered a problem now. Here is the tables and query. // each table contains only one row create table test_union_all_1(a double); create table test_union_all_2(a ...
    Ch WanCh Wan
    Nov 15, 2014 at 5:24 pm
    Nov 15, 2014 at 5:24 pm
Group Navigation
period‹ prev | Nov 2014 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions63
posts196
users78
websitehive.apache.org

78 users for November 2014

Amit Behera: 10 posts Unmesha sreeveni: 10 posts Maciek: 8 posts Nitin Pawar: 8 posts Devopam Mittra: 6 posts Mahesh Kumar: 6 posts Nishant Kelkar: 6 posts Daniel Haviv: 5 posts Atul Paldhikar (apaldhik): 4 posts Karthiksrivasthava: 4 posts Lefty Leverenz: 4 posts Peterm_second: 4 posts Somnath Pandeya: 4 posts Xuefu Zhang: 4 posts Alok Kumar: 3 posts Edward Capriolo: 3 posts Gopal V: 3 posts Guy Doulberg: 3 posts Hadoop hive: 3 posts Hanish Bansal: 3 posts
show more
Archives