Hive > user > June 2009

Hi all, we had a query joining two tables, one of which had about 1 billions pieces of records while the other had less than 20k. below is our query: set hive.mapjoin.cache.numrows=20000; select /*+ ...

Hi all, Any helps? thanks, Min -- My research interests are distributed systems, parallel computing and bytecode based virtual machine. My profile: http://www.linkedin.com/in/coderplay My blog: ...

Hi, I am new to Hive. I would like to know what is the easiest way to get the difference between two sets. For example, how can I convert the following SQL query to Hive? select user from page_views ...

I'm trying to build a tool which runs a query and writes the results into an automatically generated Hive table. It's all very straightforward, except that I can't find a good way to determine the ...

We get this error when having ³cast (tablename.properties['time'] as int)/3600.0² in the select clause of a hive query (with join). Is this a known problem/limitation? BTW, this only happens when ...

We have a requirement to write an udf returning map/list values. pseudo code of this udf like below public class MyUDF extends UDF { public Map<?,? evaluate(String lhs, String rhs) { ... } } will it ...

I have a query like below, SELECT a.subid, a.id, t.url FROM tbl t JOIN aux_tbl a ON t.url rlike a.url_pattern WHERE t.dt='20090609' AND a.dt='20090609'; and parser reported 'FAILED: Error in semantic ...

Hi all, Yuntao Jia, our intern this summer, did a simple performance benchmark for Hadoop, Hive and Pig based on the queries in the SIGMOD 2009 paper: A Comparison of Approaches to Large-Scale Data ...

I am using a Hive instance using MySQL as the meta-data store. The cluster works fine in command line mode. The problem I am having is that when I attempt to connect using the Hive JDBC connector I ...

Hi all, How can generate plan files like those .q.xml files exist in ql/src/test/results/compiler/plan/** for checking my plan? Thanks, Min -- My research interests are distributed systems, parallel ...

trying to run the following query: insert overwrite table imp_test3 partition(ds="20090513") select d["query_string"] from imp where imp.ds="20090513" and imp.hour="00"; causes all of the tasks in ...

We are using hive 0.3.0 and are getting the following when joining on Integer fields. We are also getting a very similar problem using the case UDF is this a known problem? java.io.IOException: ...

Hi guys, Driver.getSchema() obtains current result's tableDesc and assemble it to a String. I found if do select all queries on a table contains partitions, a null pointer exception will happens. See ...

Hi, I have this error * FAILED: Unknown exception : Wrong FS: hdfs:// 10.1.1.3:9000/tmp/hive-hadoop/1201106067, expected: hdfs://slave:9000* when i tried to do select statement in hive. I have loaded ...

Hi, For the second time in two weeks I'm getting errors that blocks that once existed have gone missing from HDFS and I'm baffled as to the cause, or even how to troubleshoot the issue. Any help ...

Most probably metastore died. What were you doing when this happened and also what is the log on metastore side? Prasad from bberry ----- Original Message ----- From: Bill Craig <bcraig7@gmail.com ...

Hi, I've been testing the Hive JDBC client and I think I've come a across a few bugs, but I wanted to double check my understanding of the expected behavior before opening JIRAs. I'm running the hive ...

We have several openings for engineers who can help us build a data warehouse on top of hadoop + hive. We've been running a 30 node cluster for the past year using streaming and cascading and are now ...

Bay Area Hadoop Fans, We're excited to hold our first Hadoop User Group at Cloudera's office in Burlingame (just south of SFO). We pushed the start time back 30 minutes to allow a little extra time ...

Hi facebook guys, Can you synchronise your fb303 thrift code? $thrift -gen java -I metastore/include -I . service/if/hive_service.thrift ...

I've been able to piece together a rough guide for implementation from various blogs / jiras, but does anyone have a basic example publicly available? There are stubs in the wiki but unfortunately ...

Some progress on getting JDBC to work with Hive using MySQL. The problem was: [java] 09/06/02 08:31:33 INFO metastore.ObjectStore: jpox.properties not found. The jpox default for NontransactionalRead ...

Hadoop Fans, I'm happy to announce a new tool from the Cloudera team. We often found our customers wanting to import data from RDBMSs so they could conduct deeper analysis. To facilitate this, we ...