FAQ

Hive > user > November 2013

Search Discussions

66 discussions - 222 posts

  • Good Friday! I was trying to apply certain level of security in our hive data warehouse, by modifying access mode of directories and files on hdfs to 755 I think it's good enough for a new user to ...
    Echo LiEcho Li
    Nov 22, 2013 at 7:36 pm
    Dec 1, 2013 at 6:42 am
  • The Apache Hive PMC has voted to make Jitendra Nath Pandey and Eric Hanson committers on the Apache Hive project. Please join me in congratulating Jitendra and Eric! Thanks. Carl
    Carl SteinbachCarl Steinbach
    Nov 21, 2013 at 11:29 pm
    Nov 23, 2013 at 4:48 am
  • The Apache Hive PMC has voted to make Xuefu Zhang a committer on the Apache Hive project. Please join me in congratulating Xuefu! Thanks. Carl
    Carl SteinbachCarl Steinbach
    Nov 4, 2013 at 4:06 am
    Nov 7, 2013 at 12:14 am
  • I am pleased to announce that Harish Butani has been elected to the Hive Project Management Committee. Please join me in congratulating Harish! Thanks. Carl
    Carl SteinbachCarl Steinbach
    Nov 15, 2013 at 1:18 am
    Nov 16, 2013 at 12:50 am
  • Hi, I have setup WebHCat that is bundled with Hive 0.11.0. I am able to kick of map reduce jobs with the REST API successfully. However I am having some issues with Hive commands over REST. The ...
    Jonathan HodgesJonathan Hodges
    Nov 29, 2013 at 3:29 pm
    Dec 30, 2013 at 6:11 pm
  • The Apache Hive PMC has voted to make Prasad Mujumdar a committer on the Apache Hive Project. Please join me in congratulating Prasad! Thanks. Carl
    Carl SteinbachCarl Steinbach
    Nov 11, 2013 at 2:43 am
    Nov 12, 2013 at 1:10 am
  • Hi, Does Hive 0.12 run on Hadoop 2.2? if it does, anything special about installing it or running hive? Will hive start a M/R ApplicationMaster by itself or should I start one for it? Many thanks ...
    Bill QBill Q
    Nov 14, 2013 at 7:36 am
    Nov 18, 2013 at 12:33 pm
  • A word of warning for users of HiveServer2 - version 0.11 at least. This puppy has the ability crash and/or hang your server with a memory leak. Apparently its not new since googling shows this ...
    Stephen SpragueStephen Sprague
    Nov 18, 2013 at 9:00 pm
    Nov 20, 2013 at 1:26 am
  • Hi, All When I try to compile the latest code of hive using "mvn install" I got these messages. How to pass these unit tests? Did I miss something? I was compiling the code on ubuntu 13.04 And my ...
    金杰金杰
    Nov 5, 2013 at 1:32 pm
    Nov 7, 2013 at 10:58 pm
  • Hi, I have a messy log file which I want to use to create a table, I am only interested to retrieve 3 columns (time,ADD,files),which are in bold. Sample entry from log file *: 13-11-23 06:23:45 [ADD] ...
    BaahuBaahu
    Nov 23, 2013 at 1:37 pm
    Nov 25, 2013 at 5:37 am
  • The Apache Hive PMC has voted to make Lefty Leverenz a committer and PMC member on the Apache Hive Project. Please join me in congratulating Lefty! Thanks. Carl
    Carl SteinbachCarl Steinbach
    Nov 17, 2013 at 5:20 am
    Nov 17, 2013 at 3:55 pm
  • Hello, I am using sqoop to import data from oracle into hive. Below is my SQL: nohup sqoop import --connect "jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxx)(PORT = xxxx)) ...
    Sunita ArvindSunita Arvind
    Nov 11, 2013 at 9:49 pm
    Nov 12, 2013 at 2:54 pm
  • Hi, all, I am trying to build hive from source and start CLI. What I did is (1) git clone the source (2) mvn clean install -DskipTests (3) cp */target/*.jar lib/ ---- this step basically copy all jar ...
    Zhang XiaoyuZhang Xiaoyu
    Nov 6, 2013 at 2:14 am
    Nov 7, 2013 at 1:53 am
  • Hi, I would like update/fix some contents on the performance test part. My user name is xiaom. Thanks, Xiao
    Xiao MengXiao Meng
    Nov 29, 2013 at 11:00 pm
    Dec 12, 2013 at 1:49 am
  • Hello, I am getting this error (appearing after sending *SHOW TABLES;*query). $ hive --service hiveserver2 Starting HiveServer2 Exception in thread "pool-4-thread-1" java.lang.OutOfMemoryError: Java ...
    Rok KraljRok Kralj
    Nov 20, 2013 at 10:24 pm
    Nov 25, 2013 at 12:22 pm
  • Hi All, I have the following skewed table "addresses_1" select id, count(*) c from addresses_1 group by id order by c desc limit 10; 142624653 1554806 198477395 958492 102641838 220181 138947865 ...
    Rajesh BalamohanRajesh Balamohan
    Nov 14, 2013 at 1:06 am
    Nov 14, 2013 at 11:29 am
  • I am looking for guidance (read examples) on tuning ORC settings for my data. I see the documentation that shows the defaults, as well as a brief description of what it is. What I am looking for is ...
    John OmernikJohn Omernik
    Nov 12, 2013 at 11:16 pm
    Nov 14, 2013 at 4:30 am
  • All, I want to create partitions like the below and create a hive external table. How can i do that ? /data1/customer/id<1000 /data1/customer/id 1000 and id < 2000 /data1/customer/id 2000 Is this ...
    Raj HadoopRaj Hadoop
    Nov 3, 2013 at 10:51 pm
    Nov 4, 2013 at 10:43 pm
  • hi all, We are using hive for Ad-hoc querying and have a hive table which is partitioned on two fields (date,id).Now for each date there are around 1400 ids so on a single day around that many ...
    SreenathSreenath
    Nov 25, 2013 at 10:50 am
    Nov 26, 2013 at 10:54 am
  • Hi, I have a table which has 3 columns combined together to form a primary key. If I do Select count(distinct col1,col2,col3) from table_name; And Select count(a.*) from (select ...
    Mayank BansalMayank Bansal
    Nov 21, 2013 at 3:14 pm
    Nov 25, 2013 at 1:46 pm
  • Hi, We often have map-only queries that result in a large number of small output files (in the thousands). Although this doesn't affect CLI, when users try to view/download the query result in Hue, ...
    Eric ChuEric Chu
    Nov 21, 2013 at 5:28 pm
    Nov 21, 2013 at 10:19 pm
  • Hi, we are using gradle as our build tool. I need hive-exec to use class OrcFile. As soon as I pull in hive-exec 0.12.0 as a dependency my build starts to fail with java.lang.NoClassDefFoundError ...
    Kristof VanbecelaereKristof Vanbecelaere
    Nov 21, 2013 at 12:55 pm
    Nov 21, 2013 at 6:25 pm
  • In vertica, if I have a column sorted, and the same value repeat 1M times, it only used very small storage as it only stores (value, 1M). But in ORC, looks like the max length is less than 200 ( not ...
    Qihua wuQihua wu
    Nov 11, 2013 at 2:22 pm
    Nov 11, 2013 at 6:00 pm
  • Hello, I am getting the following exception when I try to run a query. Can any body help me what the problem might be in this scenario. Thanks for you time. 2013-11-07 09:23:38,498 FATAL ExecMapper ...
    Narla,VenkateshNarla,Venkatesh
    Nov 7, 2013 at 3:49 pm
    Nov 11, 2013 at 7:19 am
  • Hi, I am sending this to the three dist-lists of Hadoop, Hive and Sqoop as this question is closely related to all the three areas. I have this requirement. I have a big table in Oracle (about 60 ...
    Raj HadoopRaj Hadoop
    Nov 3, 2013 at 3:40 pm
    Nov 4, 2013 at 4:14 am
  • Hi, I am using Hive 0.12 with Hadoop 2.2 and trying to insert data in a new ORC table with an INSERT SELECT statement from a TEXT file based table and I am running into the following error (I have ...
    Juan Martin PampliegaJuan Martin Pampliega
    Nov 27, 2013 at 1:03 pm
    Dec 10, 2013 at 12:10 am
  • Hive is configured with remote metastore and kerberos ,and it works fine . But now ,I want to config hive authorization ,and I modify hive-site.xml like this: <property <name ...
    David1990111David1990111
    Nov 14, 2013 at 5:54 am
    Nov 14, 2013 at 6:23 am
  • Hello, I'm writing a generic UDAF function that closely resembles SUM() with the main difference being that it accepts an array datatype parameter and returns an array datatype. I've already done ...
    Ross LevinRoss Levin
    Nov 11, 2013 at 7:32 pm
    Nov 12, 2013 at 3:51 am
  • Hi, All I found a line in pom.xml <test.warehouse.scheme pfile://</test.warehouse.scheme You can check it on https://github.com/apache/hive/blob/trunk/pom.xml#L61 ​What is pfile? Is pfile a file ...
    金杰金杰
    Nov 10, 2013 at 11:09 am
    Nov 11, 2013 at 10:53 pm
  • Is there any way to stop hive metastore without killing PID. Thanks & Regards, Rinku Garg The information contained in this message is proprietary and/or confidential. If you are not the intended ...
    Garg, RinkuGarg, Rinku
    Nov 6, 2013 at 11:43 am
    Nov 6, 2013 at 7:22 pm
  • Hi, I ran "mvn clean install -DskipTests; cd itests; mvn clean install -DskipTests" and got the following error. Error ======= [ERROR] Failed to execute goal ...
    Mohammad IslamMohammad Islam
    Nov 3, 2013 at 3:49 am
    Nov 4, 2013 at 7:08 am
  • hi, We are building ms sql cube by linkedserver connecting to hiveserver with Cloudera's ODBC driver. There are two test results: 1. hiveserver1 running on 2CPUs, 8G mem, took about 8 hours 2 ...
    B CB C
    Nov 6, 2013 at 2:17 am
    Jan 19, 2014 at 6:44 am
  • Hello everyone, I have two questions on join optimizations in Hive, one of which I believe is a bug in the 0.11.0 release. 1. From Hive online documentation I see that multiple map joins can be ...
    Adrian PopescuAdrian Popescu
    Nov 15, 2013 at 9:21 pm
    Dec 13, 2013 at 7:17 pm
  • Hi all, We've been running into this problem a lot recently on a particular reduce task. I'm aware that I can work around it by uping the "mapred.task.timeout". However, I would like to know what the ...
    Krishna RaoKrishna Rao
    Nov 29, 2013 at 12:12 pm
    Nov 29, 2013 at 8:55 pm
  • hi,maillist: i add some new columns to hive table ,but find when i use beeline, or write my own java code,i can not get these new columns value,but when i use hive shell,it's ok 0 ...
    Ch huangCh huang
    Nov 28, 2013 at 2:09 am
    Nov 28, 2013 at 2:34 am
  • Hello, I'd like to run a few TPC-H queries on Hive 0.12. I've found the TPC-H scripts here: https://issues.apache.org/jira/browse/HIVE-600. but noticed that these scripts were generated a long time ...
    Avrilia FloratouAvrilia Floratou
    Nov 22, 2013 at 6:31 pm
    Nov 22, 2013 at 7:44 pm
  • what is the error ? -- Nitin Pawar
    Nitin PawarNitin Pawar
    Nov 15, 2013 at 11:00 am
    Nov 15, 2013 at 11:30 am
  • When trying to create table in Hive I am always getting the following error always. Not able to do any hive DDL operations, FAILED: Error in metadata ...
    Valluri, SathishValluri, Sathish
    Nov 15, 2013 at 9:42 am
    Nov 15, 2013 at 10:47 am
  • Hi, I have a web log files (text format). I want to load these files to a Hive table in compressed format. How do I do it ? Should I compress the text file (using any Linux utilities) and then create ...
    Raj HadoopRaj Hadoop
    Nov 12, 2013 at 1:10 am
    Nov 12, 2013 at 4:26 am
  • Hi all, I am using Hadoop cdh3u6 and apache hive 0.10. I run the summary sql as follow : SELECT pt, count(1), sum(flow_byte), count(distinct t.user_id), count(distinct t.phone_no), max(t.user_ip), ...
    AswordAsword
    Nov 6, 2013 at 9:44 am
    Nov 12, 2013 at 3:31 am
  • Hello, Quick question about Hive and Avro. Can I create an Avro scheme that uses aliases? I have tried a couple different ways, but so far I have not been able to get a hive query to return data for ...
    Matthew LangtonMatthew Langton
    Nov 8, 2013 at 7:51 am
    Nov 8, 2013 at 9:09 pm
  • Hi all, I'm using hive-12. I have a file that contains 10 integer columns stored in ORC format. The ORC file is zlib compressed and indexing is enabled. I'm running a simple select count(*) with a ...
    Avrilia FloratouAvrilia Floratou
    Nov 8, 2013 at 12:05 am
    Nov 8, 2013 at 2:00 am
  • Hello. I have a set of complex structured objects that I would like to put into hive and use it's sql to query data from those objects. Now, since they are complex structures, defining a schema for ...
    Miljan MarkovicMiljan Markovic
    Nov 7, 2013 at 11:42 am
    Nov 7, 2013 at 1:00 pm
  • Time taken: 0.272 seconds hive (default) drop table demo3; OK Time taken: 60.524 seconds hive (default) create table demo3 like demo; OK Time taken: 0.273 seconds
    Ch huangCh huang
    Nov 28, 2013 at 2:06 am
    Nov 28, 2013 at 2:06 am
  • Hi, I have development cluster installed with Hive 0.12 running on top of Hadoop 2.2.0. I have set the following properties values in the .hiverc file and when running queries in the hive command ...
    Juan Martin PampliegaJuan Martin Pampliega
    Nov 26, 2013 at 6:58 pm
    Nov 26, 2013 at 6:58 pm
  • Hi, I want to customize the hive-site.xml to add some extra properties to be used for a UDF. The UDF is a part of the view to be created. So , i tried setting the path through hivecli as below: set ...
    Swagatika TripathySwagatika Tripathy
    Nov 24, 2013 at 6:22 am
    Nov 24, 2013 at 6:22 am
  • Hi, all, I'm running Hive-0.9.0-cdh4.1.2 on a cluster consisting of 3 nodes, I was wondering if I would like to run multiple queries simultaneously? BTW, I have set "hive.exec.parallel" to true in ...
    Lin YangLin Yang
    Nov 20, 2013 at 11:34 am
    Nov 20, 2013 at 11:34 am
  • Hi, I am writing a MR job to generate data for Hive. the code generates output with Text format pretty OK job.setOutputKeyClass(NullWritable.class); job.setOutputValueClass(Text.class); But when I ...
    Zhang XiaoyuZhang Xiaoyu
    Nov 20, 2013 at 2:12 am
    Nov 20, 2013 at 2:12 am
  • There are some discussions on this https://issues.apache.org/jira/browse/HIVE-3822 However, one person is stating there is not an issue with timestamp, thus I am asking this question: is this a bug ...
    John OmernikJohn Omernik
    Nov 19, 2013 at 6:15 pm
    Nov 19, 2013 at 6:15 pm
  • It imports the classes under package of org.apache.hadoop.mapred instead of org.apache.hadoop.mapreduce, which means it used old API. How can I run it using new mapreduce API?
    Qihua wuQihua wu
    Nov 18, 2013 at 6:01 am
    Nov 18, 2013 at 6:01 am
Nov 2013
12
Group Navigation
period‹ prev | Nov 2013 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions66
posts222
users89
websitehive.apache.org

89 users for November 2013

Thejas Nair: 9 posts 金杰: 9 posts Prasanth J (Official): 8 posts Zhang Xiaoyu: 8 posts Nitin Pawar: 7 posts Raj Hadoop: 7 posts Vaibhav Gumashta: 7 posts David Morel: 6 posts Jarek Jarcec Cecho: 6 posts John Omernik: 6 posts Gunther Hagleitner: 5 posts Sunita Arvind: 5 posts Bill Q: 4 posts Carl Steinbach: 4 posts Edward Capriolo: 4 posts Lefty Leverenz: 4 posts Mohammad Islam: 4 posts Biswajit Nayak: 3 posts Ch huang: 3 posts David1990111: 3 posts
show more
Archives