Grokbase Groups Hive user April 2014
FAQ

Search Discussions

88 discussions - 296 posts

  • The Apache Hive PMC has voted to make Prasanth J and Vaibhav Gumashta committers on the Apache Hive Project. Please join me in congratulating Prasanth and Vaibhav! Thanks. - Carl
    Carl SteinbachCarl Steinbach
    Apr 25, 2014 at 2:27 am
    Apr 25, 2014 at 11:10 pm
  • The Apache Hive PMC has voted to make Alan Gates, Daniel Dai, and Sushanth Sowmyan committers on the Apache Hive Project. Please join me in congratulating Alan, Daniel, and Sushanth! - Carl
    Carl SteinbachCarl Steinbach
    Apr 14, 2014 at 5:52 pm
    Apr 14, 2014 at 9:41 pm
  • Hey There, I was trying to use Skewed tables but I am facing the issue that it is not creating separate files for the skewed data. Even with a simple example I am having the same issue. The hive ...
    Mayur GuptaMayur Gupta
    Apr 21, 2014 at 5:50 am
    Apr 28, 2014 at 9:01 pm
  • Hello, We are running HDFS on 9-node hadoop cluster, hadoop version is 1.2.1. We are using default HDFS block size. We have noticed that disks of slaves are almost full. From name node’s status page ...
    SaumitraSaumitra
    Apr 13, 2014 at 7:54 pm
    Apr 15, 2014 at 6:58 pm
  • I use hive under hadoop 2.2.0, first I start hive [hadoop@master sbin]$ hive 14/04/21 19:06:32 INFO Configuration.deprecation: mapred.input.dir.recursive is deprecated. Instead, use ...
    EdwardKingEdwardKing
    Apr 22, 2014 at 2:27 am
    Apr 22, 2014 at 8:41 am
  • Hello, I recently noticed that the OrcInputFormat/OutputFormat's have been exposed to be usable outside of hive ( https://issues.apache.org/jira/browse/HIVE-5728). Does anyone know of any ...
    Brock BoseBrock Bose
    Apr 15, 2014 at 5:34 pm
    Apr 15, 2014 at 7:25 pm
  • Hi guys, I am trying to use the reflect UDF for an UUID method and am getting an exception. I believe this function should be available in java 1.6.0_31 the system is running. select ...
    Andy SrineAndy Srine
    Apr 2, 2014 at 9:14 pm
    Apr 4, 2014 at 12:49 am
  • Hello. I am running Hadoop 2.4.0 and Hive 0.13.0. I am encountering the following error when converting a text table to ORC via the following command: Error: Diagnostic Messages for this Task ...
    Bryan JeffreyBryan Jeffrey
    Apr 22, 2014 at 2:00 am
    Apr 22, 2014 at 9:37 pm
  • Hi Experts, I am trying to create table against my s3 file, I faced the below issue, where to set these credentials in clouderamanager4.8. I got this link ( ...
    Kishore kumarKishore kumar
    Apr 21, 2014 at 2:03 pm
    Apr 22, 2014 at 6:06 am
  • Hi all, I have done the following steps to create a UDF in hive but getting error.Please help me. 1. Created the udf as described here. 2. Compiled it successfully. 3. Copy the class file to a ...
    Rishabh BhardwajRishabh Bhardwaj
    Apr 9, 2014 at 6:30 am
    Apr 9, 2014 at 8:01 am
  • We are currently streaming complex documents to hdfs with the hope of being able to query. Each single document logically breaks down into a set of individual records. In order to use Hive, we ...
    David QuigleyDavid Quigley
    Apr 2, 2014 at 3:46 am
    Apr 8, 2014 at 1:54 pm
  • Dear Folks, Whenever I run join queries, it does not display the output, thought it give me output for queries on single table. Thanks and Regards, Saky
    Saquib khanSaquib khan
    Apr 4, 2014 at 8:04 pm
    Apr 4, 2014 at 8:58 pm
  • I am new to Hive, apologise for asking such a basic question. Following exercise was done with hive .12 and hadoop 0.20.203 I created a ORC file form java, and pushed it into a table with the same ...
    Abhay BansalAbhay Bansal
    Apr 3, 2014 at 5:37 am
    Apr 4, 2014 at 6:01 am
  • Hi, I am trying to run an MR job to write files in ORC format. I do not see any files created although the job runs successfully. If I change the output format from OrcOutputFormat to ...
    Seema DatarSeema Datar
    Apr 29, 2014 at 10:41 am
    May 11, 2014 at 4:47 am
  • Hello all, I am working with Hive 0.12 right now on YARN. When I am writing a table that is admittedly quite "wide" (there are lots of columns, near 60, including one binary field that can get quite ...
    John OmernikJohn Omernik
    Apr 27, 2014 at 4:57 pm
    Apr 28, 2014 at 6:25 pm
  • Hi all I am using get_json_object to read a json text file. I have created the external table as below : CREATE EXTERNAL TABLE EXT_TABLE ( json string) PARTITIONED BY (dt string) LOCATION ...
    Narayanan KNarayanan K
    Apr 7, 2014 at 10:52 pm
    Apr 8, 2014 at 2:35 pm
  • Hello everyone, When I run a jdbc example from https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-JDBCClientSampleCode against my hive server, the number of ...
    Dima FadeyevDima Fadeyev
    Apr 29, 2014 at 10:18 am
    May 5, 2014 at 8:07 am
  • Hi, I'm trying to convert some of our Hive queries to use the pyhs2 Python package (https://github.com/BradRuderman/pyhs2). Because we have our own jar with some custom SerDes and UDFs, we need to ...
    David EngelDavid Engel
    Apr 25, 2014 at 2:55 pm
    Apr 29, 2014 at 4:52 pm
  • Hive 0.12.0 (and previous versions) worked with Hadoop 0.20.x, 0.23.x.y, 1.x.y, 2.x.y. Hive 0.13.0 did not work with Hadoop 0.20.x out of the box and to make it work I had to patch Hadoop ...
    Dmitry VasilenkoDmitry Vasilenko
    Apr 23, 2014 at 2:01 pm
    Apr 27, 2014 at 7:24 am
  • Hi, I am using pyhs2 with HortonWorks Hadoop Image and am stuck at - pyhs2.connect(host='localhost',port=10000,authMechanism="PLAIN",user='root',password='hadoop',database='default') as conn: .. ...
    Manish MaheshwariManish Maheshwari
    Apr 26, 2014 at 4:12 am
    Apr 27, 2014 at 6:31 am
  • I have a hive table partitioned by dates. It contains ecomm data in the format siteid,sitecatid,catid,subcatgid,pid,pname,pprice,pmrp,pdesc.... What I need to do is to run a query on table above in ...
    Mohit DurgapalMohit Durgapal
    Apr 11, 2014 at 6:57 am
    Apr 11, 2014 at 1:20 pm
  • Hi All, I am just trying to do some simple tests to see speedup in hive query with Hive 0.14 (trunk version this morning). Just tried to use sample test case to start with. First wanted to see how ...
    Amit TewariAmit Tewari
    Apr 4, 2014 at 9:28 pm
    Apr 5, 2014 at 8:07 am
  • Hello. We have a number of UDFs that were working under Hive 0.12.0. After upgrade to Hive 13 we are seeing errors executing queries with UDFs. The UDF jar file is in the $HIVE_CONF/.hiverc file as ...
    Bryan JeffreyBryan Jeffrey
    Apr 30, 2014 at 6:32 pm
    May 1, 2014 at 2:13 am
  • Hi All, My input data looks like below as | delimited and I want to extract appid, appname, bundleid etc, please help me to create hive table , -- Thanks, *Kishore *
    Kishore kumarKishore kumar
    Apr 30, 2014 at 9:45 am
    Apr 30, 2014 at 12:05 pm
  • Hi All, I heard about the reduce job, it will be started after all map tasks finished 100%, but in my hive query the reduce job started at below stage, please explain why is this.(I copied below line ...
    Kishore kumarKishore kumar
    Apr 23, 2014 at 11:19 am
    Apr 30, 2014 at 11:03 am
  • Hi, I need some inputs to execute hive queries in parallel. I tried doing this using CLI (by opening multiple ssh connection) and executed 4 HQL's; it was observed that the queries are getting ...
    SaurabhSaurabh
    Apr 21, 2014 at 8:54 pm
    Apr 27, 2014 at 10:01 pm
  • Hey guys TABLE=STUDENT COLUMN=SCORE U want to find the max value in the column without using any aggregation functions. Its easy in a RDB context but I was trying to get a solution in Hive (clearly I ...
    Subramanian, Sanjay (HQP)Subramanian, Sanjay (HQP)
    Apr 23, 2014 at 1:28 am
    Apr 23, 2014 at 4:42 pm
  • Hi, I have installed and configured hadoop. Now, I want to install hive and pig, As per my understanding pig and hive internally uses hadoop. So is there a way i can just install bare minimum hive or ...
    Rahul SinghRahul Singh
    Apr 1, 2014 at 10:05 am
    Apr 2, 2014 at 3:50 am
  • Hi all, I created the database 'test1' and a table 'my1' Now with show tables in test1 , hive shell is showing my1 but when I am trying to do, describe my1; then this error comes: FAILED ...
    Rishabh BhardwajRishabh Bhardwaj
    Apr 1, 2014 at 5:39 am
    Apr 1, 2014 at 5:18 pm
  • Can I update ( delete and insert kind of)just one row keeping the remaining rows intact in Hive table using Hive INSERT OVERWRITE. There is no partition in the Hive table. INSERT OVERWRITE TABLE ...
    Raj HadoopRaj Hadoop
    Apr 4, 2014 at 8:58 pm
    Nov 19, 2014 at 9:18 am
  • All, Is there a good document on configuring Hadoop (2.4.0) and Hive (0.13.0) to work using Tez? I see this documentation here: https://cwiki.apache.org/confluence/display/Hive/Hive+on+Tez, but that ...
    Bryan JeffreyBryan Jeffrey
    Apr 23, 2014 at 4:47 pm
    May 11, 2014 at 1:02 am
  • All, I attempted to setup Tez per the instructions on the following page: http://tez.incubator.apache.org/install.html After changing my mapreduce framework name to 'yarn-tez', I am getting the ...
    Bryan JeffreyBryan Jeffrey
    Apr 29, 2014 at 1:57 am
    May 5, 2014 at 10:58 am
  • I have a requirement of processing huge weblogs on daily basis. 1. data will come incremental to datastore on daily basis and I need cumulative and daily distinct user count from logs and after that ...
    Shushant AroraShushant Arora
    Apr 30, 2014 at 8:35 am
    Apr 30, 2014 at 10:36 am
  • Hi, I am using cloudera4.5 with cloudera manager4.8, I want to set hive.cli.print.header=true, where should i specify, is it possible to specify in CM, or from cli what is location, please help me ...
    Kishore kumarKishore kumar
    Apr 28, 2014 at 3:18 pm
    Apr 28, 2014 at 7:21 pm
  • Hi Experts, After I changed the column names in hive table,m the result showing all null values with new column names, if i query with select * from table giving the actual values result, what could ...
    Kishore kumarKishore kumar
    Apr 21, 2014 at 12:33 pm
    Apr 24, 2014 at 4:59 pm
  • Hello. We recently had a user that ran an ad-hoc hive query with a JOIN clause without an ON-predicate, resulting in a huge resultset that then resulted in our hdfs storage becoming full. I am ...
    Thomas LarssonThomas Larsson
    Apr 23, 2014 at 1:51 pm
    Apr 24, 2014 at 7:36 am
  • I use hadoop 2.2.0 and hive 0.13.0, I want to create a table from an existing file, states.hql is follows: CREATE EXTERNAL TABLE states(abbreviation string, full_name string) ROW FORMAT DELIMITED ...
    EdwardKingEdwardKing
    Apr 23, 2014 at 3:24 am
    Apr 23, 2014 at 4:32 am
  • Hi Experts, Hive query result stored in hdfs with 75 zip files, I merged them and get into the local filesystem with '-getmerge', but I am unable to see the data after i unzipped the file, anything i ...
    Kishore kumarKishore kumar
    Apr 22, 2014 at 3:03 pm
    Apr 23, 2014 at 1:26 am
  • Hi - One of the columns in my hive table contains compressed data (Json document in Gzip format). Is there any recommended way to decompress it and explode the json doc? Thanks, Kanna
    Kanna KaranamKanna Karanam
    Apr 9, 2014 at 1:29 am
    Apr 14, 2014 at 10:35 pm
  • I want to use hive in hadoop2.2.0, so I execute following steps: [hadoop@master /]$ tar �Cxzf hive-0.11.0.tar.gz [hadoop@master /]$ export HIVE_HOME=/home/software/hive [hadoop@master /]$ export ...
    EdwardKingEdwardKing
    Apr 14, 2014 at 8:23 am
    Apr 14, 2014 at 9:00 am
  • Hi, I am working on a custom Pig source code that writes RDF data into text files. I was looking to instead *write to an ORCFile* for some of the columnar benefits it offers. I understand that I need ...
    Abhishek GirishAbhishek Girish
    Apr 6, 2014 at 11:18 pm
    Apr 7, 2014 at 6:43 pm
  • Hi all, We are randomly getting 2 types of exceptions while inserting data to hive. Seems like we encountered : HIVE-6114<https://issues.apache.org/jira/browse/HIVE-6114 , HIVE-6113 ...
    Lior SchachterLior Schachter
    Apr 1, 2014 at 12:56 pm
    Apr 6, 2014 at 2:55 pm
  • Hi, what do you guys think about this small feature : https://issues.apache.org/jira/browse/HIVE-6469<http://bl-1.com/click/load/AzcPPVQ3VWkHblUwCTs-b0231 Please comment. Thanks Jay
    JackyJacky
    Apr 1, 2014 at 7:26 pm
    Apr 1, 2014 at 7:35 pm
  • Hi All, My input data contains 45 columns, when I stored the data in hive table, end of the line in a block storing part of the line, so when I query its giving wrong result, please help me to store ...
    Kishore kumarKishore kumar
    Apr 29, 2014 at 8:36 am
    Apr 29, 2014 at 8:40 am
  • For some reason, I can't decrease the number of mappers in Hive (0.12) and Hadoop 2.2. I believe I was able to do that in 0.10. My table has 170K rows and 2000 small (20KB) uncompressed files (I'll ...
    Tatarinov, IgorTatarinov, Igor
    Apr 16, 2014 at 9:03 pm
    Apr 29, 2014 at 3:00 am
  • Nivedhita SathyamurthyNivedhita Sathyamurthy
    Apr 28, 2014 at 12:15 pm
    Apr 28, 2014 at 1:48 pm
  • Hi, I have a question related to hive table *bucketing* based on multiple columns(*Clustered by* on a common set of columns). How would be the join performance if I am joining this table to itself ...
    Krish wsKrish ws
    Apr 25, 2014 at 2:16 am
    Apr 27, 2014 at 12:37 am
  • Hi , I am running a map side in Hive , the mapred job continues to around 20 % and then terminates with the following error: org.apache.hadoop.ipc.RemoteException(java.io.IOException): File ...
    Anirudh kalaAnirudh kala
    Apr 23, 2014 at 7:38 pm
    Apr 23, 2014 at 10:27 pm
  • Hello Everybody, Firstly, I will be clear that I m using *Hive 0.10* and I do not have the choice to use more recente release. When starting a hive request the log file size increases extremely, ...
    Amjad ALSHABANIAmjad ALSHABANI
    Apr 23, 2014 at 2:59 pm
    Apr 23, 2014 at 3:41 pm
  • Hi All, I have successfully Kerberized the CDH5 & Hive. Now I can do a kinit & then issue hive queries. Next I wanted to access hive remotely from standalone java client using keytab file so that ...
    Savant, KeshavSavant, Keshav
    Apr 18, 2014 at 10:22 am
    Apr 22, 2014 at 11:40 am
Group Navigation
period‹ prev | Apr 2014 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions88
posts296
users115
websitehive.apache.org

115 users for April 2014

Kishore kumar: 14 posts Prasanth Jayachandran: 11 posts Shengjun Xin: 9 posts Bryan Jeffrey: 8 posts EdwardKing: 8 posts Lefty Leverenz: 8 posts Nitin Pawar: 8 posts Chinna Rao Lalam: 7 posts Rishabh Bhardwaj: 7 posts Saquib khan: 7 posts Subramanian, Sanjay (HQP): 6 posts Abhishek Girish: 5 posts David Quigley: 5 posts Edward Capriolo: 5 posts Saumitra Shahapure: 5 posts Szehon Ho: 5 posts Thejas Nair: 5 posts Abdelrahman Shettia: 4 posts Abhay Bansal: 4 posts Amit Tewari: 4 posts
show more
Archives