FAQ

Search Discussions

81 discussions - 252 posts

  • I am pleased to announce that Alan Gates has been elected to the Hive Project Management Committee. Please join me in congratulating Alan! Thanks. - Carl
    Carl SteinbachCarl Steinbach
    Oct 27, 2014 at 10:40 pm
    Oct 28, 2014 at 3:42 pm
  • Any reason why select from_unixtime(0) t0 FROM … gives 1970-01-01 01:00:00 ? By all available definitions (epoch, from_unixtime etc..) I would expect it to be 1970-01-01 01:00:00…?
    MaciekMaciek
    Oct 31, 2014 at 12:01 pm
    Nov 6, 2014 at 4:36 pm
  • Hi, The date time format coming from the source is* "25-FEB-01' .* I want to convert it to the following format. *'MM/DD/YYYY' *. How can we do this in Hive? I see that as per the documentation ...
    Vidya SujeetVidya Sujeet
    Oct 26, 2014 at 6:56 pm
    Oct 27, 2014 at 12:46 am
  • Hi, I have worked on a feature update https://issues.apache.org/jira/browse/HIVE-8267. If it get pushed then it will outdate the https://cwiki.apache.org/confluence/display/Hive/HBaseIntegration ...
    Ehsan ul HaqEhsan ul Haq
    Oct 1, 2014 at 1:51 pm
    Oct 15, 2014 at 3:42 am
  • Hi, On https://cwiki.apache.org/confluence/display/Hive/Hive+Default+Authorization+-+Legacy+Mode#HiveDefaultAuthorization-LegacyMode-Grant/RevokePrivileges , GRANT shows as: GRANT priv_type ...
    Brett RandallBrett Randall
    Oct 9, 2014 at 12:24 pm
    Oct 15, 2014 at 3:50 am
  • Hi, I am using Beeline client to connect to hiveserver2 on linux machine. In terminal when i run query: "select * from table"; It only show first few columns in case there is large no.of columns in ...
    Hanish BansalHanish Bansal
    Oct 31, 2014 at 7:04 pm
    Nov 4, 2014 at 12:54 pm
  • Hi All, I am planning to use sql based authorization that is recently introduced in hive 0.13.0. I was using hive metastore client java api early which has direct apis for all operations like grant, ...
    Hanish BansalHanish Bansal
    Oct 11, 2014 at 4:22 am
    Oct 14, 2014 at 10:00 pm
  • Hi, I need to test hive request in a full local mode. For the metastore, no problem to start in an embedded mode. I'm using hive jdbc. My problem is that the ExecDriver try to launch ...
    Yoel BenharrousYoel Benharrous
    Oct 7, 2014 at 1:14 pm
    Oct 7, 2014 at 4:24 pm
  • Hi guys, I run some simple hive query and got the error below: Status: Running (application id: application_1412033199033_6623) Map 1: -/- Reducer 2: 0/1 Status: Failed Vertex failed, vertexName=Map ...
    Echo LiEcho Li
    Oct 3, 2014 at 11:52 pm
    Oct 5, 2014 at 5:42 pm
  • Hi , I get Null Pointer Exception sometimes when I run queries with Tez as hive execution engine .. But the same queries run fine with MR ( map reduce ) . Is there any config changes I need to make ...
    AnushaAnusha
    Oct 3, 2014 at 1:28 pm
    Oct 6, 2014 at 12:55 pm
  • Hi! I'm trying to run a simple join with two tables stored as ORC File. (the same query runs normally without ORC File) I got this error while map-reduce job: Driver returned: 2. Errors: OK Query ID ...
    Thiago Henrique dos Santos BentoThiago Henrique dos Santos Bento
    Oct 1, 2014 at 2:43 pm
    Oct 3, 2014 at 1:55 pm
  • Hello all, I have a use case where I need to do inner join.. Like select A.iteam , B.Decsription, from iteam_table A INNER JOIN iteam_desc B on A.id = B.id As hive does not support Inner Join, Please ...
    Yogesh dhariYogesh dhari
    Oct 15, 2014 at 7:48 am
    Oct 15, 2014 at 9:17 am
  • http://www.unmeshasreeveni.blogspot.in/2014/09/what-do-you-think-of-these-three.html -- *Thanks & Regards * *Unmesha Sreeveni U.B* *Hadoop, Bigdata Developer* *Center for Cyber Security | Amrita ...
    Unmesha sreeveniUnmesha sreeveni
    Oct 6, 2014 at 7:45 am
    Oct 7, 2014 at 5:37 am
  • The Apache Hive PMC has voted to make John Pullokkaran a committer on the Apache Hive Project. Please join me in congratulating John! Thanks. - Carl
    Carl SteinbachCarl Steinbach
    Oct 1, 2014 at 3:19 pm
    Oct 2, 2014 at 4:37 am
  • + hive user group. :) ---------- Forwarded message ---------- From: Gordon Wang <<span class="m_body_email_addr" title="c68bdd9dcb7aae589d25c5ddac27ddc3" gwang@pivotal.io</span Date: Tue, Oct 28, ...
    Gordon WangGordon Wang
    Oct 28, 2014 at 3:42 am
    Oct 29, 2014 at 1:29 am
  • ??Hello, I've been puzzling away at a permissions issue I get through the hcatalog interface for a while now, and I think perhaps I've found a bug. When I create a table via the hive cli as user ...
    Nathan BamfordNathan Bamford
    Oct 22, 2014 at 7:51 pm
    Oct 28, 2014 at 9:54 pm
  • *Part 1: my enviroment* I have following files uploaded to Hadoop: 1. The are plain text 2. Each line contains JSON like: {code:[int], customerId:[string], data:{[something more here]}} 1. code are ...
    Ja SamJa Sam
    Oct 21, 2014 at 5:37 pm
    Oct 22, 2014 at 3:41 pm
  • Hi, With ORCFiles data inserted into the first table only. Hive 0.13 test: create table orc1 stored as orc tblproperties ("orc.compress"="ZLIB") as select rn from ( select cast(1 as int) as rn from ...
    Dmitry TolpekoDmitry Tolpeko
    Oct 16, 2014 at 8:30 am
    Oct 17, 2014 at 6:40 pm
  • We upgraded from hadoop-2.0.0 to hadoop-2.4.0, without upgrading hive and still using hive 0.9(not recompiled with hadoop2.4) Normal queries work well, like count and udf, but some queries with JOIN ...
    张鹏张鹏
    Oct 15, 2014 at 3:18 pm
    Oct 16, 2014 at 3:39 am
  • Hi all, Does Hive support multilines for a record? Eg: xml data with more than 1 line. 2 XML data records: <a id='1' <b </b </a <a id='2' <b </b </a I try to implement a InputFormat (GetSplits and ...
    Ltcuong211Ltcuong211
    Oct 29, 2014 at 6:50 pm
    Oct 31, 2014 at 3:01 pm
  • Hi, I would like to get write access for the Hive wiki. My Confluence username is jcamachorodriguez. Thanks, Jesús -- CONFIDENTIALITY NOTICE NOTICE: This message is intended for the use of the ...
    Jesus Camacho RodriguezJesus Camacho Rodriguez
    Oct 30, 2014 at 2:56 am
    Oct 30, 2014 at 6:01 am
  • I want to write to a new ORC file from a map/reduce job outside of Hive. I’d like to setup a job without using the format like this: job.setOutputFormatClass(OrcNewOutputFormat.class); But instead ...
    Robert TowneRobert Towne
    Oct 28, 2014 at 10:36 pm
    Oct 29, 2014 at 1:42 am
  • Dear all, Is there a metastore side authorization perform like SQL standard based authorization? Thanks~~
    Zhanghe (D)Zhanghe (D)
    Oct 27, 2014 at 3:03 am
    Oct 27, 2014 at 10:50 am
  • hi , I wanted to make some edits to the Hadoop main page. https://wiki.apache.org/hadoop/FrontPage Not able to trace the list of administrators / place a request for granting edit rights. Any ...
    Devopam MittraDevopam Mittra
    Oct 24, 2014 at 4:34 am
    Oct 24, 2014 at 8:18 am
  • Hi all, Recently I've run into a problem with incorrect results in one of the queries on our system after upgrade from Hive 0.8.1.4 to 0.13.1. We use Amazon Elastic Map Reduce servivce on Amazon. I ...
    Michal KrawczykMichal Krawczyk
    Oct 21, 2014 at 12:21 pm
    Oct 22, 2014 at 7:40 am
  • I am able to see the data in the table for all the columns when I issue the following - SELECT * FROM t1 WHERE dt1='2013-11-20' But I am unable to see the column data when i issue the following - ...
    Raj HadoopRaj Hadoop
    Oct 20, 2014 at 6:56 pm
    Oct 21, 2014 at 9:19 pm
  • Hi, Could you please help me how to calculate cumulative sum with Hive? Like RSUM in Oracle? Thanks. -- Best Regards, *Meri-Tuulia Rautavuori* *Business Analyst* SongHi Entertainment Ltd ...
    Meri-Tuulia RautavuoriMeri-Tuulia Rautavuori
    Oct 14, 2014 at 12:48 pm
    Oct 15, 2014 at 6:29 am
  • Has anyone seen anything like this? Google searches turned up nothing, so I thought I'd ask here, then file a JIRA if no-one thinks I'm doing it wrong. If I ALTER a particular table with three ...
    Time LessTime Less
    Oct 14, 2014 at 5:38 am
    Oct 15, 2014 at 1:13 am
  • subscribe
    Arthur Hk ChanArthur Hk Chan
    Oct 11, 2014 at 10:48 pm
    Oct 14, 2014 at 9:27 pm
  • Hi, My Hive version is 0.13.1, I tried a smoke test, after 1 days 7 hours 5 minutes 19 seconds 70 msec, the job failed with error: Error: GC overhead limit exceeded LOG: 2014-10-12 06:16:07,288 ...
    Arthur Hk ChanArthur Hk Chan
    Oct 11, 2014 at 10:50 pm
    Oct 13, 2014 at 4:42 pm
  • Hi, I am connecting to hive server2 through jdbc and want to set some properties like mapreduce.queuename;hive.compute.query.using.stats; how can I achieve that through java . Thanks, Navdeep
    Navdeep AgrawalNavdeep Agrawal
    Oct 10, 2014 at 11:12 am
    Oct 13, 2014 at 5:59 am
  • By setting mapreduce.job.queuename in hive-site.xml, all queries submitted via hiveserver or hive cli all go to the specified queue. However, hiveserver2 doesn't appear to respect this value at all ...
    Chen SongChen Song
    Oct 9, 2014 at 9:08 pm
    Oct 10, 2014 at 6:51 pm
  • Hi, When I insert data into a hive table like: Insert into hive_table Select columns This query overwrite existing data. Any idea how to insert data without overwriting data? Thiago Henrique S. Bento ...
    Thiago Henrique dos Santos BentoThiago Henrique dos Santos Bento
    Oct 8, 2014 at 2:52 pm
    Oct 9, 2014 at 3:52 am
  • Hello, I've encountered a situation when printing new lines corrupts (multiplies) the returned dataset. This seem to be similar to HIVE-3012 <https://issues.apache.org/jira/browse/HIVE-3012 (fixed on ...
    MaciekMaciek
    Oct 6, 2014 at 11:52 am
    Oct 7, 2014 at 8:59 pm
  • Hi, I have a single argument udf that takes the sql string as a argument. Inside the udf, I have used hive jdbc client to execute the query. My query execution part inside udf is working fine and ...
    Reena upadhyayReena upadhyay
    Oct 1, 2014 at 3:10 pm
    Oct 3, 2014 at 1:22 pm
  • Hi, I want to hide selected Databases and Tables from users. On file system level, we achieved it via file permissions. What we cannot do so far is to hide the corresponding metadata in HCatalog ...
    Papp, StefanPapp, Stefan
    Oct 31, 2014 at 2:57 pm
    Oct 31, 2014 at 3:53 pm
  • Hi Hive users, We create a table with sql which contains the dense_rank function,and then run count distinct on this table, we found that with diffrent dense_rank parameters or even defferent ...
    Ericni.niEricni.ni
    Oct 28, 2014 at 3:32 am
    Oct 29, 2014 at 9:34 am
  • I have a query that does something like SELECT * from mytable where my_id in ('1', '2', '3', '4' ); now instead of hard coding the value list in the (), I'd like to pass it in as a param I tried "in ...
    YangYang
    Oct 27, 2014 at 9:58 pm
    Oct 28, 2014 at 1:58 am
  • I have to run some processes in parallel, for different input datasets. in each of the processes, one step is insertion into a hive table, shared by all these processes. would I get conflicts if the ...
    YangYang
    Oct 23, 2014 at 7:43 pm
    Oct 24, 2014 at 3:48 am
  • Hi guys, Not sure if you run into this problem. We have 6 nodes cluster with CDH5. It takes about 8 hours to process 80MB compressed files (in .deflate format), while it is much faster (less than 1 ...
    Yan FangYan Fang
    Oct 22, 2014 at 3:07 pm
    Oct 22, 2014 at 3:47 pm
  • Hi, Hive (0.12) seems to be very inconsistent with the duration for dropping a table. The tables' size varies between 5-10 GB. Here is an example of few drops done in a row : [hadoop@server ~]$ hive ...
    Dima MachlinDima Machlin
    Oct 22, 2014 at 9:45 am
    Oct 22, 2014 at 10:21 am
  • Hello All, We are having a use case where we need to create the hierarchical structure using Hive and Java For example Lets say in an organisation we need to create Org chart i.e. Senior director - ...
    Yogesh dhariYogesh dhari
    Oct 22, 2014 at 5:56 am
    Oct 22, 2014 at 9:12 am
  • Hi folks, I have a requirement where I need to migrate metastore tables from mysql to oracle. Is there any who already performed this kind of activity. Any help will be appreciated Thanks Vikas ...
    Hadoop hiveHadoop hive
    Oct 21, 2014 at 9:37 am
    Oct 21, 2014 at 9:24 pm
  • Hello, I am experiencing inconsistent behavior when trying to use UDF on 0.13.1 on Amazon's EMR (AMI 3.2.1). I generated a uber jar and deployed a UDF like so: create temporary function someFunction ...
    Harel GliksmanHarel Gliksman
    Oct 20, 2014 at 2:59 pm
    Oct 21, 2014 at 7:02 am
  • Hello All How can we achive *start with .. connect by* clause can be used to select data that has a hierarchical relationship (usually some sort of parent- child (boss- employee or thing- parts) ...
    Yogesh dhariYogesh dhari
    Oct 20, 2014 at 7:12 am
    Oct 20, 2014 at 8:29 pm
  • Hi Could you please agree on my request of write access to the Hive wiki? My Confluence usename is pxiong. Thanks! Best Pengcheng
    KelphetKelphet
    Oct 16, 2014 at 5:55 am
    Oct 16, 2014 at 7:18 am
  • Hi all, About an half an hour ago, the Hive user group meetup NY was concluded. It had 7 talks and a lot of content was covered. Representing Hive community, I'd like to thank those who gave talks or ...
    Xuefu ZhangXuefu Zhang
    Oct 16, 2014 at 2:32 am
    Oct 16, 2014 at 2:48 am
  • I am looking at this page: https://cwiki.apache.org/confluence/display/Hive/Locking I have two questions. First, what is the shared/exclusive locking behaviour of "alter table T1 partition(P1) ...
    Time LessTime Less
    Oct 14, 2014 at 2:38 am
    Oct 14, 2014 at 8:57 am
  • Dear Hive users/developers, The next Hive user group meeting is around the corner. It will be held on Oct. 15th, from 6:30pm to 9:00pm at 1500 Broadway, 6th floor, New York, NY 10036. This will be a ...
    Xuefu ZhangXuefu Zhang
    Oct 2, 2014 at 5:36 pm
    Oct 13, 2014 at 6:27 pm
  • Hi all, Wondering of its possible for me to set a variable via a query. Something like: Set V1= select max(V1) from sometable And then use V1 in my query. Thx! Sent from my iPhone
    Martin, NickMartin, Nick
    Oct 11, 2014 at 1:26 am
    Oct 11, 2014 at 4:06 am
Group Navigation
period‹ prev | Oct 2014 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions81
posts252
users106
websitehive.apache.org

106 users for October 2014

Lefty Leverenz: 21 posts Suhas Gogate: 14 posts Vidya Sujeet: 8 posts Xuefu Zhang: 7 posts Devopam Mittra: 6 posts Edward Capriolo: 6 posts Maciek: 6 posts Prasanth Jayachandran: 6 posts Sanjay Subramanian: 6 posts Harpreet Singh Bedi: 5 posts Brett Randall: 4 posts Echo Li: 4 posts Hanish Bansal: 4 posts Nathan Bamford: 4 posts Navdeep Agrawal: 4 posts Navis류승우: 4 posts Thiago Henrique dos Santos Bento: 4 posts Unmesha sreeveni: 4 posts Yoel Benharrous: 4 posts Yogesh dhari: 4 posts
show more
Archives