Grokbase Groups Hive user June 2012
FAQ

Search Discussions

101 discussions - 454 posts

  • Hello Experts , I'm new in Hive .When try to create a test Table in Hive I get an error.I want to run this command: *CREATE TABLE Test (DateT STRING, Url STRING, Content STRING);* but this error ...
    Babak BastanBabak Bastan
    Jun 5, 2012 at 5:14 pm
    Jun 6, 2012 at 9:44 pm
  • Hi I am using Hive with Microsoft PowerPivot as the visualization tool. When I am running a query involving UDF like this from PowerPivot: add jar /usr/local/hadoop/src/retweetlink1.jar; create ...
    Sreenath MenonSreenath Menon
    Jun 11, 2012 at 12:12 pm
    Jun 12, 2012 at 7:09 am
  • the thing is i have updated my JAVA_HOME in both .bashrc and hadoop-env.sh now the problem is when i try jps is the output is 6113 NodeManager 6799 DataNode 7562 Jps 7104 SecondaryNameNode 5728 ...
    Soham sardarSoham sardar
    Jun 20, 2012 at 9:22 am
    Jul 8, 2012 at 11:15 am
  • I would like to compress my data in the HDFS using some Hive commands. Step followed: (data already residing in table sample) create table rc_lzo like sample; SET hive.exec.compress.output=true; SET ...
    Sreenath MenonSreenath Menon
    Jun 6, 2012 at 8:50 am
    Jun 9, 2012 at 4:28 am
  • Hello experts since 2 days ago I tried to install Hive on my ubuntu but no success( I'm new in both hive and ubuntu) I read this Artikel and I do all of the steps without problem,only in step 2 I ...
    Babak BastanBabak Bastan
    Jun 2, 2012 at 1:20 pm
    Jun 2, 2012 at 4:17 pm
  • Hey Hivers, I am trying to understand what are some of the obvious and not so obvious optimization I could do for a Hive Query on AWS EMR cluster. I know the answer for some of these questions but ...
    Richin JainRichin Jain
    Jun 27, 2012 at 3:48 pm
    Jun 29, 2012 at 7:36 pm
  • I have a native data type in mysql and i just imported it into hive and the data type of the column has now become string .. Now i would like to know if there is any native data type in hive and What ...
    Soham SardarSoham Sardar
    Jun 26, 2012 at 8:53 am
    Jun 28, 2012 at 7:55 pm
  • I am posting it here first and then may be on sqoop user group as well. I am trying to use lzo compression. Tested on a standalone by installing cdh3u3 and did sqoop to hive import with lzo ...
    Chalcy RajaChalcy Raja
    Jun 18, 2012 at 1:16 pm
    Jun 19, 2012 at 12:23 pm
  • Hi experts I'm very new in Hive and Hadoop and I want to create a very simple demo to analyse sample twitts like this: T 2009-06-08 21:49:37 U http://twitter.com/evion W I think data mining is ...
    Babak BastanBabak Bastan
    Jun 5, 2012 at 9:20 am
    Jun 5, 2012 at 5:29 pm
  • Hello to everyone, I need to join hdfs data with little data taken from RDBMS. A possible solution is to import RDBMS data to a regular hive table using Sqoop, but this way I'll have to keep that ...
    Ruslan Al-FakikhRuslan Al-Fakikh
    Jun 13, 2012 at 9:36 pm
    Jun 18, 2012 at 10:51 am
  • Hi, I am trying to use the hive thrift client to connect to hive. Even though I have started the hive thrift server (it's running by checking netstat -na | grep 10000). However, the thrift client ...
    VanHuy PhamVanHuy Pham
    Jun 25, 2012 at 7:44 pm
    Jul 17, 2012 at 8:53 am
  • Hello list, Since Hive tables are assumed to be of text input format, is it right to assume that a mapper is created per row of a particular table??Please correct me if my understanding is wrong ...
    Mohammad TariqMohammad Tariq
    Jun 28, 2012 at 6:48 pm
    Jun 28, 2012 at 7:37 pm
  • Hi, dear friends. I was wondering what's the popular way to do data mining on Hive? Since the data in Hive is distributed over the cluster, is there any tool or solution could parallelize the data ...
    jason Yangjason Yang
    Jun 8, 2012 at 2:10 am
    Jun 9, 2012 at 4:41 pm
  • Hi all I am new to hive and am working on analysis of twitter data with Hive and Hadoop in a 27node cluster. At present am using Microsoft powerpivot as the visualization tool for visual ...
    Sreenath MenonSreenath Menon
    Jun 4, 2012 at 9:12 am
    Jun 6, 2012 at 8:42 am
  • Hello experts How can I set HADOOP _HOME? in which file I can find this variable? I should set this variable with the path in that I downloaded hadoop? thank you so much
    Babak BastanBabak Bastan
    Jun 2, 2012 at 9:20 am
    Jun 4, 2012 at 3:48 pm
  • Hi hive folks, Does hive thrift server support multiple requests from clients at the same time? It looks like the server serves the request sequentially, which means it processes each request one by ...
    VanHuy PhamVanHuy Pham
    Jun 29, 2012 at 8:33 pm
    Jul 6, 2012 at 5:54 am
  • Hi Hive users, We are going to use snappy for compression. What is the best file format, sequence file or RC file? Both are splittable and therefore will work well for us. RC file performance seems ...
    Chalcy RajaChalcy Raja
    Jun 26, 2012 at 1:06 pm
    Jun 27, 2012 at 11:02 pm
  • Hi, I have a data file that is exactly equivalent to a CSV , except that the field delimiter is a control character specifically '\u0001' . How can I create an external table in hive for this data ? ...
    Sam WilliamSam William
    Jun 19, 2012 at 11:15 pm
    Jun 21, 2012 at 7:02 pm
  • Is it possible to write Hive UDFs in Python? I googled but didn't find anything. I would be happy with RTFM replies if you can give link to the manual.
    Saurabh SSaurabh S
    Jun 6, 2012 at 4:21 am
    Jun 18, 2012 at 7:55 am
  • Hello, In order to provide a custom "serialization.class" to a SerDe, I created a jar containing all my custom serialization classes and added them to the hive classpath with "ADD JAR my-classes.jar" ...
    Kulkarni SwarnimKulkarni Swarnim
    Jun 13, 2012 at 2:21 pm
    Jun 13, 2012 at 3:05 pm
  • This is a weird issue. I've been setting hive CLI headers for a long time using the following: set hive.cli.print.header=true; Recently, I started using custom Hive UDF. Here is my test file, ...
    Saurabh SSaurabh S
    Jun 1, 2012 at 9:11 pm
    Jun 12, 2012 at 5:28 pm
  • I am using Multi-GroupBy-Insert. I was expecting a single map-reduce job which would club the group-bys together. However it is scheduling n jobs where n = number of group bys.. Could you please ...
    Shan sShan s
    Jun 1, 2012 at 11:55 am
    Jun 5, 2012 at 12:48 pm
  • Hey Hivers, I'm almost ready to replace our old hadoop implementation with a implementation using Hive, Now I've ran into (hopefully) my last problem; my /tmp/hive-hduser dir is getting kinda big! It ...
    Ruben de VriesRuben de Vries
    Jun 1, 2012 at 8:28 am
    Jun 1, 2012 at 1:54 pm
  • Hi All, A simple question on dates, how can I convert integer column dateint in "yyyymmdd" format to string column in "yyyy-mm-dd" format in hive. Thanks in advance. Sonia
    Sonia gehlotSonia gehlot
    Jun 26, 2012 at 12:06 am
    Jun 26, 2012 at 6:07 pm
  • Hi All, I have a table in Hive as below: dummy { col1 STRING, col2 INT, col3 INT } And in that there is some sample data as : *col1 col2 col3 * ABC 4 5 XYZ 1 2 ABC 1 3 ABC 5 1 XYZ 3 1 What should be ...
    MISMIS
    Jun 22, 2012 at 12:32 pm
    Jun 23, 2012 at 7:34 am
  • Is it possible, to create external table on a existing hive table which is partitioned. I have a existing hive table which is partitioned by dt and group like below desc page_access; page string ...
    Sai NagaSai Naga
    Jun 19, 2012 at 8:19 pm
    Jun 19, 2012 at 11:01 pm
  • Hi Hive users, I was just wondering why hive thrift server is not running as a daemon process by default. Also I am not seeing any option to start it as a daemon process if I want to. I am remotely ...
    Praveenesh kumarPraveenesh kumar
    Jun 14, 2012 at 5:58 am
    Jun 14, 2012 at 2:40 pm
  • Hi Gurus, It would be a great help if anyone can help me run hive with my local hadoop build. I followed the wiki instructions but no luck. I am sure that I am missing something here. It would be a ...
    Kanna KaranamKanna Karanam
    Jun 8, 2012 at 3:37 pm
    Jun 8, 2012 at 9:05 pm
  • Hello everyone, I develop a scientific research for my college, where I conduct experiments involving hive and I wonder what is the easiest way to install the hive. I've tried installing using ...
    Rafael Maffud CarliniRafael Maffud Carlini
    Jun 5, 2012 at 10:12 pm
    Jun 8, 2012 at 1:13 pm
  • I am not able to create a table in the hive interactive shell the command given is hive CREATE TABLE page_view(viewTime INT, userid BIGINT, page_url STRING, referrer_url STRING, ip STRING COMMENT 'IP ...
    Soham sardarSoham sardar
    Jun 7, 2012 at 12:42 pm
    Jun 8, 2012 at 8:07 am
  • Hi folks, I have a question regarding HIVE 2837( https://issues.apache.org/jira/browse/HIVE-2837) that deals with disallowing external table from using insert into queries. HDFS as well. Technically, ...
    Mark GroverMark Grover
    Jun 1, 2012 at 4:36 am
    Jun 1, 2012 at 2:50 pm
  • I've written some code where I am trying to get the atime of my tables in Hive. It's fairly simple - the method call in question is simply: int atime = htable.getLastAccessTime(); Where htable is an ...
    Stephen R. ScaffidiStephen R. Scaffidi
    Jun 28, 2012 at 1:28 pm
    Jul 3, 2012 at 11:28 am
  • We have a scenario where we want to make a UDF permanent so that way a query through the HiveODBC driver will be able to access the UDF. I seem to recall that after creating the UDF, you can make it ...
    Denny LeeDenny Lee
    Jun 27, 2012 at 2:31 am
    Jun 28, 2012 at 8:35 pm
  • Hi Everyone, I have a column family(table) named comments in Cassandra with data in following format : Key Value comment_id 502587858 Comment Some comments crawled_page_id 23821746 date ...
    Rajesh BawalRajesh Bawal
    Jun 27, 2012 at 12:37 pm
    Jun 27, 2012 at 1:59 pm
  • Hi, I've hit problems when writing custom UDTF that should return string values. I couldn't find anywhere what type should have the values that get forward()ed to collector. The only info I could dig ...
    Jan DolinárJan Dolinár
    Jun 21, 2012 at 12:02 pm
    Jun 22, 2012 at 1:54 pm
  • Hi, I've built a datastore using Hive 7.1 backed by S3 using persistent metadata. Now that hive 8.1 is available, I'd like to migrate to the new version. However, I'm having trouble reading tables ...
    Ranjan BagchiRanjan Bagchi
    Jun 18, 2012 at 7:56 pm
    Jun 19, 2012 at 7:23 pm
  • So...I have a table that has thousands of files, and Billions of rows related it. Lets make this a simple table: CREATE TABLE test_table ( ts BIGINT, exec_time DOUBLE, domain_id BIGINT, domain_name ...
    Tim HavensTim Havens
    Jun 19, 2012 at 3:04 pm
    Jun 19, 2012 at 7:14 pm
  • Hi all, Is there a way to define the field delimiter for output file when using the command INSERT OVERWRITE LOCAL DIRECTORY 'path' -- Regards, Tishan
    Tishan pubudu kanishka dahanayakageTishan pubudu kanishka dahanayakage
    Jun 19, 2012 at 6:48 am
    Jun 19, 2012 at 8:03 am
  • Has the block sampling feature been added to one of the latest (Hive 0.8 or Hive 0.9) releases. The wiki has the blurb below on block sampling Block Sampling It is a feature that is still on trunk ...
    Ladda, AnandLadda, Anand
    Jun 15, 2012 at 6:59 pm
    Jun 15, 2012 at 8:00 pm
  • hello, for all the log files i have i log the session id and user cookie. now i need to seperate certain items of certain users, so i need to join all my data to a global cookike table. what are some ...
    Cam BazzCam Bazz
    Jun 13, 2012 at 4:46 pm
    Jun 13, 2012 at 5:11 pm
  • Hi Guys, I am writing a UDF in hive to convert a double value to string, so the evaluate method of my UDF class looks like import org.apache.hadoop.hive.ql.exec.UDF; import ...
    Richin JainRichin Jain
    Jun 12, 2012 at 8:57 pm
    Jun 12, 2012 at 9:26 pm
  • Hi , I am seeing a very weird hive-hbase query behaviour. I have an externally mounted hbase table in hive select creation_ts, length(url), isnull(url), ! (isnull(url)) from task_table limit 10 ...
    Sagar naikSagar naik
    Jun 2, 2012 at 4:21 am
    Jun 11, 2012 at 8:19 pm
  • Hello, I have finally wrote a program to upload my data to amazon s3, start a cluster on amazon emr, and recover my partitions, and can issue simple queries on hive. now I would like to: select ...
    Cam BazzCam Bazz
    Jun 11, 2012 at 12:46 pm
    Jun 11, 2012 at 2:47 pm
  • Hi, We're expecting some issue with the sum function in Hive 0.7.1. The precision of float number isn't correct (0.320484484676 instead of 0.32) We aren't expecting this error with double format. For ...
    Guillaume PolaertGuillaume Polaert
    Jun 11, 2012 at 9:50 am
    Jun 11, 2012 at 10:19 am
  • Hi, i had tried to create the table by "LINES terminated by '\001' " and it is giving me the error Error in semantic analysis: 3:66 LINES TERMINATED BY only supports newline '\n' right now. Error ...
    Tabraiz anwerTabraiz anwer
    Jun 4, 2012 at 4:09 pm
    Jun 4, 2012 at 9:06 pm
  • Hello all! I tried to create simple table in hive But its failed: FAILED: Error in metadata: MetaException(message:Got exception: java.io.FileNotFoundException File file:/user/hive/warehouse/test ...
    Павел МезенцевПавел Мезенцев
    Jun 3, 2012 at 6:54 am
    Jun 4, 2012 at 10:42 am
  • Hi, hive users I have the following udf: package com.name.hadoop.hive.udf; import java.util.Set; import org.apache.commons.lang.StringUtils; import org.apache.hadoop.hive.ql.exec.UDF; import ...
    Yue GuanYue Guan
    Jun 26, 2012 at 2:20 pm
    Jun 27, 2012 at 8:20 am
  • Hi, I am trying to create an external table in hive, by referring to a directory in hadoop containing multiple files of the same type inside the directory. But hive gives an error, that the path ...
    Mayank BansalMayank Bansal
    Jun 21, 2012 at 10:17 am
    Jun 21, 2012 at 1:56 pm
  • Hi all, How map side join in hive, can be used to join multiple tables(suppose 5 tables). Regards Abhishek Sent from my iPhone
    AbhishekAbhishek
    Jun 13, 2012 at 3:13 pm
    Jun 18, 2012 at 8:08 am
  • hi all, Map side join with distributed cache how to do this? can any one help me on this. Regards Abhishek
    Abhishek doddaAbhishek dodda
    Jun 11, 2012 at 4:00 pm
    Jun 11, 2012 at 4:18 pm
Group Navigation
period‹ prev | Jun 2012 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions101
posts454
users105
websitehive.apache.org

105 users for June 2012

Bejoy KS: 35 posts Babak Bastan: 33 posts Mohammad Tariq: 26 posts Sreenath Menon: 23 posts Mark Grover: 19 posts Soham Sardar: 19 posts Edward Capriolo: 18 posts Nitin Pawar: 17 posts Jan Dolinár: 14 posts Jagat Singh: 12 posts Kulkarni Swarnim: 12 posts Shashwat Shriparv: 12 posts Chalcy Raja: 11 posts Aniket Mokashi: 9 posts Mark Grover: 8 posts Richin Jain: 7 posts Ladda, Anand: 6 posts Jasper Knulst: 5 posts Ruben de Vries: 5 posts VanHuy Pham: 5 posts
show more
Archives