FAQ

Search Discussions

56 discussions - 244 posts

  • http://bandarjersey.com/wp-content/plugins/akismet/ugoogle.html
    Hiroyuki YamadaHiroyuki Yamada
    Nov 6, 2012 at 4:23 am
    Nov 28, 2012 at 11:19 am
  • Hi, I am having a cluster setup on EC2 with Hadoop version 0.20.2 and Hive version 0.8.1 (I configured everything) . I have created a table using :- CREATE EXTERNAL TABLE XXX ( YYY )PARTITIONED BY ( ...
    Chunky GuptaChunky Gupta
    Nov 5, 2012 at 11:34 am
    Nov 27, 2012 at 11:13 pm
  • Hi Shreepadma, I agree that the error looks odd. However I can't believe that I would have got this far with Hive if there was no derby jar. Nevertheless I checked. Here is a directory listing of the ...
    Peter MarronPeter Marron
    Nov 1, 2012 at 9:32 am
    Nov 23, 2012 at 8:57 am
  • Hi, I had been trying to set up a multi user environment for hive. I have set up the hive metastore db in MySQL and hive works. Consider this scenario: user1 has created a database data1 user2 has ...
    Austin ChungathAustin Chungath
    Nov 22, 2012 at 6:46 am
    Nov 23, 2012 at 6:07 am
  • Hi, I am trying to run a MapJoin query and somehow getting below error. I can see that file is not there in specified directory. Did some debugging but no luck as well. Here is the error: nOperator ...
    Vivek MishraVivek Mishra
    Nov 24, 2012 at 6:22 am
    Nov 28, 2012 at 7:27 am
  • I am working on copying existing Hive metadata (Hive 0.7.1 with MySQL 5.1) to a new cluster environment (Hive 0.7.1 with MySQL 5.5). I copied over the metastore tables and modified the data under SDS ...
    Venkatesh KavuluriVenkatesh Kavuluri
    Nov 5, 2012 at 11:22 pm
    Nov 15, 2012 at 10:46 am
  • Hi, I have 2 tables, T1 and T2 of structure columns= {ID, url, timestamp} In T1 ID's are repeatable. But T2 ID's are kind of primary key hence only unique values are present. I want to join both ...
    Praveen Kumar K J V SPraveen Kumar K J V S
    Nov 9, 2012 at 2:15 am
    Nov 9, 2012 at 5:09 pm
  • Hi there, It seems that some of my jobs hang in the reduce phase for a very long time (for example, days). Is there anything I could tweak on? The query is pretty simple, like: SELECT SUM(colA), ...
    Robin VerlangenRobin Verlangen
    Nov 8, 2012 at 10:33 am
    Nov 9, 2012 at 7:19 am
  • Hi Guys, I wonder if you could help me. I have a huge Hive table partitioned by some field. It has thousands of partitions. Now I have another small table containing tens of partitions id. I'd like ...
    Dima DatsenkoDima Datsenko
    Nov 22, 2012 at 1:57 pm
    Nov 23, 2012 at 1:48 pm
  • Hi Guys, I am planning to use postgres as metastore with Hive. Can anyone point me which is the postgres version is compatible with Hive..? Regards Rohith Sharma K S
    RohithsharmaRohithsharma
    Nov 6, 2012 at 4:29 am
    Nov 7, 2012 at 4:21 am
  • Hello, I'm using Cloudera's CDH4 with Hive 0.9 and Hive Server 2. I am trying to load data into hive using the JDBC driver (the one distributed with Cloudera CDH4 "org.apache.hive.jdbc.HiveDriver". I ...
    YaboulnaYaboulna
    Nov 26, 2012 at 4:07 pm
    Nov 26, 2012 at 10:14 pm
  • Hello, I have copied jar file into /usr/lib/hive/lib folder on all the nodes. I am able to use it on Hive CLI with the command hive --auxpath /usr/lib/hive/lib/<jarfile Then I am able to run my Hive ...
    Sadananda HegdeSadananda Hegde
    Nov 26, 2012 at 6:52 pm
    Nov 26, 2012 at 7:43 pm
  • Hi All, I have a csv file ( separated by |) where data is like id data date 1 apple 24-nov-2011 2 mango 26-nov-2011 3 <?xml version="1.0" encoding="utf-8"? <a fruits</a 28-nov-2011 4 papaya ...
    Iwannaplay gamesIwannaplay games
    Nov 20, 2012 at 8:00 am
    Nov 20, 2012 at 9:04 am
  • Hi, all How does hive decide to launch how many map tasks? I know there are some configs to help hive to decide how many reduce task to launch? But how about map tasks? I thought that number of map ...
    Cheng SuCheng Su
    Nov 16, 2012 at 6:40 am
    Nov 19, 2012 at 9:10 am
  • Hello all! I have a problem with dynamic partitions in hive 0.7.1. For example I have 2 tables: CREATE TABLE table1 (text STRING); CREATE TABLE table2 (text STRING) PARTITIONED BY (author STRING) ...
    Павел МезенцевПавел Мезенцев
    Nov 15, 2012 at 8:15 am
    Nov 16, 2012 at 4:23 pm
  • Hi, all. Can I merge files after I loaded them into hive? This is my situation: There is a log table partitioned by date, which is store the nginx access logs. The raw log files are loaded into hive ...
    Cheng SuCheng Su
    Nov 15, 2012 at 8:04 am
    Nov 15, 2012 at 10:41 am
  • Hi, all. I have a hive+hbase integration cluster. When I try to execute query through the java client of hive, sometimes a ClassNotFoundException happens. My java code : final Connection conn = ...
    Cheng SuCheng Su
    Nov 5, 2012 at 3:05 pm
    Nov 7, 2012 at 1:53 am
  • It seems the customized hive-site.xml is not being read. It lives under $HIVE_HOME/conf ( which happens to be /shared/hive/conf). I have tried everything there is to try: set ...
    Stephen BoeschStephen Boesch
    Nov 24, 2012 at 10:20 pm
    Nov 26, 2012 at 8:11 pm
  • Hi, I have a python script :- -------------------cron_script.py--------------------------- import os import sys from subprocess import call print 'starting' call(['hive', '-f', ...
    Chunky GuptaChunky Gupta
    Nov 22, 2012 at 10:00 am
    Nov 24, 2012 at 1:28 am
  • Hi, I'm trying to create indexes in Hive, and I've switched to using CDH-4. The creation of the index is failing and it's pretty obvious that the reducers are running out of heap space. When I use ...
    Peter MarronPeter Marron
    Nov 23, 2012 at 8:47 am
    Nov 23, 2012 at 9:30 am
  • As a service to everyone on this list, please fill in the "Subject" field when you post to the list, especially if you want the rest of us to read your message. Thank you. dean -- *Dean Wampler, ...
    Dean WamplerDean Wampler
    Nov 22, 2012 at 2:17 pm
    Nov 23, 2012 at 7:13 am
  • Hi, New to hive in last few weeks and could use some help with JOINs. Using MapR (version 0.9.0) /usr/bin/hive - /opt/mapr/hive/hive-0.9.0/bin/hive I have 2 tables I am wanting to join by date ...
    John MorrisonJohn Morrison
    Nov 20, 2012 at 3:43 pm
    Nov 20, 2012 at 6:14 pm
  • bcc: cdh-user This question might be more appropriate for the Apache Hive user list, so redirecting it there. However to answer your question: So the question you are really asking is if Hive ...
    Mark GroverMark Grover
    Nov 13, 2012 at 6:54 pm
    Nov 19, 2012 at 5:30 pm
  • Hi All, I installed HIVE version 0.8.1 on Cigwin. I also installed Hadoop 1.0.4. I have set the JAVA_HOME and HIVE_HOME environment variables. I started HIVE and tried to run a HIVE command but it ...
    R JR J
    Nov 14, 2012 at 10:27 pm
    Nov 14, 2012 at 10:50 pm
  • Hi, I need to build a failover/LB solution for Hive Services. MySQL DB is fine, and can work out. But for Hive Metastore Service, can I simply put the Load Balancer like HA Proxy etc. in between the ...
    Manish MalhotraManish Malhotra
    Nov 8, 2012 at 7:29 am
    Nov 13, 2012 at 6:27 pm
  • Hi all, I'm looking into finding a suitable format to store data in HDFS, so that it's available for processing by Hive. Ideally I would like to satisfy the following: 1. store the data in a format ...
    Krishna RaoKrishna Rao
    Nov 5, 2012 at 3:58 pm
    Nov 6, 2012 at 5:23 pm
  • Hi Folks We are getting inconsistent output when running some semantically same Hive queries. We are using *CDH3u3* with *Hive 0.7.1.* The query I am running performs a map-side join of two ...
    Chen SongChen Song
    Nov 15, 2012 at 4:19 pm
    Dec 20, 2012 at 10:04 am
  • Moving to <span class="m_body_email_addr" title="d98685a90d9543c52703799da3a2508b" user@hive.apache.org</span since this is an Apache Hive related question Hi Ram, Hive doesn't provide a way to do ...
    Mark GroverMark Grover
    Nov 28, 2012 at 4:17 pm
    Nov 28, 2012 at 5:47 pm
  • Hi, In hive I have two tables fst is 'a' and 2nd is 'b'. Now I want to display the data of 'a ' table which is not present in b table. Thnks Manjinder **************** CAUTION - Disclaimer ...
    Manjinder Singh01Manjinder Singh01
    Nov 23, 2012 at 9:03 am
    Nov 23, 2012 at 9:54 am
  • Hi All, Assume we have two time stamp like: 9/15/2002 8:05 and 9/15/2002 9:05 if we need to evaluate the difference of these two time stamp in terms of hours ( or minutes ), how to do that? Hive ...
    QiaoresearcherQiaoresearcher
    Nov 21, 2012 at 11:15 pm
    Nov 22, 2012 at 11:57 am
  • The table format is something like: user_id visiting_time visiting_web_page user1 time11 page_string_11 user1 time12 page_string_12 user1 time13 page_string_13 <-- latest time stamp user1 time14 ...
    QiaoresearcherQiaoresearcher
    Nov 19, 2012 at 9:03 pm
    Nov 19, 2012 at 11:31 pm
  • hi guys, Do I need any Pig knowledge to learn Hive? Or understanding Hadoop will suffice?
    Majid AzimiMajid Azimi
    Nov 16, 2012 at 9:27 am
    Nov 16, 2012 at 1:30 pm
  • Hi all. I'm writing a hive UDAF to calculate page view per session. Java source is blow: ---- public class CalculateAvgPVPerSession extends UDAF { /** * @author Cheng Su * */ public static class ...
    Cheng SuCheng Su
    Nov 13, 2012 at 4:02 am
    Nov 15, 2012 at 8:46 am
  • Since we had two requests today for help on using Hive in Cygwin/Windows, which doesn't work, I wonder if anyone has tried Shark on Windows? Shark is the port of Hive to Spark, which supports a local ...
    Dean WamplerDean Wampler
    Nov 14, 2012 at 11:17 pm
    Nov 15, 2012 at 12:03 am
  • Is it possible to select columns not in the TRANSFORM(...) operation? I did not see anywhere in the language definition for transform. I'm looking for something comparable to LATERAL VIEW for UDTF ...
    Jamie OlsonJamie Olson
    Nov 6, 2012 at 7:33 am
    Nov 7, 2012 at 5:41 pm
  • I have a Yarn MR (with two ec2 instances to mapreduce) job on a dataset of approximately a thousand avro records, and the map phase is behaving erratically. See the progress below What is going on ...
    Alexandre FoucheAlexandre Fouche
    Nov 7, 2012 at 11:30 am
    Nov 7, 2012 at 11:39 am
  • hi all: now, I'm map to an existed hbase table, i got the following infomation as: FAILED: Error in metadata: MetaException(message:Column Family data is not defined in hbase table df_money_files) ...
    Chris GongChris Gong
    Nov 6, 2012 at 2:57 am
    Nov 7, 2012 at 3:18 am
  • *Note that some care is necessary in using predefined character classes: using '\s' as the second argument will match the letter s; ' s' is necessary to match whitespace, etc. The 'index' parameter ...
    Neil KodnerNeil Kodner
    Nov 1, 2012 at 2:06 pm
    Nov 1, 2012 at 7:12 pm
  • I have a table defined as: CREATE TABLE foo ( id INT, start_time STRING, name STRING, value STRING, type STRING ) The 'name', 'value' and 'type' fields actually describe another object, and I'd like ...
    Brad CavanaghBrad Cavanagh
    Nov 28, 2012 at 6:30 pm
    Nov 28, 2012 at 6:35 pm
  • Hi , I want to know if HIVE supports NOT IN / IN clauses like oracle and other databases support. If it's not then do we have any alternative . Query is Main query Where col name NOT IN (subquery) ...
    Venugopal KrishnanVenugopal Krishnan
    Nov 28, 2012 at 6:18 am
    Nov 28, 2012 at 6:48 am
  • Dear all, I want to run java code on top of hadoop on ubuntu server , do anyone know the commands??
    Dalia SobhyDalia Sobhy
    Nov 24, 2012 at 9:20 pm
    Nov 25, 2012 at 12:58 am
  • Hi, all. I am running some hive queries. I use hive 0.9.0 + hadoop 0.20.205.0 But some of them are pending for quite a long time, say 30min or even longer. I have enough free map slots. In the ...
    Cheng SuCheng Su
    Nov 16, 2012 at 9:00 am
    Nov 16, 2012 at 9:52 am
  • Hi, I am doing a query with multiple INSERT OVERWRITE to multiple tables, in order to scan the dataset only 1 time, and i end up having all these tables with the same content ! It seems the GROUP BY ...
    Alexandre FoucheAlexandre Fouche
    Nov 6, 2012 at 8:40 pm
    Nov 10, 2012 at 9:51 am
  • Hi, all. I have a hive + hbase integration cluster. I met a performance issue. I executed some complicated hql, but only the first one is actually running. The rests are showed "running" on the job ...
    Cheng SuCheng Su
    Nov 7, 2012 at 3:08 am
    Nov 7, 2012 at 6:24 am
  • Hi I want to integrate apache-Hive (0.9) and apache-Cassandra(1.1) for BI/Analytics. It seems there was a SerDe for Hive-Cassandra in apache hive 0.8.1 ...
    Shrikant BangShrikant Bang
    Nov 1, 2012 at 10:29 am
    Nov 5, 2012 at 6:06 am
  • The table format is something like: user_id visiting_time visiting_web_page user1 time11 page_string_11 user1 time12 page_string_12 with keyword 'abc' user1 time13 page_string_13 user1 time14 ...
    QiaoresearcherQiaoresearcher
    Nov 3, 2012 at 3:36 am
    Nov 3, 2012 at 11:49 pm
  • Sorry to ask what is probably a very naïve Hive question but here goes: I have a table as follows: Col1 Col2 K1 V1 K1 V1 K2 V1 K3 V1 K1 V2 K1 V3 K2 V2 Now I have managed to SELECT Col1,COUNT(DISTINCT ...
    Ratner, Alan S (IS)Ratner, Alan S (IS)
    Nov 1, 2012 at 6:27 pm
    Nov 2, 2012 at 3:17 am
  • Hi, Is it possible running hive against hadoop 1.0.4? I was checking out the trunk from svn, and running "ant clean package " fails, looks like it's looking for 0.20.0 libraries. Is there some ...
    Barak YaishBarak Yaish
    Nov 28, 2012 at 10:53 pm
    Nov 28, 2012 at 10:53 pm
  • Hi Hive Users, I have a table-A which has ID, ZIP, VALUE. I want to get something like this [ for each ZIP, how many IDs have VALUE < 10, < 20 ...] : ZIP < 10 < 20 < 30 < 40 < 50 12333 2 3 6 8 10 ...
    Periya.DataPeriya.Data
    Nov 28, 2012 at 8:37 pm
    Nov 28, 2012 at 8:37 pm
  • Adding subject
    Mark GroverMark Grover
    Nov 28, 2012 at 4:32 pm
    Nov 28, 2012 at 4:32 pm
Group Navigation
period‹ prev | Nov 2012 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions56
posts244
users72
websitehive.apache.org

72 users for November 2012

Mark Grover: 23 posts Dean Wampler: 15 posts Cheng Su: 14 posts Edward Capriolo: 14 posts Bejoy KS: 11 posts Chunky Gupta: 9 posts Nitin Pawar: 9 posts Peter Marron: 7 posts Alexander Lorenz: 6 posts Austin Chungath: 6 posts imen Megdiche: 6 posts Mohammad Tariq: 6 posts Connell, Chuck: 5 posts Shreepadma Venugopalan: 5 posts Vivek Mishra: 5 posts Alexandre Fouche: 4 posts Dalia Sobhy: 4 posts Praveen Kumar K J V S: 4 posts Qiaoresearcher: 4 posts Robin Verlangen: 4 posts
show more
Archives