Grokbase Groups Hive user May 2015

Search Discussions

71 discussions - 227 posts

  • Hive on Spark and SparkSQL which should be better , and what are the key characteristics and the advantages and the disadvantages between ? <span class="m_body_email_addr" ...
    May 20, 2015 at 5:41 am
    May 28, 2015 at 1:10 am
  • Hi Hive Users, I'm using cloudera's hive 0.13 version which by default provide Kryo plan serialization format. <property <name hive.plan.serialization.format</name <value *kryo*</value </property As ...
    Bhagwan S. SoniBhagwan S. Soni
    May 1, 2015 at 4:41 pm
    May 7, 2015 at 10:31 pm
  • Hi, When a hive query is submitted to hiveserver2 over JDBC, is there a way to get the Hadoop job id (and status) for the hive query? The JDBC call "statement.execute(hiveQuery)" is a blocking call ...
    Lonikar, KiranLonikar, Kiran
    May 29, 2015 at 4:23 am
    Jun 3, 2015 at 1:14 am
  • While moving the data from hive/hdfs we get below error, Please suggest on this. Moving data to ...
    Amit kumarAmit kumar
    May 4, 2015 at 9:42 pm
    May 4, 2015 at 11:39 pm
  • Hi, After re-create my account in Hue, i receives “User matching query does not exist” when attempting to perform hive query. The query is succeed in hive command line. Please suggest on this, ---- ...
    Amit kumarAmit kumar
    May 15, 2015 at 4:13 am
    May 15, 2015 at 8:53 am
  • Hi, I have a question on Hive Optimizer. I have a table with partition columns eg.,Sales partitioned by year, month, day. Assume that I have two years worth of data on this table. I'm running two ...
    Appan ThirumaligaiAppan Thirumaligai
    May 14, 2015 at 8:48 pm
    May 15, 2015 at 7:17 am
  • Dear all, I installed CDH, kerberos, sentry to enable security for hive beeline. I did following commands: # kinit -k -t hive.keytab hive/ <span class="m_body_email_addr" ...
    Liping ZhangLiping Zhang
    May 13, 2015 at 3:18 pm
    May 14, 2015 at 3:27 am
  • I change the sql where condition to (where t.update_time = '2015-05-04') , the sql can return result for a while. Because t.update_time = '2015-05-04' can filter many row when table scan. But why ...
    May 6, 2015 at 12:52 am
    May 12, 2015 at 1:47 am
  • Hi All, I have set up hive source code as per HiveDeveloperFAQ#HiveDeveloperFAQ-HowdoIimportintoEclipse ...
    Suraj NayakSuraj Nayak
    May 8, 2015 at 7:36 pm
    May 9, 2015 at 4:17 pm
  • Hi, I've just upgraded to Hive 1.1.0 and it looks like there is a problem with the distributed cache. I use ADD FILE, then an UDF that wants to read the file. The following syntax works in Hive 1.0.0 ...
    Zsolt TóthZsolt Tóth
    May 5, 2015 at 12:01 pm
    Jun 30, 2015 at 2:50 pm
  • Hi, We are trying to create a Hive ORC Table with Tez. DDL command for the same is create table orc_table ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' STORED AS ORC AS ...
    Vijay BhoomireddyVijay Bhoomireddy
    May 21, 2015 at 2:30 am
    Jun 4, 2015 at 1:12 pm
  • I have upgrade of Hadoop cluster from 5.1.2 to 5.2.1. Now i am unable to read the hive tables, before the upgrade i am able to access the Hive StoreOps Database. Please suggest any changes i need to ...
    Anupam sinhaAnupam sinha
    May 21, 2015 at 4:01 am
    May 25, 2015 at 12:59 am
  • Dear All: I am new to hive so pardon my ignorance. I have the following query but do not see any output. I wondered it maybe in HDFS and checked there and do not find it there. Can somebody advise ...
    Anand MuraliAnand Murali
    May 16, 2015 at 11:40 am
    May 19, 2015 at 7:09 pm
  • Hi, I am trying to access a lookup file from a udf. There are two ways I add lookup file to distribute cache option1: loading file from local disk to distributed cache this is for hive cli add file ...
    Nitin PawarNitin Pawar
    May 16, 2015 at 9:16 pm
    May 18, 2015 at 10:36 pm
  • Hi, We are facing a weird error in a multi-stage mapreduce job ( 10 jobs). A few stages run fine and then randomly 1 of the job would fail with the following error: 2015-05-07 07:56:01,467 WARN ...
    Viral BajariaViral Bajaria
    May 7, 2015 at 8:31 am
    May 15, 2015 at 7:45 pm
  • Hi All, I'm writing an MR job to read data using HCatInputFormat... however, the job is generating too many splits. I don't have this problem when running queries in Hive since it combines splits by ...
    Pradeep GollakotaPradeep Gollakota
    May 14, 2015 at 6:36 am
    May 14, 2015 at 10:23 pm
  • Hi, While creating a table in Hive I am getting this error message. CREATE TABLE abcd(key int, value string) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ...
    Ibrar AhmedIbrar Ahmed
    May 14, 2015 at 8:21 pm
    May 14, 2015 at 8:42 pm
  • Hi, I am creating a table using hive and getting this error. [] hive CREATE TABLE hbase_table_1(key int, value string) [Hive Error]: Query returned non-zero code: 1, cause: FAILED ...
    Ibrar AhmedIbrar Ahmed
    May 13, 2015 at 6:58 pm
    May 14, 2015 at 8:31 am
  • SELECT .... FROM A LEFT SEMI JOIN B ON (A.col1 = B.col2) WHERE ... " If A.col1 is of DOUBLE type, but B.col2 is of BIGINT, will print WARNING: Comparing a bigint and a double may result in a loss of ...
    May 4, 2015 at 5:13 am
    May 7, 2015 at 5:15 am
  • Hi, Per this ticket: , the max column size in hive is limited to 4000 chars. But i do read that there is a way to increase it via *mysql* which is our ...
    Udit MehtaUdit Mehta
    May 29, 2015 at 1:09 am
    May 29, 2015 at 5:52 am
  • I’m getting the following exception when Hive executes a query on an external table. It seems the postscript isn’t written even though .close() is called and returns normally. Any thoughts? ...
    Grant Overby (groverby)Grant Overby (groverby)
    May 22, 2015 at 4:39 pm
    May 26, 2015 at 5:49 pm
  • Hi, I'm using Hive14 on a HDP2.2-Cluster and have a problem with indexing on Hive. I can create an index. create INDEX ix_key ON TABLE DbTest.Tbl_test(TEST_KEY) as ...
    Marc SeegerMarc Seeger
    May 15, 2015 at 10:09 am
    May 15, 2015 at 5:22 pm
  • Hi All: I have installed Hadoop-2.6, Hive 1.1 and try to start hive and get the following, first time when I start the cluster $hive Logging initialized using configuration in ...
    Anand MuraliAnand Murali
    May 15, 2015 at 1:18 pm
    May 15, 2015 at 2:43 pm
  • My environment has HDP 2.2 installed without hive. Hive 1.1 is installed independently of HDP. This is a new setup. I can get a hive cli prompt, but when I run ‘show databases;’ I get ‘FAILED ...
    Grant Overby (groverby)Grant Overby (groverby)
    May 7, 2015 at 3:00 pm
    May 8, 2015 at 1:20 am
  • Hi gurus, I can use Sqoop import to get RDBMS data say Oracle to Hive first and then use incremental append for new rows with PK and last value. However, how do you account for updates and deletes ...
    Ashok KumarAshok Kumar
    May 5, 2015 at 5:42 pm
    May 6, 2015 at 6:31 am
  • Hi, I am new to Hive, please help me understand the benefit of ORC file format storing Sum, Min, Max values.Whenever we try to find a sum of values in a particular column, it still runs the MapReduce ...
    Sreejesh sSreejesh s
    May 29, 2015 at 11:04 pm
    May 30, 2015 at 3:20 am
  • Hi, I queried a table based on value of two float columns select count(*) from u where xlong_u = 7.1578474 and xlat_u = 55.192524; select count(*) from u where xlong_u = cast(7.1578474 as float) and ...
    May 27, 2015 at 1:49 pm
    May 29, 2015 at 10:23 am
  • I use hive1.1.0 beeline remote connect to hiveserver2. When I submit query , only query result return. No log return. Where can I find the execution log? <span class="m_body_email_addr" ...
    May 27, 2015 at 3:28 am
    May 27, 2015 at 5:20 am
  • Hi, I am using HCatalog in HUE to import table from a file, and the table had been created successfully. However, when I browser data, there is no any records in that table. I find there are several ...
    Jiaming LinJiaming Lin
    May 23, 2015 at 5:40 pm
    May 23, 2015 at 9:46 pm
  • Hi, I used a hive insert/select statement to convert our log files into the Parquet format. I found that the size of each Parquet file generated is under 400mb. Is there any way I can increase the ...
    Ey-chih chowEy-chih chow
    May 22, 2015 at 1:42 pm
    May 22, 2015 at 4:43 pm
  • I have what I thought was going to be a very simple math operation in hive. I know there are some packages that will allow this to be calculated but let's go with this for now. the point of the query ...
    Craig JonesCraig Jones
    May 21, 2015 at 1:49 pm
    May 21, 2015 at 4:46 pm
  • Hi , I'm trying to create a subset table from a master table which is stored in ORC format. The query I'm using is : CREATE TABLE tab_20150510 STORED AS ORC AS SELECT * FROM master_tab WHERE ...
    Vivek veeramaniVivek veeramani
    May 21, 2015 at 3:24 am
    May 21, 2015 at 2:38 pm
  • The Apache Hive team is proud to announce the the release of Apache Hive version 1.2.0. The Apache Hive (TM) data warehouse software facilitates querying and managing large datasets residing in ...
    Sushanth SowmyanSushanth Sowmyan
    May 18, 2015 at 9:25 pm
    May 19, 2015 at 7:42 am
  • Hi All, I've created a external table in hive as - create table table1(...) partitioned by(CONTEXT_ID string) row format delimited fields terminated by '\\;' location '/user/sarath/table1/'; Then I ...
    Sarath ChandraSarath Chandra
    May 12, 2015 at 11:33 am
    May 12, 2015 at 11:45 am
  • Hi all, I'm studying CBO code in hive. I have a question about bushy join optimization. Bushy join did get introduced in hive via HIVE-7577 < , and ...
    Ruoxi SunRuoxi Sun
    May 8, 2015 at 6:57 pm
    May 12, 2015 at 2:15 am
  • Status: Running (Executing on YARN cluster with App id application_1419300485749_1493279) -------------------------------------------------------------------------------- VERTICES STATUS TOTAL ...
    May 11, 2015 at 7:05 am
    May 11, 2015 at 8:01 am
  • I’m looking for some sample code to write a hive compatible sequence file for an external table and matching ddl. I’m starting with a java pojo. I can create an Object Inspector for this class. I’m ...
    Grant Overby (groverby)Grant Overby (groverby)
    May 4, 2015 at 6:03 pm
    May 9, 2015 at 9:44 pm
  • I want to turn my single namenode to namenode HA. How to config hive ? <span class="m_body_email_addr" title="7b4f49e505a0ae0d0f8909225c673b11"</span
    May 5, 2015 at 8:04 am
    May 6, 2015 at 2:42 am
  • Dear Hive users I am happy to announce that now you can write and submit your Hive queries using Visual Studio (which is free now!), with syntax coloring, keyword suggestion, remote metastore ...
    Xiaoyong ZhuXiaoyong Zhu
    May 5, 2015 at 6:13 am
    May 5, 2015 at 11:09 pm
  • Hello, According to the instructions < , I'm requesting permissions to edit Hive wiki. My user name there is "sergeant007". P.S. From ...
    Sergey TryuberSergey Tryuber
    May 3, 2015 at 3:49 pm
    May 4, 2015 at 5:26 pm
  • Hi, As recommended at I'd like to request write access to the Hive wiki. My username is 'nickolay'. I've recently started using Hive, ...
    Nickolay PonomarevNickolay Ponomarev
    May 31, 2015 at 8:17 am
    Jun 1, 2015 at 12:35 am
  • Hi, I want to cross check a scenario with you and make sure its not a problem on my end. I am trying do to HCatalog read on an edge node and I am seeing a strange behavior with timestamp data type ...
    May 27, 2015 at 8:20 pm
    May 29, 2015 at 6:20 pm
  • Hi, How to monitor logs for the Hive Tez jobs. In the shell i can see the progress of the Hive job. If i click the application master on RM i get the following error. Thanks, HTTP ERROR 500 Problem ...
    Jagat SinghJagat Singh
    May 25, 2015 at 10:41 pm
    May 26, 2015 at 12:54 am
  • I would like to get write access to the Hive wiki. My Confluence username is gliptak. Thanks
    Gábor LiptákGábor Lipták
    May 23, 2015 at 8:27 pm
    May 23, 2015 at 11:16 pm
  • Hello, Would the order of partition column in the where clause matter for performance? For eg: would there be any difference in performance in the below queries? select a from table where part_column ...
    Reveen joeReveen joe
    May 19, 2015 at 4:57 pm
    May 20, 2015 at 4:23 am
  • I have a hive script , where I call a udf . Script works fine when called from local shell script. But when called from within oozie workflow, it throws an exception saying jar not found. add jar ...
    Shushant AroraShushant Arora
    May 16, 2015 at 3:37 pm
    May 19, 2015 at 12:24 am
  • Hi All, I am getting following error on starting hive 0.14. Need help user@ubuntuvm:~/hive-0.14.0$ hive Logging initialized using configuration in ...
    Rahul ChanneRahul Channe
    May 8, 2015 at 1:49 am
    May 8, 2015 at 2:01 am
  • Hi, Just wanted to raise this one. Sounds like equating two columns of timestamp does not work in Hive. In the following both t.op_time and tmp maxDDLTime columns are defined as timestamp. When I do ...
    Mich TalebzadehMich Talebzadeh
    May 3, 2015 at 9:26 pm
    May 3, 2015 at 11:19 pm
  • -user@hadoop to bcc Kumar, I'm copying your question over to the Apache Hive user list ( Please keep your questions about using Hive there. The Hadoop user list (<span ...
    Sean BusbeySean Busbey
    May 1, 2015 at 2:52 pm
    May 1, 2015 at 3:19 pm
  • Hi, I am trying to authenticate hiveserver2 with kerberos. I am running hive 0.13 and have setup kerberos. My hostname is, so added the principal with below command:- $ kadmin.local ...
    Megha GargMegha Garg
    May 28, 2015 at 7:14 am
    May 28, 2015 at 7:14 am
Group Navigation
period‹ prev | May 2015 | next ›
Group Overview
groupuser @
categorieshive, hadoop

94 users for May 2015

R7raul1984: 16 posts Anupam sinha: 14 posts Bhagwan S. Soni: 11 posts Mich Talebzadeh: 9 posts Grant Overby (groverby): 8 posts Ibrar Ahmed: 7 posts Gopal Vijayaraghavan: 5 posts Hari Subramaniyan: 5 posts Jason Dere: 5 posts Suraj Nayak: 5 posts Moore, Douglas: 4 posts Nitin Pawar: 4 posts Udit Mehta: 4 posts Viral Bajaria: 4 posts Xuefu Zhang: 4 posts Anand Murali: 3 posts Appan Thirumaligai: 3 posts Eugene Koifman: 3 posts Kulkarni Swarnim: 3 posts Liping Zhang: 3 posts
show more