Grokbase Groups Hive user May 2011
FAQ

Search Discussions

76 discussions - 244 posts

  • Does anyone know how to export data out with column names? Any help here is appreciated. Thanks, Ranjith
    Raghunath, RanjithRaghunath, Ranjith
    May 3, 2011 at 3:12 am
    May 4, 2011 at 7:01 pm
  • Hello, I have one instance of HIVE JDBC server running on port 10000. Can I run another instance on different port ? Would it cause a concurrency issue on the underlying data warehouse files ? Please ...
    V.Senthil KumarV.Senthil Kumar
    May 2, 2011 at 10:42 pm
    May 4, 2011 at 6:06 pm
  • Hi I am facing a weird issue with the file parsing. My log files have a thorn 'þ' as separator. I tried writing a test case for deserializer and kind of confused by the fact it works fine as I pass ...
    Ankit bhatnagarAnkit bhatnagar
    May 8, 2011 at 12:00 am
    Sep 7, 2011 at 8:53 am
  • My Hive metastore uses MySQL. I'd like to see Hive CLI log all SQL queries that are issued to MySQL. What config/property should I set to accomplish this? Thanks. Steven
    Steven WongSteven Wong
    May 23, 2011 at 9:46 pm
    Jun 2, 2011 at 5:39 pm
  • hi, The default value is "/user/hive/warehouse" in hive.site.xml. After I changed the directory to a path on HDFS, I got the exception. FAILED: Error in metadata: MetaException(message:Got exception: ...
    Jinhang duJinhang du
    May 18, 2011 at 4:54 am
    May 19, 2011 at 4:54 am
  • Hi all, I want to custom the delimiter of the table in a row. Like my data format is '1&&&&2&&&&4‘, and how could I create a table (int, int, int) Thanks. -- dujinhang
    Jinhang duJinhang du
    May 25, 2011 at 11:56 am
    May 30, 2011 at 4:51 am
  • (As an FYI I'm relatively new to Hive and have no previous SQL experience, so have been struggling a bit with the Language manual which seems to assume previous SQL experience) Suppose I have a ...
    Adam PhelpsAdam Phelps
    May 23, 2011 at 8:04 pm
    May 24, 2011 at 7:24 pm
  • I'm getting into an issue when trying to run hive over the hadoop cluster. The hadoop cluster is working fine, in a stand alone manner. I'm using hadoop 0.20.2 and hive 0.7.0 versions. The problem is ...
    MISMIS
    May 23, 2011 at 9:56 am
    May 24, 2011 at 9:19 am
  • My data format is as follows: a&&&b c&&&b^^xyz c&&&d^^hdo create table f(str1 string, str2 string) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe' With SERDEPROPERTIES ( ...
    Jinhang duJinhang du
    May 30, 2011 at 9:07 am
    May 31, 2011 at 8:35 am
  • Hi, I have a partitioned external table on Hive 0.7. New subfolders are regularly added to the base table HDFS folder. I now have to perform this scan myself and let an external tool create new ...
    Jasper KnulstJasper Knulst
    May 19, 2011 at 9:26 am
    May 19, 2011 at 11:08 pm
  • Hi, I started using Toad for Hive,looks cool! I installed the plugins in Eclipse in windows and it started working fine. I have a few questions: 1. Does it work with Ubuntu-Linux? 2. Job Tracker ...
    MikeMike
    May 14, 2011 at 4:13 pm
    May 17, 2011 at 6:23 am
  • hi, After upgrade to hive 0.7, I found there will a file named 'derby.log' and directory named 'TempStatsStore' be created every time I run the hive job . What does these files do? Is there a way to ...
    WdWd
    May 10, 2011 at 10:07 am
    May 11, 2011 at 2:56 am
  • Hi all, Sorry for bothering this mail list. But I only this mail list may relate with howl. Just wonder what's official site or mail list for howl. I'd like to get more information about howl -- Best ...
    Jeff ZhangJeff Zhang
    May 5, 2011 at 2:05 am
    May 5, 2011 at 5:57 am
  • I created a partitioned table, partitioned daily. If I query the earlier partitions, everything works. The later ones fail with error: hive select substr(user_name,1,1),count(*) from u_s_h_b where ...
    Time LessTime Less
    May 4, 2011 at 1:52 am
    May 4, 2011 at 6:12 pm
  • My cluster went corrupt-mode. I wiped it and deleted the Hive metastore and started over. In the process, I did a "yum upgrade" which probably took me from CDH3b4 to CDH3u0. Now everytime I submit a ...
    Time LessTime Less
    May 7, 2011 at 1:48 am
    Aug 29, 2011 at 10:29 pm
  • I have followed the document outlining how to perform the connection listed in http://wiki.apache.org/hadoop/Hive/HiveJDBCInterface. However, I keep getting a error when trying to connect. I would ...
    Raghunath, RanjithRaghunath, Ranjith
    May 17, 2011 at 2:57 am
    May 23, 2011 at 4:45 pm
  • Hey all, Just wondering if there is native support for input arguments on Hive scripts. eg. $ bin/hive -f script.q <arg1 arg2 Any documentation I could reference to look into this further? Cheers, Jon
    Jonathan BenderJonathan Bender
    May 4, 2011 at 9:11 pm
    May 4, 2011 at 11:16 pm
  • Hi, I need to take a cross join of a big table with itself, is it possible to do it using Hive ? E.g. Set : 1 2 3 Result : 1,1 1,2 1,3 2,1 2,2 2,3 3,1 3,2 3,3 This would also do : 1,2 1,3 2,3 In fact ...
    Abhinov AgarwalAbhinov Agarwal
    May 2, 2011 at 3:51 am
    May 2, 2011 at 9:08 pm
  • Hi Guys I use flume to store log file , and use hive to query. Flume always store the small file with suffix .seq Now I have over 35 thousand seq files. Every time when I launch query script, 35 ...
    Junxian YanJunxian Yan
    May 31, 2011 at 9:56 am
    Jun 1, 2011 at 7:38 pm
  • Hey friends, I have been using Hive to explore my HDFS for a while now. In my organization we have some applicative information in SqlServer that occasionally I need to join with data I have in the ...
    Guy DoulbergGuy Doulberg
    May 31, 2011 at 12:33 pm
    Jun 1, 2011 at 6:20 am
  • Hi, I want to be able to extract data from Mysql to Hadoop without writing the data to disk. I was thinking in the line of piping the extract and loading it to Hadoop. Something like this: mysql ...
    Bichonfrise74Bichonfrise74
    May 6, 2011 at 5:46 pm
    May 27, 2011 at 1:46 am
  • Hi everyone, I couldn't find this information anywhere. I would like to confirm that Hive query cannot be concurrent. Is it true that you can only run one hive query on a hive server at any one given ...
    Jonathan HwangJonathan Hwang
    May 25, 2011 at 9:07 pm
    May 27, 2011 at 1:00 am
  • I would like to implement some kind of assert functionality in Hive QL. Here is how I do it in MySQL. I can assert that a given query returns no (bad) rows by creating a table with one row containing ...
    Igor TatarinovIgor Tatarinov
    May 26, 2011 at 9:00 pm
    May 26, 2011 at 9:56 pm
  • Hi all, I want to create a lot of tables and load data separately. These tables need different parameters. So I want to use python for example, to invoke the command line client. How to do it? My ...
    Jinhang duJinhang du
    May 26, 2011 at 1:56 am
    May 26, 2011 at 8:23 am
  • Hi , I have a four column external table. One of the col is array of struct of five fields. I use a custom serde, to read out hadoop seq file and populate values on to hive row. The array of struct ...
    Sagar NaikSagar Naik
    May 13, 2011 at 1:46 am
    May 13, 2011 at 9:12 pm
  • We are planning a migration from a large PostgreSQL-based DWH to Hadoop/Hive. The principal reason for this migration is the massive growth of the data to analyze (5.6 TB and growing) where ...
    Marcos OrtizMarcos Ortiz
    May 4, 2011 at 8:24 pm
    May 4, 2011 at 9:48 pm
  • Hello all, I'm new to this list, I was wondering if anyone could answer a couple questions about the implementation of statistics in 0.7? I've reviewed http://wiki.apache.org/hadoop/Hive/StatsDev and ...
    Guy BayesGuy Bayes
    May 26, 2011 at 8:26 pm
    May 26, 2011 at 10:22 pm
  • Hi All, I'm trying to convert Oracle SQL to HiveQL, esp Oracle Analytic functions. Is it possible to implement using Hive UDFs or workarounds? I would like to hear your experiences and advice. Thanks ...
    김영우김영우
    May 25, 2011 at 11:46 am
    May 26, 2011 at 1:05 pm
  • Hi Everyone, I get a war not found error, when the war file exists. Any ideas? [ayon@d002 ant]$ ls -l /usr/lib/hive/lib/hive-hwi-0.7.0-cdh3u0.war -rwxr-xr-x 1 root root 29304 Mar 26 00:43 ...
    Ayon SinhaAyon Sinha
    May 24, 2011 at 2:09 am
    May 24, 2011 at 4:21 am
  • Hello, I am running a cloudera hadoop/hbase cluster. I trying to integrate hive with that. I need multiple (read) accesses to hive per Java/jdbc-client. Is this possible in any way? Following this ...
    LabtraxLabtrax
    May 19, 2011 at 9:50 am
    May 19, 2011 at 8:14 pm
  • Hi, Can I use a spacial char like '^B' as the split pattern ? I've tried '\002', '^B', '0x02', all failed.
    WdWd
    May 18, 2011 at 3:46 am
    May 18, 2011 at 6:04 am
  • Hi experts, I got to know that hive has no stored procedures.but this can be done in Hive with the help of streaming and functions.Is there any way to implement *Declare,Conditional handling ...
    Jothi AJothi A
    May 11, 2011 at 9:07 am
    May 17, 2011 at 9:57 am
  • Hi ,all. Do hive implements data mining algorithms like apriori algorithm , k-means and bayes? if not , how about plugins about data mining algorithms? thanks a lot .
    皮皮皮皮
    May 16, 2011 at 3:31 am
    May 16, 2011 at 1:22 pm
  • I've been using Hive in production for two months now. We're mainly using it for processing server logs, about 1-2GB per day (2-2.5 million requests). Typically we import a day's worth of logs at ...
    Tim SpenceTim Spence
    May 11, 2011 at 9:16 pm
    May 12, 2011 at 12:06 am
  • Hi, My end goal is to load the daily Apache logs. I wish to partition it by date and the group has helped me in giving some advices, but it seems that I am still stuck. My "daily Apache logs" can ...
    Bichonfrise74Bichonfrise74
    May 10, 2011 at 5:56 pm
    May 11, 2011 at 7:57 pm
  • Hello everyone. I am a student who begins to do some research on Hive project. I think the first step is to have a successful build of Hive. I have downloaded the Hive source code, uploaded to the ...
    Alex.WangAlex.Wang
    May 11, 2011 at 8:30 am
    May 11, 2011 at 9:12 am
  • Hello, I have a hadoop cluster running with the hadoop_append-jar (hadoop-core-0.20-append-r1056497-core.jar) for hbase reason. I tried hive 0.6.0 and 0.7.0 and for both each when I start it I get ...
    Hive1Hive1
    May 9, 2011 at 2:14 pm
    May 9, 2011 at 7:11 pm
  • Hi experts, I'm new hivebe.Worked with some basic queries in Hive.Anyone can help me by giving some info regarding using Stored Procedures in Hive. As of now i don't have any idea regarding ...
    Jothi AJothi A
    May 6, 2011 at 12:38 pm
    May 6, 2011 at 2:15 pm
  • Hi All, I am new to Hive and have been reading http://wiki.apache.org/hadoop/Hive/Tutorial to get better understanding of Hive I am sorry for really basic questions, but I have some confusion, here ...
    Abh notAbh not
    May 31, 2011 at 10:25 pm
    Jun 1, 2011 at 7:38 am
  • Hi, I'm working with compressions in Hadoop,idea is to compress the file in Linux then to process the same in Hadoop and to decompress it to Linux. I'm able to do this for gzip and bzip2 *but when i ...
    Jothi AJothi A
    May 27, 2011 at 10:00 am
    May 31, 2011 at 5:24 am
  • Hi All, I have installed Hive 0.7 and its up and running. But I am getting permission denied error while creating a table. But I have rwxrwxr-x to warehouse directory. My HADOOP_HOME is setup to ...
    Sonia gehlotSonia gehlot
    May 27, 2011 at 5:30 pm
    May 30, 2011 at 2:33 pm
  • We have a query which looks something like this select /*+ MAPJOIN(a) */ * from tableA a left outer join tableB b on (a.id = b.id and a.dt = b.dt ) TableB is partitioned on dt We found that the query ...
    Shantian PurkadShantian Purkad
    May 27, 2011 at 9:33 pm
    May 28, 2011 at 2:30 am
  • Hello, We want to provide hints to hive to use mapside join on multiple tables. something like /*+ MAPJOIN(a, b,c) */ Is it possible? If yes, what is the syntax for the same? Thanks and Regards, ...
    Shantian PurkadShantian Purkad
    May 26, 2011 at 9:26 pm
    May 26, 2011 at 9:30 pm
  • But a and b are not in same database... .. ------------------ 原始邮件 ------------------ 发件人: "������"<warwithin@gmail.com ; 发送时间: 2011年5月26日(星期四) 中午11:48 收件人: "user"<user@hive.apache.org ; 主题: Re: How ...
    皮皮皮皮
    May 26, 2011 at 4:53 am
    May 26, 2011 at 5:16 am
  • Hi ,all. How to create table like other database's table ? e.g. i create table a in test1 , and then I want create table b in test2, that have a same shema with table a in test1. Thanks.
    皮皮皮皮
    May 26, 2011 at 2:21 am
    May 26, 2011 at 3:49 am
  • Can someone share Hive queries used to create the table with Elephant-bird (ProtoBuf) SerDe? Sorry, if it was covered, I am new to the list. Thx. -- valentina kroshilina
    Valentina kroshilinaValentina kroshilina
    May 24, 2011 at 2:31 pm
    May 25, 2011 at 1:57 am
  • Hey, I am dealing with a problem I just don't understand, maybe you could help me... I have an external table, that is partitioned by date (for example '20110511'). I assembled a hive query that ...
    Guy DoulbergGuy Doulberg
    May 22, 2011 at 8:41 am
    May 24, 2011 at 2:02 pm
  • Does anyone know how I can go about unsubscribing from these hive lists?
    AaronAaron
    May 21, 2011 at 8:11 pm
    May 21, 2011 at 8:13 pm
  • Hello, some questions about the hbase/hive integration: I am running a cloudera hadoop/hbase cluster. I want to get access with hive to hbase tables. This actually works fine with cli like sudo -u ...
    LabtraxLabtrax
    May 19, 2011 at 8:00 am
    May 20, 2011 at 2:53 pm
  • Is there an open source UDF to explode a Map (like explode for an array) that has key and value columns for each row? Thanks, Quinn
    Quinn GilQuinn Gil
    May 18, 2011 at 3:48 pm
    May 20, 2011 at 5:26 am
Group Navigation
period‹ prev | May 2011 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions76
posts244
users85
websitehive.apache.org

85 users for May 2011

Jinhang du: 14 posts Raghunath, Ranjith: 11 posts Steven Wong: 10 posts Time Less: 9 posts Edward Capriolo: 8 posts Jasper Knulst: 8 posts 김영우: 7 posts 皮皮: 7 posts Jothi A: 6 posts Labtrax: 6 posts Ning Zhang: 6 posts Ankit bhatnagar: 5 posts Ashish Thusoo: 5 posts Marcos Ortiz: 5 posts MIS: 5 posts V.Senthil Kumar: 5 posts Bichonfrise74: 4 posts Igor Tatarinov: 4 posts Jov: 4 posts Matthew Rathbone: 4 posts
show more
Archives