Hive > user > December 2008

Hi, Is Hive capable of indexing the data and storing them in a way optimized for querying (like a columnar database - bitmap indexes, compression, etc.)? I need to be able to get decent response ...

Whatever happened to the compressed storage format? I'd like to keep delimited files in bz2 if possible to save on space, is that sort of thing being considered? Josh

This Query INSERT OVERWRITE TABLE aggregations PARTITION ( account='80c27664- b047-4c0a-86f3-342c0cdf36c7', application='myproduct', dataset='purchase', hour=341165, aggregation='count', ...

When launching off hive queries using hive -e is there a way to get the job id so that I can just queue them up and go check their statuses later? What's the general pattern for queueing and ...

Does anyone have an example of how to setup the hive config file to keep schema information in something other than derby so that multiple users and machines can access it at once? Josh

Hi. I find IRC to be a very convenient way to communicate with others interested in an open source project. Would people be interested in joining ##hive on irc.freenode.net? This is the IRC network ...

Hi, I'm just getting started with Hive. I was wondering if anyone can tell me how Hive would translate the following SQL query into MapReduce: select distinct track, count(track) from music where ...

I'm getting a bunch of errors during my reduce step while doing a join between two string fields for some reason. java.lang.RuntimeException: Hive 2 Internal error: cannot evaluate index expression ...

We store a lot of data in SequenceFiles with the key and value as generated Jute/RecordIO files and would want to process it all using Hive. I noticed that there is a serde/jute package, but I assume ...

I am new to Hive. I am using Hadoop 0.19.0 and am running the version of Hive packaged with it under contrib/hive. I am following the apache access log example in the Hive user guide Wiki: ...

FROM hive_test INSERT OVERWRITE TABLE domain_compute SELECT hive_test.domain, COUNT(DISTINCT hive_test.id) GROUP BY hive_test.domain INSERT OVERWRITE LOCAL DIRECTORY '/tmp/hive_test2' SELECT ...

Hi, I have the standard Hadoop vmware image installed (I think it contains hadoop 0.18). I checked out and run hive based on the instructions on your wiki. I created a simple table containing 7 ...

I filed this JIRA issue. I was wondering, can someone take the time to update the wiki to describe the complete architecture of the system as outlined here?: ...

yes, it can. But when I write my script to extract the domain, it hangs all the time ,also there is no job page in the job monitor!But it occurs in the cli that: *hive FROM (FROM log_stg2 log SELECT ...

hive LOAD DATA INPATH 'hdfs://xx-mapred000.xx01:54310/test/shixing/log' INTO TABLE log_stg4; FAILED: Error in semantic analysis: line 1:17 Path is not legal ...

My table:a just contains field:url And Now I wanna compute each domain of url's pv? and out put insert into a table:b domain pv. Now I didn't know whether the hive support the udf, maybe also I can ...

One more thing, can someone explain to me what metastore_db is and what its significance is, apparently if I run hive from separate places certain instances can find some tables and some can't. I'm ...

Hi all, I'm working on configuring a Hive deployment and looking for some guidance on configuration. In hive-default.xml, there's a hive.default.fileformat that currently defaults to text, but can ...

Did you guys do away with having table_source statements include optional partition clauses? Cause for me it's not working but is listed here: ...

Hive has three date/time types: date, datetime and timestamp. What is their intended (future) purpose and current implementation status?

So say I'm using some ruby code to shell out to hive for data loading such as: hive -e "LOAD ..." What's the preferred method of detecting errors in this situation? Do the failures return some sort ...

Hadoop Fans, I'm happy to announce that Cloudera, in addition to providing commercial support for Hadoop, is now offering a one-day, professional training course for Hadoop. It's open to anyone in ...