Grokbase Groups Hive user August 2010
FAQ

Search Discussions

91 discussions - 278 posts

  • Hi, I cannot find any documentation about what algorithm performs HIVE to translate JOIN clauses to Map-Reduce tasks. In particular, if I have two tables A and B, each table is written on a separate ...
    Cappa RobertoCappa Roberto
    Aug 6, 2010 at 6:46 am
    Aug 12, 2010 at 9:20 pm
  • Because my company reuire we use 0.4.1 version, the version don't support IN clause. I want to use the OR clause(example:where id=1 or id=2 or id=3) to implement the IN clause(example: id in(1,2,3) ...
    Lei liuLei liu
    Aug 4, 2010 at 10:11 am
    Aug 5, 2010 at 7:33 am
  • When I run below sql: INSERT OVERWRITE TABLE tablename1 select_statement1 FROM from_statement, there are many files which size is zero are stored to hadoop, How can I merge these small files? Thanks, ...
    Lei liuLei liu
    Aug 6, 2010 at 3:48 am
    Aug 10, 2010 at 2:53 pm
  • Hi, I have a database and am looking for a way to 'mount' the db table in hive in such a way that the select query in hive gets translated to sql query for database. I saw DBInputFormat and sqoop, ...
    Amit jaiswalAmit jaiswal
    Aug 2, 2010 at 6:27 am
    Aug 5, 2010 at 12:50 am
  • Hi - I've a following SQL query. What is the way to convert it into HIVE runnable format - Select a.id, count(b.url) from a, b where a.id = b.id and (b.url like '%google.com%' or b.url like ...
    Ronak BhattRonak Bhatt
    Aug 20, 2010 at 2:38 pm
    Aug 20, 2010 at 5:29 pm
  • I'm trying to do a dynamic partition insert like so: FROM ( FROM ( SELECT project, file, os, country, dt FROM test_downloads WHERE dt='2010-06-30' CLUSTER BY project, file, dt ) a SELECT ...
    Luke CrouchLuke Crouch
    Aug 14, 2010 at 4:46 pm
    Aug 17, 2010 at 2:24 pm
  • Hi all - I'm running the Hive Server to allow multiple JDBC queries and inserts over the course of a day. What I've noticed is that there seems to be a pretty bad leak with connections over the ...
    Scott WhitecrossScott Whitecross
    Aug 30, 2010 at 7:51 pm
    Sep 2, 2010 at 1:29 pm
  • Hi, We wanted to avoid user from dropping table created by another user. By changing the hdfs permission of the table dir, we were able to prevent the table from getting deleted from hdfs. But ...
    Bakshi, AnkitaBakshi, Ankita
    Aug 3, 2010 at 10:38 pm
    Aug 4, 2010 at 9:54 pm
  • hi all, I am unable to run hive web interface. Please help me to setup the same. I have the following settings. -------------------------------------- $ hive --service hwi 10/08/20 15:38:58 INFO ...
    Guru PrasadGuru Prasad
    Aug 20, 2010 at 10:22 am
    Aug 27, 2010 at 3:09 am
  • Hello everyone, I use JDBC to connection the hive server, sometime I receive below exception: java.sql.SQLException: org.apache.thrift.transport.TTransportException: Cannot read. Remote side has ...
    Lei liuLei liu
    Aug 23, 2010 at 7:37 am
    Aug 23, 2010 at 11:51 am
  • Hi - in my HIVE environment, I ran the following query and expecting to see the rows (the data is present)...however, after 2339 seconds, the o/p I get is as shown below in the email (I've pasted ...
    Ronak BhattRonak Bhatt
    Aug 20, 2010 at 7:12 pm
    Aug 21, 2010 at 1:40 am
  • I have a string column that contains a JSON array on each row. Calling the function get_json_object on that column always returns NULL: $ hive -e "select cdnbwdata, get_json_object(cdnbwdata, '$'), ...
    Steven WongSteven Wong
    Aug 18, 2010 at 10:08 pm
    Aug 19, 2010 at 4:15 am
  • Hi all, I'm mystified by Hive's behavior for two types of queries. 1: consider the following simple select query: insert overwrite table alogs_test_extracted1 select raw.client_ip, raw.cookie, ...
    Leo AlekseyevLeo Alekseyev
    Aug 14, 2010 at 3:17 am
    Aug 18, 2010 at 11:57 pm
  • I look see below content in http://wiki.apache.org/hadoop/Hive/HiveClientpage: For embedded mode, uri is just "jdbc:hive://". How can I use JDBC client embedded mode? Could anybody give me an example?
    Lei liuLei liu
    Aug 9, 2010 at 4:12 pm
    Aug 11, 2010 at 4:46 pm
  • Hi all, I'm trying to figure out how to query Hive on latin1 encoded data. I created a file with 256 characters, with unicode value 0-255, encoded in latin1. I made a table out of it. But when I do a ...
    bc Wongbc Wong
    Aug 2, 2010 at 3:31 am
    Aug 2, 2010 at 4:02 pm
  • August 8th, 2010 - Yongqiang He gave a presentation about his work on index support in Hive. - Slides are available here: http://files.meetup.com/1658206/Hive%20Index.pptx - John Sichi talked about ...
    Carl SteinbachCarl Steinbach
    Aug 28, 2010 at 10:00 am
    Aug 31, 2010 at 8:07 pm
  • Hello, Any pointers about directing output from Hive MR as input for another (not hive based) MR job? I would like to use hive to select a subset of my data and then process that data using my custom ...
    Maxim VekslerMaxim Veksler
    Aug 25, 2010 at 9:13 am
    Aug 26, 2010 at 2:15 pm
  • for the following create table, I'm getting the error : FAILED: Error in semantic analysis: Column repeated in partitioning columns... any suggestion? thanks, ronak create table callbacks_part ( ID ...
    Ronak BhattRonak Bhatt
    Aug 21, 2010 at 1:42 am
    Aug 21, 2010 at 10:47 am
  • We are running hive server with mysql as metastore. The server receives LOAD DATA hql every 30 sec (from flume), everything runs fine for about 90 minutes and then the hive server throws following ...
    Anurag PhadkeAnurag Phadke
    Aug 2, 2010 at 8:15 pm
    Aug 2, 2010 at 9:50 pm
  • Hello everyone, I am able to retrieve data from Hive which comes with HAdoopDB package(SMS).Data is stored in Postgres and metadata is in Mysql But when I fired a count(1) query , it gives the ...
    Adarsh SharmaAdarsh Sharma
    Aug 27, 2010 at 7:14 am
    Aug 27, 2010 at 1:31 pm
  • I tried a query like below, same table, same column and different conditions, only one MR job generated, is it optimized by Hive itself? and is the' table_1' only scanned once? who can give some ...
    Neil XuNeil Xu
    Aug 25, 2010 at 9:41 am
    Aug 26, 2010 at 6:37 pm
  • what's the parameter "hive.exec.scratchdir" for ? save the job plan ? the space of this directory is growing too fast and I don't know why files under this directory is not removed after the job is ...
    ShanganShangan
    Aug 24, 2010 at 8:35 am
    Aug 24, 2010 at 9:23 am
  • Consider the following table (I've omitted things like additional columns and the serde specification since I think they are mostly irrelevant): CREATE TABLE event_log (visit_time bigint, visitor_id ...
    Rajappa IyerRajappa Iyer
    Aug 23, 2010 at 8:37 pm
    Aug 23, 2010 at 11:32 pm
  • Hi all, I found 2 parameters which have something to do with mapjoin, that is : hive.mapjoin.cache.numrows hive.mapjoin.size.key I can't find any formal document on that 2 parameters. I guess ...
    Ted XuTed Xu
    Aug 19, 2010 at 8:07 am
    Aug 20, 2010 at 5:39 pm
  • hi,all Could anyone tell me how to configurate hive in order to support Chinese characters ? And when using hwi,how to configure directory of the result file, by default now it is the 'conf' ...
    ShanganShangan
    Aug 13, 2010 at 11:02 am
    Aug 16, 2010 at 3:34 pm
  • what is difference hive local model and standalone model. Can the hive local model be ran in windows?
    Lei liuLei liu
    Aug 13, 2010 at 4:10 pm
    Aug 16, 2010 at 11:35 am
  • Hi, Consider the following query: INSERT OVERWRITE TABLE q1_pricing_summary_report SELECT L_RETURNFLAG, L_LINESTATUS, SUM(L_QUANTITY), SUM(L_EXTENDEDPRICE), SUM(L_EXTENDEDPRICE*(1-L_DISCOUNT)), ...
    Yingyi BuYingyi Bu
    Aug 13, 2010 at 2:52 pm
    Aug 13, 2010 at 7:17 pm
  • Hi, I think I may have run into a Hive bug. And I'm not sure what's causing it or how to work around it. The reduce task log contains this exception: <td <pre java.io.IOException: ...
    Marc LimotteMarc Limotte
    Aug 9, 2010 at 2:33 am
    Aug 10, 2010 at 12:55 am
  • Hi, I had execute "ALTER TABLE tablename ADD COLUMNS (newcolumns STRING)" to add column, before i add this column, got 4 columns, the new column will after the 4th column, and before partition ...
    SingoWongSingoWong
    Aug 26, 2010 at 5:10 am
    Sep 1, 2010 at 5:03 am
  • Hi folks, 'hive.merge.mapfiles=true' is a default for trunk. but I've got an error like below: Exception in thread "main" java.lang.NoSuchMethodError: ...
    김영우김영우
    Aug 31, 2010 at 2:14 am
    Aug 31, 2010 at 2:51 am
  • Hello guys, Over at http://search-hadoop.com we index Hive subprojects mailing lists, wiki, web site, source code, javadoc, jira... Would the community be interested in a patch that replaces the ...
    Alex BaranauAlex Baranau
    Aug 25, 2010 at 4:10 pm
    Aug 27, 2010 at 12:36 am
  • I c...if you have errors, send the message to hive-user@hadoop.apache.org....I've observed that someone would respond... *thanks, ronak* * * *408 504 4847* *My Blog : http://ronakbaps.posterous.com* ...
    Ronak BhattRonak Bhatt
    Aug 25, 2010 at 12:04 am
    Aug 25, 2010 at 1:33 am
  • Hi guys, I would like to use the Multi Insert feature of HIVE so that I could have fewer map-reduce jobs than running separate queries. I have some HIVE queries that use the Multi Insert feature as ...
    Cristi CioriiaCristi Cioriia
    Aug 24, 2010 at 3:49 pm
    Aug 24, 2010 at 5:01 pm
  • when hive craete a table ,we need set hql like this 'CREATE TABLE page_view(viewTime INT, userid BIGINT, page_url STRING, referrer_url STRING, ip STRING COMMENT 'IP Address of the User') COMMENT ...
    T liuT liu
    Aug 18, 2010 at 3:41 am
    Aug 18, 2010 at 5:29 am
  • Hello, [I posted the question below to Cloudera's getsatisfaction site but am cross-posting here in case hive-users folks have debugging suggestions. I'm really stuck on this one.] I recently ...
    Ken BarclayKen Barclay
    Aug 13, 2010 at 2:19 am
    Aug 13, 2010 at 2:36 am
  • In the doc ( http://wiki.apache.org/hadoop/Hive/Tutorial#Map.28Associative_Arrays.29_Operations) it is written that Map (Associative Arrays) can only be created programmatically currently. Does ...
    ShimiShimi
    Aug 10, 2010 at 10:44 am
    Aug 11, 2010 at 7:58 am
  • Hi, I have a problem and I hope someone has an idea on how to solve it. My dataset consists of just very simple key-value pairs of strings coming from PostgreSQL using Sqoop. 1) I need to count how ...
    Lars FranckeLars Francke
    Aug 9, 2010 at 10:42 pm
    Aug 10, 2010 at 9:31 am
  • What do you guys thing about this error? [edward@ec dist]$ bin/hive Hive history file=/tmp/edward/hive_job_log_edward_201008081453_1405038865.txt hive add jar /opt/cassandra/conf/storage-conf.xml; ...
    Edward CaprioloEdward Capriolo
    Aug 8, 2010 at 7:01 pm
    Aug 9, 2010 at 9:13 pm
  • Hi, What value does hive expect in the data for a column to be treated as null? I tried some permutations on a text data based table but couldn't figure out what the correct representation was. I ...
    Pradeep KamathPradeep Kamath
    Aug 9, 2010 at 4:44 pm
    Aug 9, 2010 at 8:07 pm
  • I can send email to hive-user@hadoop.apache.org, but after other people reply my email, I can't reply the people's email and I recieve below message: host mx1.eu.apache.org[192.87.106.230] said: 552 ...
    我很快乐我很快乐
    Aug 4, 2010 at 9:14 am
    Aug 5, 2010 at 1:46 am
  • I have a query that runs as 2 MR jobs: set hive.exec.compress.intermediate = true; set hive.exec.compress.output = true; set mapred.output.compression.codec = org.apache.hadoop.io.compress.GzipCodec; ...
    Steven WongSteven Wong
    Aug 27, 2010 at 12:16 am
    Aug 30, 2010 at 6:53 pm
  • Hi, I also have problem with hiveserver, too many open files exception, described two weeks ago and then reported as a bug here: ...
    Aleksander SiewierskiAleksander Siewierski
    Aug 27, 2010 at 10:56 am
    Aug 27, 2010 at 12:46 pm
  • When hadoop one job which is submmited by hive, hadoop need the hive_exec.jar, hwo to hive add hive_exec.jar to hadoop? Please tell me the where are codes in hive. Thanks, LiuLei
    Lei liuLei liu
    Aug 25, 2010 at 5:07 am
    Aug 25, 2010 at 2:54 pm
  • Hi all, I'm looking at http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL, where there's a code example of the following: ALTER TABLE table_name [partitionSpec] SET LOCATION "new location" ...
    Leo AlekseyevLeo Alekseyev
    Aug 24, 2010 at 2:26 am
    Aug 24, 2010 at 8:23 am
  • Hi all, Is it possible to add partitions to an existing table?.. Basically, I have a table partitioned by date, but it should have another partition field -- that is, the hdfs paths should look ...
    Leo AlekseyevLeo Alekseyev
    Aug 24, 2010 at 6:36 am
    Aug 24, 2010 at 7:23 am
  • I add one line code in HiveInputFormat.java class, example: LOG.info("111111111"), then I package the codes into hive_exec.jar and put the code in $HIVE_HOME/lib, but the code I add don't take ...
    Lei liuLei liu
    Aug 22, 2010 at 2:34 am
    Aug 23, 2010 at 5:17 pm
  • Could anyone give me some suggestion on how to control the privilege of users of hive ? As you know, in production cluster, normally we put all data into the cluster,but actually we don't want every ...
    ShanganShangan
    Aug 23, 2010 at 7:11 am
    Aug 23, 2010 at 1:58 pm
  • Hello everyone , I see many patches of Hadoop-Hive Can anybody Please tell me how to apply patches to Hive. Thanks in Advance.
    Adarsh SharmaAdarsh Sharma
    Aug 23, 2010 at 8:51 am
    Aug 23, 2010 at 1:56 pm
  • Hi, Is there an equivalent of MySQL "database" construct in Hive. Basically, something like a namespace within which table names are unique but might be the same as table names within a different ...
    Sanjit JhalaSanjit Jhala
    Aug 20, 2010 at 6:20 pm
    Aug 20, 2010 at 6:25 pm
  • hi all: if i create a new partition, like 'ALTER TABLE page_view ADD PARTITION (dt='2008-08-08') location '/path/to/us/part080808 ' '; i don't know the key word 'location' means location file system ...
    T liuT liu
    Aug 19, 2010 at 9:27 am
    Aug 19, 2010 at 3:35 pm
Group Navigation
period‹ prev | Aug 2010 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions91
posts278
users75
websitehive.apache.org

75 users for August 2010

Edward Capriolo: 27 posts Lei liu: 27 posts Ning Zhang: 15 posts John Sichi: 13 posts Ronak Bhatt: 12 posts Shangan: 11 posts Carl Steinbach: 10 posts Namit Jain: 10 posts Leo Alekseyev: 8 posts Adarsh Sharma: 5 posts Neil Xu: 5 posts Steven Wong: 5 posts Alexey Kovyrin: 4 posts Ashish Thusoo: 4 posts Bakshi, Ankita: 4 posts Bennie Schut: 4 posts Luke Crouch: 4 posts SingoWong: 4 posts T liu: 4 posts Yongqiang he: 4 posts
show more
Archives