Grokbase Groups Hive user August 2013
FAQ

Search Discussions

96 discussions - 364 posts

  • The Apache Hive PMC has voted to make Thejas Nair a committer on the Apache Hive project. Please join me in congratulating Thejas!
    Carl SteinbachCarl Steinbach
    Aug 20, 2013 at 10:32 am
    Aug 20, 2013 at 8:54 pm
  • Hello, I am started to run Hive with Lzo compression on Hortonworks 1.2 I have managed to install/configure Lzo and hive -e "set io.compression.codecs" shows me the Lzo Codecs: io.compression.codecs= ...
    W00t w00tW00t w00t
    Aug 8, 2013 at 9:03 am
    Aug 19, 2013 at 8:27 am
  • Hi Friends, We have configured mysql as a metastore for hive, its just throwing following error, FAILED: Error in metadata: MetaException(message:Got exception: javax.jdo.JDODataStoreException ...
    Shashwat shriparvShashwat shriparv
    Aug 3, 2013 at 11:59 am
    Aug 8, 2013 at 4:03 am
  • Hi everybody, I am coding some HiveQL script to do some calculations. I have a problem with the min() function. My hive script is below : INSERT INTO TABLE default.THM_CA_RGRP_PRODUITS_SEM SELECT ...
    Jérôme VerdierJérôme Verdier
    Aug 29, 2013 at 10:02 am
    Aug 30, 2013 at 6:50 pm
  • Hi all: I'm currently testing hive11 and encounter one bug with hive.auto.convert.join, I construct a testcase so everyone can reproduce it(or you can reach the testcase ...
    Wzc1989Wzc1989
    Aug 8, 2013 at 7:32 pm
    Sep 25, 2013 at 9:23 pm
  • Thanks a lot Mikhail for getting back. That means I cannot use this using beeline unless I change the code and build hive again ? Thanks sanjay From: Mikhail Antonov <<span class="m_body_email_addr" ...
    Sanjay SubramanianSanjay Subramanian
    Aug 24, 2013 at 1:25 am
    Aug 24, 2013 at 3:24 pm
  • Hello All, Sorry for not replying to the thread, but I never received any of your responses.. Hopefully this info will help: @kulkarni.swarnim Here is the error I'm getting on task tracker for the ...
    Jim ColestockJim Colestock
    Aug 22, 2013 at 12:17 pm
    Aug 23, 2013 at 5:45 pm
  • I noticed that NPath appears to be included in Hive-0.11 but I can't find any documents explaining how to use it. Has anyone successfully used the NPath module and would be willing to share the ...
    Justin WorkmanJustin Workman
    Aug 16, 2013 at 6:40 pm
    Aug 19, 2013 at 7:31 pm
  • hi all when i use hive hive job make only one mapper actually my file split 18 block my block size is 128MB and data size 2GB i use lzo compression and create file.lzo and make index file.lzo.index i ...
    闫昆闫昆
    Aug 21, 2013 at 9:17 am
    Aug 22, 2013 at 3:42 am
  • Hi, Currently, we use TEXTFILE format in hive 0.8 ,while creating the external tables in intermediate processing . I have read about ORC in 0.11. I have created the same table in 0.11 with ORC ...
    Pandees waranPandees waran
    Aug 12, 2013 at 10:40 am
    Aug 13, 2013 at 3:54 am
  • I have a table that currently uses RC files and has two levels of partitions. day and source. The table is first partitioned by day, then within each day there are 6-15 source partitions. This makes ...
    John OmernikJohn Omernik
    Aug 10, 2013 at 3:57 pm
    Aug 10, 2013 at 6:33 pm
  • Hi, We are using DISTRIBUTE BY with custom reducer scripts in our query workload. After upgrade to Hive 0.11, queries with GROUP BY/DISTRIBUTE BY/SORT BY and custom reducer scripts produced incorrect ...
    Pala M MuthaiaPala M Muthaia
    Aug 24, 2013 at 12:36 am
    Aug 26, 2013 at 7:03 pm
  • When is it expect to support lead/lag/first_value/last_value in the npath result statement? Thanks Sent from my iPhone
    Justin WorkmanJustin Workman
    Aug 21, 2013 at 5:44 am
    Aug 22, 2013 at 1:27 am
  • Views should theoretically not incur performance penalties: they simply represent queries. Are there situtions that things are "not that simple" - i.e. views may actually result in different ...
    Stephen BoeschStephen Boesch
    Aug 20, 2013 at 11:16 pm
    Aug 21, 2013 at 2:56 am
  • Hi again, CREATE TABLE test (a INT); EXPLAIN SELECT DENSE_RANK() OVER (PARTITION BY a), a FROM test; this minimal example fails with: FAILED: SemanticException Failed to breakup Windowing invocations ...
    Lars FranckeLars Francke
    Aug 9, 2013 at 1:41 pm
    Aug 20, 2013 at 2:27 am
  • Hi folks, FAILED: Error in metadata: MetaException(message:file:/user/hive/warehouse/src is not a directory or unable to create one) drwxrwxrwx - hadoop supergroup 0 2013-08-16 18:31 ...
    Ankit BhatnagarAnkit Bhatnagar
    Aug 16, 2013 at 7:04 pm
    Aug 17, 2013 at 1:08 am
  • Hi, I am facing the same issue as mentioned in the below JIRA: https://issues.apache.org/jira/browse/HIVE-3872 I am using amazon EMR with hive 0.11. Do i need to apply any patch on top of 0.11 to fix ...
    Pandees waranPandees waran
    Aug 7, 2013 at 1:09 pm
    Aug 11, 2013 at 5:42 am
  • It appears a bit challenging to find the BNF's for the hive DDL's. After a few google's the following popped up for cdh3 and only for a subset of table creation's ...
    Stephen BoeschStephen Boesch
    Aug 25, 2013 at 8:38 pm
    Aug 26, 2013 at 4:30 am
  • What's the best way to enforce a single output file per partition? INSERT OVERWRITE TABLE <table PARTITION (x,y,z) SELECT ... FROM ... WHERE ... It tried adding CLUSTER BY x,y,z at the end thinking ...
    Igor TatarinovIgor Tatarinov
    Aug 20, 2013 at 9:30 pm
    Aug 21, 2013 at 8:20 pm
  • Hi, I was facing a weird issue with hive today. I ran the following 2 queries query1: select co.city from company1 co inner join customer1 cu on (co.city=cu.city); query2: select distinct co.city ...
    Chandraprakash BhagtaniChandraprakash Bhagtani
    Aug 1, 2013 at 9:42 am
    Aug 13, 2013 at 7:54 am
  • I have three tables: Table 1: record when and who visited gas station or not, this contains all the users of interest, name all the users as a set A date | user name | visited gas station? 2013-09-01 ...
    QiaoresearcherQiaoresearcher
    Aug 30, 2013 at 11:34 pm
    Sep 3, 2013 at 6:06 pm
  • Hi All: Put some debugging code in TUGIContainingTransport.getTransport() and I tracked it down to @Override public TUGIContainingTransport getTransport(TTransport trans) { // UGI information is not ...
    AgateaaaAgateaaa
    Aug 29, 2013 at 5:58 pm
    Aug 29, 2013 at 9:40 pm
  • I love how you can "apt-get install hadoop-hive" in Ubuntu, and "brew install hive" in Mac. Could we submit a Chocolatey <http://chocolatey.org/ package for Windows, so that they can easily install ...
    Andrew PennebakerAndrew Pennebaker
    Aug 26, 2013 at 6:22 pm
    Aug 27, 2013 at 12:18 pm
  • Hi everyone, I have a CDH4 cluster running In 4 nodes. I can perform queries in Beeswax UI but If I try to perform the same query with the hive console it is not possible. I launched the console in ...
    Guillermo AlvaradoGuillermo Alvarado
    Aug 22, 2013 at 6:55 pm
    Aug 27, 2013 at 4:12 am
  • Thanks Ashutosh From: Ashutosh Chauhan <<span class="m_body_email_addr" title="ec0e9b42f0b7cae09d28ed33bc88bdbb" hashutosh@apache.org</span Reply-To: "<span class="m_body_email_addr" ...
    Sanjay SubramanianSanjay Subramanian
    Aug 20, 2013 at 11:00 pm
    Aug 21, 2013 at 10:11 pm
  • HI, I see the SUM(double_column) displays the result in scientific notation in the hive cli. Is there any way to customize the number display in hive CLI? -- Thanks, Pandeeswaran Hi, I am seeing the ...
    Pandees waranPandees waran
    Aug 13, 2013 at 6:31 am
    Aug 13, 2013 at 7:48 pm
  • Hi, If i run a hive query like "select * from table_name limit 10" it is working.If i run query like "select column_name from table_name limit 10" it hangs. Total MapReduce jobs = 1Launching Job 1 ...
    Manickam PManickam P
    Aug 6, 2013 at 9:53 am
    Aug 7, 2013 at 7:31 pm
  • Hi All- I was hoping to gather some insight in how the hadoop (and or hive) job scheduler distributes mappers per user. I am running into an issue where I see that hadoop (and or hive) is evenly ...
    Brad RudermanBrad Ruderman
    Aug 30, 2013 at 4:38 pm
    Aug 30, 2013 at 6:02 pm
  • Hi all , Can we perform arithmetic operator on *select* command. I have a table emp_table with columns emp_name and emp_no i want to multiply the data in a emp_no with 10 . i tryed select * from ...
    Sandeep NemuriSandeep Nemuri
    Aug 22, 2013 at 2:14 pm
    Aug 23, 2013 at 6:03 am
  • Once again, I am down on my knees humbling calling upon the Hive Jedi Masters to please provide this paadwaan with cwiki update privileges May the Force be with u Thanks sanjay From: Sanjay ...
    Sanjay SubramanianSanjay Subramanian
    Aug 14, 2013 at 10:53 pm
    Aug 21, 2013 at 3:55 pm
  • Hi everyone, Consider following DDL: CREATE TABLE partition_test (a INT) PARTITIONED BY (b INT); ALTER TABLE partition_test ADD PARTITION (b=1) location '/tmp/test1' PARTITION (b=2) location ...
    Jan DolinárJan Dolinár
    Aug 15, 2013 at 5:51 am
    Aug 20, 2013 at 11:27 pm
  • Hi everybody, I faced a strange error in Hive today. I have launch a hive script to make some calculations, joins, union, etc... and then insert these results in over hive table. Everything is ...
    Jérôme VerdierJérôme Verdier
    Aug 14, 2013 at 12:35 pm
    Aug 19, 2013 at 7:19 am
  • Hello, I am running Hortonworks 1.2 using Hadoop 1.1.2.21 and Hive 0.10.0.21. I set up LZO compression and can read LZO compressed data without problems. My next try was to test output compression ...
    W00t w00tW00t w00t
    Aug 13, 2013 at 9:27 am
    Aug 14, 2013 at 2:33 am
  • Hi, The hive thrift service is not running continously. I had to execute the command (hive --service hiveserver &) very frequently . Can any one help me on this? Thanks, Raj
    Raj HadoopRaj Hadoop
    Aug 5, 2013 at 4:29 pm
    Aug 6, 2013 at 6:47 pm
  • Suppose we have 2 simple tables A id int value string B id When hive translates the following query select max(A.value), A.id from A join B on A.id = A.id group by A.id; It launches 2 stages, one for ...
    Chen SongChen Song
    Aug 1, 2013 at 5:20 pm
    Aug 2, 2013 at 5:33 pm
  • I'm facing issues while building an index on multiple columns in a Hive(0.9.0) table. describe nas_comps; OK leg_id int ds_name string dep_date string crr_code string flight_no string orgn string ...
    Omkar JoshiOmkar Joshi
    Aug 1, 2013 at 5:42 am
    Aug 2, 2013 at 3:03 pm
  • In PIG I am doing query like this: sdp1 = load 'db1.table1' using org.apache.hcatalog.pig.HCatLoader; sdp = FILTER sdp1 BY key1=='value1' AND key2=='value2'; ll = LIMIT sdp 100; dump ll; and hcatalog ...
    Michał CzerwińskiMichał Czerwiński
    Aug 27, 2013 at 5:42 pm
    Aug 28, 2013 at 6:43 pm
  • Adding user list. Any objections to removing LIKE support from getPartitionsByFilter? -- CONFIDENTIALITY NOTICE NOTICE: This message is intended for the use of the individual or entity to which it is ...
    Sergey ShelukhinSergey Shelukhin
    Aug 27, 2013 at 2:49 am
    Aug 27, 2013 at 5:36 pm
  • hi all when exec hive query throw exception as follow I donnot know where is error log I found $HIVE_HOME/ logs not exist Total MapReduce jobs = 1 Launching Job 1 out of 1 Number of reduce tasks not ...
    闫昆闫昆
    Aug 22, 2013 at 2:15 am
    Aug 22, 2013 at 4:48 am
  • Hi - I just started to get my feet wet with Hive and have a question that I have not been able to find an answer to.. Suppose I have 2 CSV files: Name, Address, Phone Chris, address1, 999-999-9999 ...
    Chris DriscolChris Driscol
    Aug 21, 2013 at 2:25 pm
    Aug 21, 2013 at 7:02 pm
  • Hi, Is hive 0.11 faster on YARN? What am I missing out if I am using hive 0.11 on MRv1 ? Thanks a lot :) - Austin
    Austin ChungathAustin Chungath
    Aug 20, 2013 at 9:33 am
    Aug 20, 2013 at 5:11 pm
  • hi,all: i have a problem ,i have a hive table ,it source data based on HDFS,and i want to get part query result for processing(the whole data is huge,so must load partly),any good suggestions? (hive ...
    Ch huangCh huang
    Aug 19, 2013 at 3:17 am
    Aug 19, 2013 at 11:29 pm
  • the limit cause has no offset option,how to page result query by hive?
    Ch huangCh huang
    Aug 19, 2013 at 2:47 am
    Aug 19, 2013 at 4:45 am
  • Hi everybody, I want to build an application with Hadoop. I want to know which is the best way to comunicate my GUI (Django based) with Hive. I have a CDH4 cluster running, I need to perform queries ...
    Guillermo AlvaradoGuillermo Alvarado
    Aug 14, 2013 at 10:45 pm
    Aug 16, 2013 at 12:00 am
  • I am sorry if I am missing something very basic with hive authorization on 0.9 or before. I went through the existing security in hive, before hiveserver2 (i.e. hove 0.9 or before) and I see all the ...
    Rob PaulRob Paul
    Aug 13, 2013 at 12:31 am
    Aug 15, 2013 at 1:03 am
  • 1) Did you miss the first word? ("NULL if A or B is NULL") 2) Darren Yin posted a similar message to the user ...
    Lefty LeverenzLefty Leverenz
    Aug 10, 2013 at 12:02 am
    Aug 11, 2013 at 8:22 pm
  • Hi, Before the advent of windowing and analytical functions in 0.11, we depend on UDAF for achieving the desired analytical functionality in 0.8, So, I would like to replace the UDAF with the ...
    Pandees waranPandees waran
    Aug 11, 2013 at 11:23 am
    Aug 11, 2013 at 12:46 pm
  • Hive version: 0.10.0-cdh4.2.1 Trying to insert into a bucketized table from the same table, throws exception: "FAILED: SemanticException [Error 10122]: Bucketized tables do not support INSERT INTO ...
    Neha SoodNeha Sood
    Aug 29, 2013 at 9:03 am
    Aug 29, 2013 at 9:46 am
  • I created an external table and have been inserting data into it for some time. I would now like to add a partitions to the table, is this possible? thanks,George
    Babe RuthBabe Ruth
    Aug 27, 2013 at 7:12 pm
    Aug 27, 2013 at 7:57 pm
  • Hi, What are the key areas we need to check in the explain plan generated in Hive? I have checked the documentation, it's not detailed about the above question ...
    Pandees waranPandees waran
    Aug 23, 2013 at 5:29 am
    Aug 23, 2013 at 3:10 pm
Group Navigation
period‹ prev | Aug 2013 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions96
posts364
users117
websitehive.apache.org

117 users for August 2013

Sanjay Subramanian: 40 posts Nitin Pawar: 24 posts Stephen Sprague: 22 posts Pandees waran: 18 posts Edward Capriolo: 14 posts Justin Workman: 14 posts Lefty Leverenz: 9 posts Jérôme Verdier: 8 posts Navis류승우: 8 posts Stephen Boesch: 8 posts 闫昆: 7 posts Guillermo Alvarado: 6 posts Mikhail Antonov: 6 posts W00t w00t: 6 posts Ch huang: 5 posts Jim Colestock: 5 posts John Omernik: 5 posts Wzc1989: 4 posts Agateaaa: 4 posts Igor Tatarinov: 4 posts
show more
Archives