Grokbase Groups Hive user July 2015
FAQ

Search Discussions

63 discussions - 176 posts

  • Hi all, As I'm trying to build a secured and multi-tenant Hadoop cluster with Hive, I am desperately trying to set a timeout to Hive requests. My idea is that some users can make mistakes such as a ...
    Loïc ChanelLoïc Chanel
    Jul 29, 2015 at 12:52 pm
    Jul 30, 2015 at 8:04 am
  • Hi, I am using hive 0.14 with Tez engine. Found a weird problem. Any suggestions? hive select count(*) from 4D; line 1:1 character '' not supported here line 1:2 character '' not supported here line ...
    PatchareePatcharee
    Jul 18, 2015 at 10:07 am
    Jul 20, 2015 at 8:27 am
  • Hi Team, Is there any Hive <- Tez support matrix? For example, Hive 1.2 should be on Tez which version? Tez 0.5.3 only supports which versions of Hive? etc… My understanding is that it does not ...
    Jim GreenJim Green
    Jul 7, 2015 at 5:12 pm
    Jul 7, 2015 at 11:56 pm
  • We are trying to create a external table in hive. This data is sorted, so wanted to tell hive about this. When I do, it complains about parsing the create. ... . . . . . . . . . . . . . . . . . . ...
    David CapwellDavid Capwell
    Jul 31, 2015 at 2:23 am
    Aug 3, 2015 at 6:23 pm
  • Hi Team, Env: Hive 1.0 on Tez 0.5.3 Query is a simple group-by on top of sequence table. It fails with below error on tez mode: *java.lang.RuntimeException ...
    Jim GreenJim Green
    Jul 21, 2015 at 6:12 pm
    Jul 28, 2015 at 4:57 pm
  • Hello All, We are facing following issue while running hive on linux operating system : Exception in thread "main" java.lang.UnsupportedClassVersionError: org/apache/hadoop/hive/cli/CliDriver ...
    Ravi Kumar Jain 03Ravi Kumar Jain 03
    Jul 9, 2015 at 4:57 am
    Jul 9, 2015 at 7:55 am
  • Hi Folks, I want to find Max value from the HiveResult. There is option listed in HiveResultSet properties "HiveResultSet.Max()". When i use this 'HiveResultSet.Max()' it throws exception. Error : At ...
    Renuka BeRenuka Be
    Jul 31, 2015 at 5:43 am
    Jul 31, 2015 at 11:00 am
  • Hi, We are facing issue with our hive query with ArrayIndexoutofbound exception. I have tried googling out and I see many users facing the same error, but no solution yet. This is a blocker for our ...
    Ravi tejaRavi teja
    Jul 31, 2015 at 6:44 am
    Jul 31, 2015 at 7:28 am
  • Hi, I've been experimenting with 'select *' and 'select * limit X' in beeline and watching the hive-server2 log to understand when a M/R job is triggered and when not. It seems like whenever I set a ...
    Adam SilbersteinAdam Silberstein
    Jul 22, 2015 at 1:37 am
    Jul 22, 2015 at 5:31 pm
  • Hi, In the following query, it is possible to limit the amount of entries returned by an outer join to a single value? I want to obtain a single country from ipv4geotable for each entry in ...
    Bennie LeoBennie Leo
    Jul 6, 2015 at 11:31 pm
    Jul 7, 2015 at 11:07 pm
  • Hi folks, I need to set up a connection between perl and hive using thrift. Can anyone sugggest me the steps involved in making this happen?. Thanka and regrads, siva.
    Siva kumarSiva kumar
    Jul 29, 2015 at 7:42 am
    Aug 6, 2015 at 12:37 pm
  • Is there a way to obtain user authentication information in a UDF like kerberos username that they have logged in with to execute a hive query. I would appreciate any help. Thanks Adeel
    Adeel QureshiAdeel Qureshi
    Jul 27, 2015 at 8:14 pm
    Aug 3, 2015 at 3:58 pm
  • Hi , There is some data loaded into hive and i want to display hive data into a html webpage based on the parameters i pass. So, how can i do this? Any Help? Thanks in Advance siva.
    Siva kumarSiva kumar
    Jul 27, 2015 at 1:46 pm
    Jul 31, 2015 at 6:38 pm
  • Hi, I'm trying to optimize a UDF that runs very slowly on Hive. The UDF takes in a 5GB table and builds a large data structure out of it to facilitate lookups. The 5GB input is loaded into the ...
    Bennie LeoBennie Leo
    Jul 14, 2015 at 8:38 pm
    Jul 15, 2015 at 1:27 am
  • Hi, I have a table with some array fields, when preview them using "select limit" at beeline, I got following errors, it seems the typeinfo string is changed from array<string to struct< I am using ...
    Binglin ChangBinglin Chang
    Jul 7, 2015 at 11:44 am
    Jul 8, 2015 at 9:43 am
  • Hi all, I would like to have multiple users to access hive. Does anyone try that before? Is there any tutorial or link I can study from? Best regards, Jack
    Jack YangJack Yang
    Jul 7, 2015 at 6:04 am
    Jul 8, 2015 at 4:22 am
  • Hi folks, just to let my fellow Hive users know that we found a bug with subquery in where clauses and created a JIRA for it. https://issues.apache.org/jira/browse/HIVE-11192 The latest version seems ...
    Furcy PinFurcy Pin
    Jul 7, 2015 at 10:47 am
    Jul 7, 2015 at 4:48 pm
  • Hi, Is there any official way to verify that a query leveraged orc bloom filters or orc indexes? For example, number of bytes (rows) not processed thanks to bloom filters or storage indexes? Some ...
    Jörn FrankeJörn Franke
    Jul 30, 2015 at 4:31 pm
    Jul 31, 2015 at 2:13 am
  • Hi Experts, I have table in hive in which i have to update certain records. I am using hive 0.13 version. I did bit of googling and found that i can use If-Else statement with insert overwrite for ...
    Shashi VishwakarmaShashi Vishwakarma
    Jul 24, 2015 at 5:40 am
    Jul 24, 2015 at 7:11 am
  • Hi, All, I am using Hive-1.2.1, and store table as Parquet. Now I have a query as below: select count(1) from lineitem where l_quantity=1.0; I read the document of Parquet, it said Parquet have the ...
    Yue LiuYue Liu
    Jul 11, 2015 at 3:42 am
    Jul 12, 2015 at 1:25 am
  • Hi All , I have installed Hadoop 2.0 , Hive 0.12 on Cent OS 7. When I run a query in Hive - select count(*) from u_data ; it gives following errors. , However I can run select * from u_data ; pls ...
    Ajeet OAjeet O
    Jul 9, 2015 at 1:49 pm
    Jul 9, 2015 at 2:17 pm
  • Hi, The add jar/file syntax stated on hive language manual is as below: ADD { FILE[S] | JAR[S] | ARCHIVE[S] } <filepath1 [<filepath2 ]* I have an application which remotely connects to hiveserver2 ...
    Lonikar, KiranLonikar, Kiran
    Jul 8, 2015 at 3:31 pm
    Jul 9, 2015 at 9:27 am
  • Hi Users, I have Hive and HiveServer2 on the same machine. But, when I try to *LOAD DATA LOCAL INPATH* using BeeLine I get "Invalid Path Error" and if I do LOAD DATA INPATH it takes it successfully ...
    Trainee BingoTrainee Bingo
    Jul 6, 2015 at 9:15 am
    Jul 6, 2015 at 11:17 am
  • when i map the hive table to locate the s3 path, it throws exception for the* new line at the beginning of line*. Is there a solution to trim the new line at the beginning in hive? Or any ...
    Ram kumarRam kumar
    Jul 3, 2015 at 12:15 pm
    Jul 5, 2015 at 10:54 am
  • I would like to create a table in hive using Java. Using the following way to do it: public class HiveCreateTable { private static String driverName = "com.facebook.presto.jdbc.PrestoDriver"; public ...
    Sateesh KaruturiSateesh Karuturi
    Jul 31, 2015 at 11:56 am
    Jul 31, 2015 at 12:12 pm
  • Hello Team, I am trying to load some data encoded in ISO-8859 into hive tables. Version: 0.13. The ascents and special symbols allowed in this character set are coming as some junk when I query this ...
    Murali parimiMurali parimi
    Jul 30, 2015 at 7:24 pm
    Jul 30, 2015 at 8:15 pm
  • Hi, I am using Hive 1.2, and I am trying to run some queries based on TPCH schema. My original query is: SELECT N_NAME, AVERAGE(C_ACCTBAL) FROM customer JOIN nation on C_NATIONKEY=N_NATIONKEY GROUP ...
    James PirzJames Pirz
    Jul 30, 2015 at 12:03 am
    Jul 30, 2015 at 12:57 am
  • Hi, I am using the OrcFile.createWriter() function to get an ORC writer to write ORC files. However, upon inspecting the ORC files in HDFS, I notice that they have a block size of 256MB. Now, I would ...
    Ashish ShenoyAshish Shenoy
    Jul 30, 2015 at 12:22 am
    Jul 30, 2015 at 12:28 am
  • Hi, all Even I user impersonation, running "create database test01" in beeline (and hue that uses hs2) makes a directory in HDFS owned by *hive* user. However, table directories and files under it ...
    Han-Cheol ChoHan-Cheol Cho
    Jul 28, 2015 at 8:52 am
    Jul 29, 2015 at 8:28 pm
  • iam using hive 1.0 and tez 0.7 whenever iam performing insert query its returns following error: execution error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.teztask
    Sateesh KaruturiSateesh Karuturi
    Jul 29, 2015 at 9:55 am
    Jul 29, 2015 at 1:00 pm
  • Hi all, I get a exception on hiveserver 2 , what's meaning?how to fix it? ENV: CDH 5.4.2 Here is trace from HiveServer2 : Error occurred during processing of message. java.lang.RuntimeException ...
    Pengcheng LiangPengcheng Liang
    Jul 29, 2015 at 3:56 am
    Jul 29, 2015 at 5:13 am
  • Hi, My application is using hive extenal tables with ORC and needs some special logic to filter out some input files. I was thinking to write a custom InputFormat extending OrcInputFormat. create ...
    Jie ZhangJie Zhang
    Jul 25, 2015 at 12:40 am
    Jul 25, 2015 at 2:02 am
  • and i wonder if this audience could help me out in any way. Here is a link to the request i put out on StackOverflow. I need help retrieving sub arrays from JSON with a HIVE query Thanks TJay
    TJay BeltTJay Belt
    Jul 23, 2015 at 10:05 pm
    Jul 24, 2015 at 1:41 am
  • Hi All, Is there any data type in hive which only stores positive values and converts the negative values to ZERO? This can be handled while data processing e.g. CASE statement or COLEASCE(IF()), ...
    SaurabhSaurabh
    Jul 23, 2015 at 10:27 am
    Jul 23, 2015 at 3:55 pm
  • Hi! I use hbase column regex matching to create map column in hive, like: "hbase.columns.mapping" = ":key,s:ap_.*" then I have values in column: {"ap_col1":"23","ap_col2":"7"} is it possible to cut ...
    Wojciech IndykWojciech Indyk
    Jul 7, 2015 at 7:51 am
    Jul 21, 2015 at 2:40 pm
  • Hi Guys, I am writing the simple hive query,Receiving the following error intermittently. This error presents itself for 30min-2hr then goes away. Appreciate your help to resolve this issue. Error ...
    Anupam sinhaAnupam sinha
    Jul 16, 2015 at 2:26 pm
    Jul 16, 2015 at 4:05 pm
  • hi all: I‘m creating a transactional supportted table use sql: create table test(id int ,name string )clustered by (id) into 2 buckets stored as orc TBLPROPERTIES('transactional'='true'); but when i ...
    FunFun
    Jul 16, 2015 at 12:46 pm
    Jul 16, 2015 at 1:44 pm
  • Hey! I'm trying to write a tool which uses a storagehandler to store HFiles, using a specific partition function. So in order to do this, I have been trying to use DISTRIBUTE BY and a UDF using the ...
    Connell DonaghyConnell Donaghy
    Jul 13, 2015 at 8:50 pm
    Jul 13, 2015 at 8:57 pm
  • Hi All, I am trying to setup a remote metastore for Hive using Oracle. The following is my steps and error message when try to start hive. Please help and thank you very much. Garry 1. Create a hive ...
    Garry ChenGarry Chen
    Jul 13, 2015 at 2:48 pm
    Jul 13, 2015 at 8:30 pm
  • Hi, I have a partitioned table. Is it possible to alter this table by adding a new column and also update the table by inserting data into the new column? I know how to add a new column but no idea ...
    Mona MeenaMona Meena
    Jul 8, 2015 at 8:58 pm
    Jul 9, 2015 at 7:52 am
  • Hi All, I'm having a problem in Hive 0.13.0 using INSERT OVERWRITE with dynamic partitioning, selecting from an ORC table to another ORC table (I don't think the target table being ORC is ...
    Dave MaughanDave Maughan
    Jul 8, 2015 at 6:57 pm
    Jul 9, 2015 at 1:10 am
  • Payal Radheshamji AgrawalPayal Radheshamji Agrawal
    Jul 6, 2015 at 12:46 pm
    Jul 7, 2015 at 4:21 am
  • Hi, We are in process of exploring TEZ for Hive 0.14. Needed some pointers to start on Hive with Tez. E.g. in Hive HDFS Block size plays a vital role in getting the number of Mappers and later ...
    SaurabhSaurabh
    Jul 5, 2015 at 2:40 pm
    Jul 6, 2015 at 7:08 am
  • Hi Team, Is HIVE-8204 really fixed or not? Below test can reproduce exactly the same stacktrace when dynamic partition pruning is enabled. *1. Create test tables* create table h1_fact(id int, id2 ...
    Jim GreenJim Green
    Jul 1, 2015 at 8:44 pm
    Jul 2, 2015 at 6:04 pm
  • Hi Everyone, I am using following sqlContext var df=sqlContext.sql("SELECT fullname,SUM(CAST(contactid AS decimal(38,6))) FROM adventurepersoncontacts GROUP BY fullname ORDER BY fullname ASC"); It ...
    Vinod KuamrVinod Kuamr
    Jul 1, 2015 at 9:57 am
    Jul 1, 2015 at 10:04 am
  • Hi, I am using hive jdbc. I have a result set object, I want to navigate it in forward and backward direction as well. By default result set behavior is TYPE_FORWARD_ONLY. Why does hive jdbc does not ...
    Reena upadhyayReena upadhyay
    Jul 31, 2015 at 10:30 am
    Jul 31, 2015 at 10:30 am
  • Hi Everyone, I am currently stepping through Hive test cases to understand the code flow. For debugging, I launch the UTs through “mvnDebug” and use the remote debugging feature in eclipse to ...
    RaajayRaajay
    Jul 31, 2015 at 3:10 am
    Jul 31, 2015 at 3:10 am
  • Hello everyone, How do I view the logs generated using "log4j" logger while running the query tests from "itest/qtest" ? Also, how to set the log4j properties, since I need to view the most detailed ...
    RaajayRaajay
    Jul 31, 2015 at 12:59 am
    Jul 31, 2015 at 12:59 am
  • Hello, I am currently playing around with Hive Semantic Analysis code, to understand how DAGs or Map Reduce plans are generated from Abstract Syntax Trees. The idea is to explore various possible ...
    RaajayRaajay
    Jul 30, 2015 at 5:28 pm
    Jul 30, 2015 at 5:28 pm
  • I am using HDInsight, and can issue table commands to my MongoDB system, but its not acting like i think it should.I realize that when i create an external table in hive, and give it mongodb ...
    TJay BeltTJay Belt
    Jul 29, 2015 at 9:09 pm
    Jul 29, 2015 at 9:09 pm
Group Navigation
period‹ prev | Jul 2015 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions63
posts176
users77
websitehive.apache.org

77 users for July 2015

Gopal Vijayaraghavan: 11 posts Nitin Pawar: 11 posts Jim Green: 9 posts Loïc Chanel: 9 posts Bennie Leo: 6 posts Xuefu Zhang: 5 posts Ajeet O: 4 posts Bikas Saha: 4 posts Noam Hasson: 4 posts Pth001: 4 posts Adam Silberstein: 3 posts Binglin Chang: 3 posts Jeff Zhang: 3 posts Lefty Leverenz: 3 posts Raajay: 3 posts Ravi Kumar Jain 03: 3 posts Ravi teja: 3 posts Renuka Be: 3 posts Siva kumar: 3 posts Wojciech Indyk: 3 posts
show more
Archives