Grokbase Groups Hive user May 2013
FAQ

Search Discussions

77 discussions - 319 posts

  • Hi, I was not able to stopThrift Server after performing the following steps. $ bin/hive --service hiveserver & Starting Hive Thrift Server $ netstat -nl | grep 10000 tcp 0 0 :::10000 :::* LISTEN I ...
    Raj HadoopRaj Hadoop
    May 20, 2013 at 9:03 pm
    Jun 18, 2013 at 11:12 pm
  • Hi, I'm using Hive 0.10.0 and Hadoop 1.0.4. I would like to create a normal table but have some of my code run so that I can remove filtering parts of the query and limit the output in the splits of ...
    Peter MarronPeter Marron
    May 15, 2013 at 10:39 am
    Jun 11, 2013 at 5:10 pm
  • Hi, I am configurinig Hive. I ahve a question on the property hive.metastore.warehouse.dir. Should this point to a physical directory. I am guessing it is a logical directory under Hadoop ...
    Raj HadoopRaj Hadoop
    May 21, 2013 at 5:09 pm
    May 21, 2013 at 6:35 pm
  • Hi, I am looking for suggestions from the hadoop and hive user community on the following - 1) How good is the choice of choosing Oracle for Hive Metastore ? In my organization, we only use Oracle ...
    Raj HadoopRaj Hadoop
    May 17, 2013 at 12:06 am
    May 18, 2013 at 4:54 pm
  • Hi, I am currently running hadoop 1.0.4 and hive 0.10.0 also I have HADOOP_HOME set to /home/hadoop and HIVE_HOME to /home/hive along with JAVA_HOME also to the right location. and I would like to ...
    Cyril BogusCyril Bogus
    May 2, 2013 at 5:19 pm
    May 2, 2013 at 8:13 pm
  • I'm looking for documentation on how to use .sql and .hql files in Hive and what the differences are between the two file types. I'm not even certain .hql is a real thing, but I'm looking. I didn't ...
    Keith WileyKeith Wiley
    May 31, 2013 at 8:18 pm
    Jun 2, 2013 at 9:00 am
  • Hi, Hive 0.10.0 over Hadoop 1.0.4. Further to my filtering questions of before. I would like to be able to access the table properties from inside my custom InputFormat. I've done searches and there ...
    Peter MarronPeter Marron
    May 28, 2013 at 3:00 pm
    May 29, 2013 at 9:17 am
  • I am trying to get Oracle scripts for Hive Metastore. http://mail-archives.apache.org/mod_mbox/hive-commits/201204.mbox/%3C20120423201303.9742B2388860@eris.apache.org%3E The scripts in the above link ...
    Raj HadoopRaj Hadoop
    May 21, 2013 at 7:08 pm
    May 23, 2013 at 4:49 pm
  • I have installed Hive locally & I am able to run Hive queries etc. Now I would like to try out Hive Web Interface, but when I try to start the webserver I run into this: ./hive --service hwi 13/05/15 ...
    Something SomethingSomething Something
    May 16, 2013 at 5:25 am
    May 16, 2013 at 5:21 pm
  • Hey, I'm beginner in the hadoop world, and more specifically in Hive (I work on hive-0.9.0 on Ubuntu). I work on MapR M3 in standalone mode. I'm training on hive and have some issues with one ...
    Gautier vivardGautier vivard
    May 13, 2013 at 7:41 am
    May 14, 2013 at 4:41 am
  • Hi, I'm trying to run some queries on compressed tables in Hive 0.10. I wish to know what all compression codecs are available which i can make use of. However, when i run set io.compression.codecs ...
    Sachin SudarshanaSachin Sudarshana
    May 23, 2013 at 10:33 am
    May 23, 2013 at 4:52 pm
  • Hi, I am trying to write a hive query to find the equivalent of NOT IN / NOT EXIST in SQL. However, Hive does not support this. It does have Left Semi Join which serves as IN but NOT does not ...
    Peter ChuPeter Chu
    May 6, 2013 at 3:21 am
    May 6, 2013 at 5:57 pm
  • In Hive, I cannot perform a SELECT GROUP BY on fields not in the GROUP BY clause. Example: SELECT st.a, st.b, st.c, st.d, FROM some_table st GROUP BY st.a; -- This does not work. To make it work, I ...
    Peter ChuPeter Chu
    May 6, 2013 at 6:07 pm
    May 6, 2013 at 6:34 pm
  • I wrote a few reporting scripts in Perl that connected to Hive via the Thrift interface. Since we upgraded CDH to 4.2.0 and hiveserver2 was installed (with Hive 0.10.0) the scripts no longer ran due ...
    Dave CardwellDave Cardwell
    May 14, 2013 at 10:36 am
    Jul 1, 2013 at 9:52 am
  • Hi, My hive job logs are being written to /tmp/hadoop directory. I want to change it to a different location i.e. a sub directory somehere under the 'hadoop' user home directory. How do I change it ...
    Raj HadoopRaj Hadoop
    May 22, 2013 at 6:54 pm
    May 23, 2013 at 9:56 pm
  • Hi, I am planning to install Hive and want to set up Meta store on Oracle. What is the procedure? Which driver (JDBC) do I need to use it? Thanks, Raj
    Raj HadoopRaj Hadoop
    May 18, 2013 at 12:11 am
    May 18, 2013 at 3:17 pm
  • We were doing some tests this past week with hive authorization, one of our current use "challenges" is when we have an underlying, well managed and partitioned table, and we want to allow access to ...
    John OmernikJohn Omernik
    May 4, 2013 at 1:32 pm
    May 16, 2013 at 9:50 pm
  • Hi I want to disable Hive CLI interactive mode for Hive clients in production accessing Hive. Mainly due to the following error…This error is solved in future 0.10.0+ versions perhaps but ...
    Sanjay SubramanianSanjay Subramanian
    May 15, 2013 at 9:33 pm
    May 16, 2013 at 1:20 am
  • Hi guys, I'm currently writing my on HiveOutputFormat as I would like to write the output of hive queries into a specific protobuf format my team is using. I have managed to do this however, the ...
    Rui MartinsRui Martins
    May 13, 2013 at 1:17 pm
    May 13, 2013 at 5:47 pm
  • Hi All, We have an application which parses hive cli output and displays results. I have an external table with data in avro format, the contents in this avro file have TAB and NEW LINES in the Avro ...
    Valluri, SathishValluri, Sathish
    May 3, 2013 at 9:08 am
    May 6, 2013 at 8:21 pm
  • Hi all, This is my first post to the hive mailing list and I was hoping to get some help with the exception I am getting below. I am using CDH4.2 (hive 0.10.0) to query snappy compressed, Sequence ...
    Keith WrightKeith Wright
    May 28, 2013 at 1:03 pm
    Jul 15, 2013 at 11:24 pm
  • Hi, We are working on hive DB with our Hadoop cluster. We now facing an issue about joining a big partition with more than 2^31 rows. When the partition has more than 2147483648 rows (even ...
    Gabi KazavGabi Kazav
    May 29, 2013 at 6:42 pm
    May 30, 2013 at 9:43 am
  • I have a cloudera cluster, version 4.2.0. In the hive configuration, I have "MapReduce Service" set to "mapreduce1", which is my MR service. However, without setting "mapred.job.tracker", whenever I ...
    Frank LuoFrank Luo
    May 28, 2013 at 4:50 pm
    May 28, 2013 at 8:30 pm
  • Hi, I got some little problem with the content of hive tables. These table's contents are generated by pig and do so have no header line, they are accessed as "TextFile" with an external hive table ...
    Tim BittersohlTim Bittersohl
    May 22, 2013 at 4:58 pm
    May 23, 2013 at 12:02 pm
  • I just realized that this has existed in Hive for a couple years now, but the only reference to it that exists on this page in the wiki ...
    Darren YinDarren Yin
    May 14, 2013 at 4:20 am
    May 15, 2013 at 8:42 pm
  • Hi all, This seems silly but I couldn't get any reliable information even after a few minutes of googling. If I am creating user roles and groups in hive, which user should I be doing it with? Is ...
    Austin ChungathAustin Chungath
    May 10, 2013 at 8:20 am
    May 13, 2013 at 2:49 pm
  • Just wondering what information does Hive store in metastore and warehouse directory . I configured my metastore to mysql. I also in the warehouse directory of hive (on HDFS) directories with names ...
    Nagarjuna kanamarlapudiNagarjuna kanamarlapudi
    May 8, 2013 at 9:27 am
    May 8, 2013 at 7:59 pm
  • Hi, I'm trying to use package RJDBC to connect to hive through R. My client machine, on which R is installed, is Windows 7. I installed the package, then copied the file hive-jdbc-0.9.0-cdh4.1.2.jar ...
    Saurabh SSaurabh S
    May 7, 2013 at 6:55 pm
    May 8, 2013 at 5:41 pm
  • Hi All, I need to load a month worth of processed data into a hive table. Table have 10 partitions. Each day have many files to load and each file is taking two seconds(constantly) and i have ~3000 ...
    SelvaSelva
    May 3, 2013 at 7:05 am
    May 3, 2013 at 8:43 am
  • Hi, When I run analyze table command and run describe extended command, it shows the number of rows as 0. Query: DESCRIBE EXTENDED lineitem1; Result: .......parameters:{numPartitions=0, numFiles=4, ...
    Aishwarya GanesanAishwarya Ganesan
    May 2, 2013 at 2:25 pm
    May 3, 2013 at 6:50 am
  • Hi there, I am trying the following: select case when ta_end_datetime_berekenen = 'Y' then lead(ta_update_datetime) over ( partition by dn_waarde_van, dn_waarde_tot order by ta_update_datetime ) else ...
    Frans DrijverFrans Drijver
    May 27, 2013 at 3:43 pm
    Sep 23, 2013 at 12:29 pm
  • Hi all, I am wondering how to change the fields separator of INSERT OVERWRITE LOCAL DIRECTORY , does anyone have experience doing this ? thanks!
    Felix.徐Felix.徐
    May 29, 2013 at 8:38 am
    Jun 19, 2013 at 3:22 pm
  • Hello, I was wondering about the "update" statement on Hive. Is it something Hive needs? Or can "insert overwrite" be always used instead? Thank you in advance for the clarification, Renata.
    Renata Ghisloti Duarte de SouzaRenata Ghisloti Duarte de Souza
    May 31, 2013 at 7:28 pm
    Jun 10, 2013 at 7:39 pm
  • Hi all, I have this scenario to remove certain rows from a hive table. As far as I understand, hive doesn't provide that functionality. So, I'm trying to select inverse of what I want to delete and ...
    Bhathiya JayasekaraBhathiya Jayasekara
    May 29, 2013 at 9:17 am
    May 30, 2013 at 1:43 am
  • Hi, I am trying to run the following to load an Oracle table to Hive table using Sqoop, sqoop import --connect jdbc:oracle:thin:@//inferri.dm.com:1521/DBRM25 --table DS12.CREDITS --username UPX1 ...
    Raj HadoopRaj Hadoop
    May 25, 2013 at 9:55 pm
    May 26, 2013 at 2:54 pm
  • Hi, Has anyone explore on thrift java client for HiveServer2? I have a java client in place which connects to HiveServer2 and gets table details. What I am yet to figure out is how to read the actual ...
    GhousiaGhousia
    May 24, 2013 at 10:15 am
    May 25, 2013 at 1:57 pm
  • Hi, I just installed Apache Flume 1.3.1 and trying to run a small example to test. Can any one suggest me how can I do this? I am going through the documentation right now. Thanks, Raj
    Raj HadoopRaj Hadoop
    May 24, 2013 at 9:14 pm
    May 24, 2013 at 11:20 pm
  • Hello, everyone I configured the "hive.exec.parallel" variable to be "true" in the hive-site.xml and hive-default.xml. However, each job inside a query still runs sequentially one by one (though they ...
    Zhuo LiuZhuo Liu
    May 20, 2013 at 2:24 am
    May 22, 2013 at 9:31 pm
  • Hi all, We had created views in hive, but when we restart the cluster then the views created in the hive are deleted automatically. I know hive view doesn't persist after cluster restart, but I want ...
    AbhishekAbhishek
    May 16, 2013 at 10:45 pm
    May 21, 2013 at 3:07 pm
  • Hi Guys, We've been facing problems using Hive on the cluster. Please find attached the snapshot of the error that we encountered. * The Hive error we are facing- Error in metadata: MetaException ...
    Kasa V VarunKasa V Varun
    May 20, 2013 at 6:17 am
    May 21, 2013 at 12:21 pm
  • Hi, I wanted to know whether any one used Hive on Oracle Metastore? Can you please share your experiences? Thanks, Raj
    Raj HadoopRaj Hadoop
    May 18, 2013 at 8:05 pm
    May 18, 2013 at 8:32 pm
  • The Apache Hive team is proud to announce the the release of Apache Hive version 0.11.0. The Apache Hive data warehouse software facilitates querying and managing large datasets residing in ...
    Owen O'MalleyOwen O'Malley
    May 16, 2013 at 9:19 pm
    May 17, 2013 at 4:41 pm
  • Hi all, Can someone please give an idea for this? I'm totally stuck. http://stackoverflow.com/questions/16558438/in-hive-how-to-do-a-calculation-among-2-rows Thanks. --Bhathiya
    Bhathiya JayasekaraBhathiya Jayasekara
    May 15, 2013 at 9:46 am
    May 15, 2013 at 1:58 pm
  • Hi all, According to the instruction in the wiki when i run 'ant -v clean pakage' I get the following error: extract-functions: The build/builtins/metadata/class-info.xml file contains the following ...
    Subhasish sahaSubhasish saha
    May 10, 2013 at 8:53 pm
    May 10, 2013 at 10:16 pm
  • Hello, My name is Liz and I just subscribed to the mailing list for Hive. I work for a consulting company by the name of Red Oak Technologies, and we have a world-class client who is in need of ...
    Liz LeeLiz Lee
    May 9, 2013 at 8:29 pm
    May 9, 2013 at 8:39 pm
  • I see in the release notes for HIVE -3979 [HIVE-3979 <https://issues.apache.org/jira/browse/HIVE-3979 ] - Provide syntax for unescaped regex on rlike, and other regexp_* functions Yet when I click on ...
    John OmernikJohn Omernik
    May 4, 2013 at 1:19 pm
    May 6, 2013 at 7:38 pm
  • On Hive, I am using lots of tables that builds other tables, sorts of like a funnel, funneling data to get the parts I want. I am wondering what is the advantage to creating views vs creating ...
    Peter ChuPeter Chu
    May 6, 2013 at 6:40 pm
    May 6, 2013 at 6:46 pm
  • Hey all, Based on feedback from folks, I have respun release candidate, RC1. Please take a look. It basically fixes the size bloat of tarball. Source tag for RC1 is at ...
    Ashutosh ChauhanAshutosh Chauhan
    May 1, 2013 at 12:19 am
    May 6, 2013 at 9:18 am
  • Hello, I am trying to evaluate Hive 0.11.0-RC1, in particular I am very interested in the ORC storage mechanism. We have a need to have one column be a Map<String,String in a table and from what I ...
    Andrew PsaltisAndrew Psaltis
    May 3, 2013 at 5:20 pm
    May 3, 2013 at 11:01 pm
  • Hi, Using Hive 0.10.0 over Hadoop 1.0.4. I guess that I know that this is a long shot. Is there any way to access the context from inside a UDF? Specifically I want to get hold of the value of the ...
    Peter MarronPeter Marron
    May 30, 2013 at 1:49 pm
    Jun 14, 2013 at 2:37 am
Group Navigation
period‹ prev | May 2013 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions77
posts319
users91
websitehive.apache.org

91 users for May 2013

Sanjay Subramanian: 53 posts Raj Hadoop: 24 posts Stephen Sprague: 15 posts Edward Capriolo: 12 posts Owen O'Malley: 12 posts Nitin Pawar: 10 posts Peter Chu: 10 posts Sai Sai: 10 posts Bejoy_ks: 7 posts Dean Wampler: 7 posts Cyril Bogus: 6 posts ÐΞ€ρ@Ҝ (๏̯͡๏): 6 posts John Omernik: 6 posts Peter Marron: 6 posts Kulkarni Swarnim: 5 posts Andrew Psaltis: 4 posts Felix.徐: 4 posts Navis류승우: 4 posts Aishwarya Ganesan: 3 posts Carl Steinbach: 3 posts
show more
Archives