Grokbase Groups Hive user August 2015

Search Discussions

77 discussions - 291 posts

  • Hi all, I have a little issue with HiveServer2 since I have enabled Kerberos. I'm unable to connect to the service via Beeline. When doing !connect jdbc:hive2:// hive hive ...
    Loïc ChanelLoïc Chanel
    Aug 19, 2015 at 10:01 am
    Sep 10, 2015 at 8:08 am
  • Hi all, I want to interact with HiveMetaStore table from code and was looking at , was ...
    Jerrick HoangJerrick Hoang
    Aug 26, 2015 at 6:27 am
    Aug 27, 2015 at 1:17 am
  • HI All, I have a directory where I have json formatted and parquet files in same folder. can hive load these? I am getting Json data and storing in HDFS. later I am running job to convert JSon to ...
    Jeetendra GJeetendra G
    Aug 24, 2015 at 7:02 am
    Aug 26, 2015 at 6:13 pm
  • Hi Guys, We have a UDF which extends GenericUDF and does some configuration within the public void configure(MapredContext ctx) method. MapredContext in configure method gives access to the ...
    Rahul SharmaRahul Sharma
    Aug 25, 2015 at 6:32 pm
    Aug 28, 2015 at 11:49 pm
  • Can we insert data in different partitions of a table at a time. Waiting for inputs . Thanks in advance. - suyog
    Suyog ParlikarSuyog Parlikar
    Aug 21, 2015 at 1:33 pm
    Aug 24, 2015 at 4:26 pm
  • Hi All, Earlier I was using hive 0.13.0 and now trying to migrate to latest version to utilize the transaction support introduced from hive 0.14.0. I downloaded hive 1.2.1, created a metastore in ...
    Sarath ChandraSarath Chandra
    Aug 3, 2015 at 1:30 pm
    Aug 21, 2015 at 10:52 am
  • Hi pls unsubscribe me from this forum . Regards Ajeet Ojha Tata Consultancy Services Limited Cell:- 9811220828 Mailto: <span class="m_body_email_addr" title="b8d5b17e9448b0ead26b0fae9b00d226" ...
    Ajeet OAjeet O
    Aug 4, 2015 at 3:12 pm
    Aug 25, 2015 at 7:00 am
  • When I enable mapjoin ,I see Mapjoin task run very slow. My envrioment is hadoop 2.3.0 hive 1.1.0. My attach is one map hive log and this map's xprof log. In map xprof log ,I see Compiled + native ...
    Aug 28, 2015 at 1:04 am
    Aug 31, 2015 at 2:46 am
  • Hi, I'd like to have write access to the Hive wiki. My Confluence username is <span class="m_body_email_addr" title="2e4258c60bc9d6128ce948b24daa8f50"</span with Full Name ...
    Xu, Cheng AXu, Cheng A
    Aug 10, 2015 at 8:16 am
    Aug 25, 2015 at 3:08 am
  • Hello, I am interested to get the cost of the query plans as calculated by the CBO. How can I get that information ? For example, consider a query with a three way join of the following form: Query ...
    Aug 25, 2015 at 12:19 am
    Aug 25, 2015 at 7:08 pm
  • Hi Guys, I managed to delete some data in HDFS by dropping a partitioned external Hive table. One explanation is that data resided in the 'warehouse' directory of Hive and that had something to do ...
    Peyman MohajerianPeyman Mohajerian
    Aug 24, 2015 at 11:12 pm
    Aug 25, 2015 at 3:00 pm
  • Hello, I want to compare the running time of an query when run alone against the run time in presence of other queries. What is the ideal setup required to run this experiment ? Should I have two ...
    Aug 25, 2015 at 1:28 pm
    Aug 25, 2015 at 10:34 pm
  • Dear Hive Users, I am in process of running over a poc to one of my customer demonstrating the huge performance benefits of Hadoop BigData using Hive. Following is the problem statement i am stuck ...
    Nishant AggarwalNishant Aggarwal
    Aug 20, 2015 at 7:56 am
    Aug 21, 2015 at 9:24 am
  • Hi We are experiencing a strange problem with the hiveserver2, in one of the job it gets the GC limit exceed from mapred task and hangs even having enough heap available.we are not able to identify ...
    Sanjeev VermaSanjeev Verma
    Aug 19, 2015 at 4:26 pm
    Aug 21, 2015 at 12:47 am
  • Hello, In hive we got a need that we need to create a new table like the old table with an extra column at run time. This must be done in a single query. No second query with alter table statement ...
    Venkatesh bVenkatesh b
    Aug 10, 2015 at 12:54 pm
    Aug 11, 2015 at 7:50 am
  • I have been running Hive queries on a single node (no HDFS). I realize that the queries get compiled as map-reduce jobs and not as TEZ jobs even though "hive.execution.engine=tez" is set. Is that ...
    Aug 7, 2015 at 8:07 pm
    Aug 10, 2015 at 6:32 pm
  • HI All, I am trying to rum hive on spark means from Hive terminal setting up execution engine as spark. I have copied the hive-default.xml to spark conf directory. Hive is not able to find the ...
    Jeetendra GJeetendra G
    Aug 27, 2015 at 6:13 am
    Sep 3, 2015 at 5:24 pm
  • I have a small Java app that I wrote that uses JDBC to run a hive query. The Hive table that I'm running it against has 30+ million rows, and I want to pull them all back to verify the data. If I run ...
    Emil BerglindEmil Berglind
    Aug 19, 2015 at 1:54 pm
    Aug 19, 2015 at 6:09 pm
  • The reason why I ask this question is that when I execute the following sql, it will generated a query plan with 4 vertices. But as my understanding if YSmart is integrated into hive, it should only ...
    Jeff ZhangJeff Zhang
    Aug 31, 2015 at 8:01 am
    Sep 2, 2015 at 2:28 am
  • Hello, Currently, I am running Hive on Tez. I wish to make some changes to the DAGs generated by HIve before running on Tez/Yarn. Which data structure should i serialize ? DAG or DagPlan ? - Raajay
    Aug 31, 2015 at 8:06 pm
    Sep 2, 2015 at 1:38 am
  • Hi, I am working towards a incremental solution on hive based on the transient_lastDdlTime of the partitions. If the we in Thanks, Ravi
    Ravi tejaRavi teja
    Aug 25, 2015 at 4:00 pm
    Aug 25, 2015 at 6:06 pm
  • Hi all I am running a python UDF in hive. I am getting the following error. hive select transform(id) using 'python' as (id string) from test;Query ID = ...
    Rakesh sharmaRakesh sharma
    Aug 20, 2015 at 12:55 pm
    Aug 21, 2015 at 1:16 pm
  • Hello all, i have question about ORC table format. We use it as for our datastore tables but during maintenance i noticed there is many small files inside tables which I presume doesn't contains any ...
    Juraj jivJuraj jiv
    Aug 18, 2015 at 3:28 pm
    Aug 18, 2015 at 6:35 pm
  • Hi all, I'm using Hive 0.14, Tez 0.5.2, and Hadoop 2.6.0. I have a very simple query of the form `select count(*) from my_table where x 0 and x < 1500`. The table has ~50 columns in it and not all ...
    William SlacumWilliam Slacum
    Aug 5, 2015 at 8:48 pm
    Aug 6, 2015 at 1:35 pm
  • Hi all, When I try to start hiveserer2 failed with following error. It was running but after the server reboot hiveeserver2 will not start. Please help. Thank you very much. Garry 2015-08-03 ...
    Garry ChenGarry Chen
    Aug 3, 2015 at 9:01 pm
    Aug 4, 2015 at 3:17 pm
  • I have external hcat structures over lzo-compressed datafiles , data is partitioned by date string Is it possible to handle schema changes by setting diffrent schema(column names & datatypes) ...
    Dominik ChomaDominik Choma
    Aug 31, 2015 at 9:15 pm
    Aug 31, 2015 at 9:57 pm
  • Hi All, Can anyone suggest any python libraries to call hive queries from python scripts ? what is the best practice to execute queries from python like using hive cli , beeline, jdbc etc.., Thanks ...
    Giri PGiri P
    Aug 28, 2015 at 6:21 pm
    Aug 31, 2015 at 11:38 am
  • Hi, My question concerns the means of presenting data to consumer layer from Hive. Obviously Hive is very suitable for batch analysis. However, the MapReduce nature of extracting data make is ...
    Mich TalebzadehMich Talebzadeh
    Aug 25, 2015 at 7:45 am
    Aug 25, 2015 at 10:39 am
  • Hi guys I am using Hive version = 0.13.1-cdh5.3.3 HIVE TABLE = qnap_resume_file_location---------------------------------------DROP TABLE IF EXISTS qnap_resume_file_location;CREATE EXTERNAL TABLE ...
    Sanjay SubramanianSanjay Subramanian
    Aug 24, 2015 at 7:17 pm
    Aug 24, 2015 at 9:51 pm
  • Hi All I am trying to get all the names starting with r.My query looks like select * from emp where name like 'r~%'; But it doesn't result anything; Any help thanksrakesh
    Rakesh sharmaRakesh sharma
    Aug 20, 2015 at 6:40 pm
    Aug 21, 2015 at 6:58 am
  • any help guys ? -- Nitin Pawar
    Nitin PawarNitin Pawar
    Aug 20, 2015 at 9:18 am
    Aug 20, 2015 at 12:46 pm
  • For cases like: select * from t1 join t2 on t1.col = t2.col where t1.col = 1; Is rule PredicateTransitivePropagate supposed to propagate predicate "t1.col = 1" to t2 via join condition t1.col = ...
    Aug 19, 2015 at 5:06 am
    Aug 19, 2015 at 11:37 am
  • Is there a good writeup on what the settings that can be tweaked in hive as it pertains to writing parquet files are? For example, in some obscure pages I've found settings like parquet.compression, ...
    John OmernikJohn Omernik
    Aug 18, 2015 at 7:06 pm
    Aug 18, 2015 at 11:21 pm
  • For a research project, I am studying the performance gains in Hive queries achieved through cost based optimization. Rather than just study scenarios where CBO is switched on or off, I would like to ...
    Aug 10, 2015 at 3:48 pm
    Aug 14, 2015 at 7:55 pm
  • Hi, I installed Java 1.8.0_51, Hadoop 1.2.1 and Hive 1.2.1 on Ubuntu 14.04 64 bit, I do get the below exception when I start the hive shell or the beeline. How do I get around this problem? ...
    Praveen SripatiPraveen Sripati
    Aug 14, 2015 at 3:34 am
    Aug 14, 2015 at 4:14 pm
  • What library should I use if I want to make persistent connections from within Scala/Java? I’m working on a web service that sends Hive queries to our HiveServer (we are about to upgrade to Hive 1.1 ...
    Stephen BlyStephen Bly
    Aug 7, 2015 at 3:23 am
    Aug 10, 2015 at 4:15 pm
  • Hi all, I've had some questions from users regarding setting ``. I see, in some documentation from users and vendors, that it is recommended to set ...
    William SlacumWilliam Slacum
    Aug 4, 2015 at 8:46 pm
    Aug 5, 2015 at 1:33 pm
  • Hello, I have a query that used to work fine previously. I am testing on hive 1.1 now and it is failing. The AWS access and secret key have permissions to read and write data to this directory. The ...
    Pun IntendedPun Intended
    Aug 4, 2015 at 7:19 pm
    Aug 4, 2015 at 8:52 pm
  • Hi, I often have the following situation: I have a small table with a list of unique IDs and a very large table of events associated with the IDs. I want to perform some aggregation including only ...
    Raviv Murciano-GoroffRaviv Murciano-Goroff
    Aug 28, 2015 at 11:50 pm
    Aug 29, 2015 at 7:43 pm
  • I am trying to connect hive database(execution.engine value changed to tez) using Java code... In case of select query its working.... But in the case of INSERT getting an error: The error looks ...
    Sateesh KaruturiSateesh Karuturi
    Aug 27, 2015 at 4:33 pm
    Aug 27, 2015 at 11:38 pm
  • I’m running a Hive query over JDBC in a Java app that I wrote. I want to be able to turn off task conversion as I am looking to stream the data back. I thought I could do that by using the following ...
    Emil BerglindEmil Berglind
    Aug 20, 2015 at 3:57 pm
    Aug 25, 2015 at 8:15 am
  • I all I have a folder structure like /housing/events/event1/date=20150820 stored in HDFS. I wanted to create the partition based on year month and day how can I do this during creating or loading ...
    Jeetendra GJeetendra G
    Aug 20, 2015 at 4:09 pm
    Aug 20, 2015 at 4:16 pm
  • Hi Team, Below insert with union-all will create sub-directories: set hive.execution.engine=tez; create table h1_passwords_target like h1_passwords; insert overwrite table h1_passwords_target select ...
    Jim GreenJim Green
    Aug 19, 2015 at 9:41 pm
    Aug 19, 2015 at 11:30 pm
  • Hi, Currently I am having an issue really need some help from hive community. We are trying kerberize our hadoop cluster including hive server2 and oozie. My oozie job spins off a java action in data ...
    Jary DuJary Du
    Aug 13, 2015 at 6:59 pm
    Aug 18, 2015 at 12:44 am
  • Hi all, I was doing TPC-H benchmark on Hive recently while I found some queries went wrong. Following are the two cases, both are MapJoin while the join key is bigint type. After disabling auto ...
    Ted XuTed Xu
    Aug 14, 2015 at 10:57 am
    Aug 14, 2015 at 7:57 pm
  • Hi, I'm using Hive When sending queries I get this stack trace: 2015-08-11 07:39:00,844 WARN [HiveServer2-Handler-Pool: Thread-36]: thrift.ThriftCLIService ...
    Matthias KrickeMatthias Kricke
    Aug 11, 2015 at 8:33 am
    Aug 11, 2015 at 10:36 pm
  • Hi Folks, I need to insert 1 billion records into hive and here is my cluster details. 1. 6-node Hadoop cluster cluster. 2. 16GB RAM on each node. 3. 2TB Hard-disk on each node. Is this configuration ...
    Siva kumarSiva kumar
    Aug 11, 2015 at 6:31 am
    Aug 11, 2015 at 8:10 am
  • Hi, We are on hive 0.14 and running into NPE error during file sink stage when inserting into bucketed table. Please advice for any workaround or patch info. Thanks, Muni
    Muni ChadaMuni Chada
    Aug 6, 2015 at 11:14 pm
    Aug 7, 2015 at 2:23 am
  • Hi Team, One UDTF fails in Hive 1.0 with below stacktrace: Caused by: java.lang.ClassCastException: org.apache.hadoop.hive.serde2.lazy.LazyString cannot be cast to at ...
    Jim GreenJim Green
    Aug 7, 2015 at 1:15 am
    Aug 7, 2015 at 2:22 am
  • Hi, I am doing performance testing on Hive ODBC driver and so far I have concluded that HiveServer2 is the bottleneck in my data pipe. I wonder if you could direct me to links and tips on how to ...
    Alexander ZareiAlexander Zarei
    Aug 6, 2015 at 8:56 pm
    Aug 6, 2015 at 9:22 pm
Group Navigation
period‹ prev | Aug 2015 | next ›
Group Overview
groupuser @
categorieshive, hadoop

102 users for August 2015

Jeetendra G: 10 posts Loïc Chanel: 10 posts Raajay: 10 posts Rahul Sharma: 9 posts Rakesh sharma: 9 posts Noam Hasson: 8 posts Sergey Shelukhin: 8 posts Alan Gates: 7 posts Jary Du: 7 posts Jason Dere: 7 posts Kulkarni Swarnim: 7 posts Mich Talebzadeh: 7 posts Ryan Harris: 7 posts Gopal Vijayaraghavan: 6 posts Jörn Franke: 6 posts Venkatesh b: 6 posts John Pullokkaran: 5 posts Lefty Leverenz: 5 posts Nitin Pawar: 5 posts R7raul1984: 5 posts
show more