[ANNOUNCE] Apache Hive 0.7.1 Released

2011-06-21 Thread Carl Steinbach
The Apache Hive team is pleased to announce the release of Hive 0.7.1. Apache Hive is a data warehouse system for Hadoop that facilitates easy data summarization, ad-hoc querying, and analysis of large datasets stored in Hadoop compatible file systems Hive 0.7.1 is available in both binary and so

[jira] [Commented] (HIVE-2219) Make "alter table drop partition" more efficient

2011-06-21 Thread jirapos...@reviews.apache.org (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13052941#comment-13052941 ] jirapos...@reviews.apache.org commented on HIVE-2219: - ---

A question on how to mark Hive for HCatalog releases

2011-06-21 Thread Alan Gates
All, I have a question of how we should manage marking Hive source code for HCatalog releases. For HCatalog 0.1 we used the the 0.7 version of Hive. But we will get to HCatalog 0.2 before the Hive community gets to 0.8. We have added features to Hive since 0.7 that we need in HCatalog

Review Request: HIVE-2219: Improve efficiency of dropping multiple partitions

2011-06-21 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/941/ --- Review request for hive and Paul Yang. Summary --- Improve the efficiency of

[jira] [Commented] (HIVE-2035) Use block-level merge for RCFile if merging intermediate results are needed

2011-06-21 Thread jirapos...@reviews.apache.org (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13052940#comment-13052940 ] jirapos...@reviews.apache.org commented on HIVE-2035: - ---

Re: Review Request: HIVE-2035 Use block level merge on rcfile if intermediate merge is needed

2011-06-21 Thread Siying Dong
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/935/#review875 --- Can you make sure that in the test cases, the query need the merge step?

[jira] [Updated] (HIVE-2234) HiveCli 'set' command can't handle property values with semicolons

2011-06-21 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2234?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-2234: - Affects Version/s: 0.5.0 0.6.0 0.7.0 > HiveCli 'set'

[jira] [Created] (HIVE-2234) HiveCli 'set' command can't handle property values with semicolons

2011-06-21 Thread Carl Steinbach (JIRA)
HiveCli 'set' command can't handle property values with semicolons -- Key: HIVE-2234 URL: https://issues.apache.org/jira/browse/HIVE-2234 Project: Hive Issue Type: Bug

[jira] [Commented] (HIVE-1360) Allow UDFs to access constant parameter values at compile time

2011-06-21 Thread Esteban Gutierrez (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1360?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13052896#comment-13052896 ] Esteban Gutierrez commented on HIVE-1360: - Working on a patch on this since its a b

[jira] [Updated] (HIVE-2211) Fix a bug caused by HIVE-243

2011-06-21 Thread Ning Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2211?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ning Zhang updated HIVE-2211: - Resolution: Fixed Fix Version/s: 0.8.0 Assignee: Siying Dong Status: Resolved (

[jira] [Updated] (HIVE-2194) Add actions for alter table and alter partition events for metastore event listeners

2011-06-21 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2194?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2194: - Attachment: HIVE-2194.3.patch > Add actions for alter table and alter partition events for metastore event

[jira] [Commented] (HIVE-2194) Add actions for alter table and alter partition events for metastore event listeners

2011-06-21 Thread jirapos...@reviews.apache.org (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2194?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13052805#comment-13052805 ] jirapos...@reviews.apache.org commented on HIVE-2194: - ---

Re: Review Request: HIVE-2194: Add actions to MetaStoreEventListener to be performed on alter table and alter partition operations.

2011-06-21 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/853/ --- (Updated 2011-06-21 20:25:04.600512) Review request for hive and Paul Yang. Cha

[jira] [Assigned] (HIVE-2172) Hive CLI should let you specify database on the command line

2011-06-21 Thread Jakob Homan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2172?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jakob Homan reassigned HIVE-2172: - Assignee: Jakob Homan > Hive CLI should let you specify database on the command line > ---

[jira] [Created] (HIVE-2233) Show current database in hive prompt

2011-06-21 Thread Jakob Homan (JIRA)
Show current database in hive prompt Key: HIVE-2233 URL: https://issues.apache.org/jira/browse/HIVE-2233 Project: Hive Issue Type: Improvement Affects Versions: 0.7.0 Reporter: Jakob Homan

[jira] [Commented] (HIVE-872) Allow type widening on COALESCE/UNION ALL

2011-06-21 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-872?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13052804#comment-13052804 ] John Sichi commented on HIVE-872: - +1 on latest, re-testing. > Allow type widening on COALE

[jira] [Updated] (HIVE-872) Allow type widening on COALESCE/UNION ALL

2011-06-21 Thread Syed S. Albiz (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-872?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Syed S. Albiz updated HIVE-872: --- Status: Patch Available (was: Open) > Allow type widening on COALESCE/UNION ALL >

[jira] [Commented] (HIVE-2211) Fix a bug caused by HIVE-243

2011-06-21 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2211?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13052790#comment-13052790 ] John Sichi commented on HIVE-2211: -- It looks like this has already been committed? Can we

[jira] [Resolved] (HIVE-2033) A database's warehouse.dir is not used for tables created in it.

2011-06-21 Thread Thiruvel Thirumoolan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2033?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thiruvel Thirumoolan resolved HIVE-2033. Resolution: Duplicate Addressing it as part of HIVE-1537. > A database's warehouse.

[jira] [Created] (HIVE-2232) Any query to a partition column should access the metastore and not the data

2011-06-21 Thread Adam Kramer (JIRA)
Any query to a partition column should access the metastore and not the data Key: HIVE-2232 URL: https://issues.apache.org/jira/browse/HIVE-2232 Project: Hive Issue

[jira] [Commented] (HIVE-2231) Column aliases

2011-06-21 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2231?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13052751#comment-13052751 ] John Sichi commented on HIVE-2231: -- Since views are already a standard way of addressing t

[jira] [Created] (HIVE-2231) Column aliases

2011-06-21 Thread Adam Kramer (JIRA)
Column aliases -- Key: HIVE-2231 URL: https://issues.apache.org/jira/browse/HIVE-2231 Project: Hive Issue Type: Wish Components: Query Processor Reporter: Adam Kramer Priority: Trivial It would

[jira] [Updated] (HIVE-1537) Allow users to specify LOCATION in CREATE DATABASE statement

2011-06-21 Thread Thiruvel Thirumoolan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thiruvel Thirumoolan updated HIVE-1537: --- Attachment: HIVE-1537.patch Notable changes: I have moved getDefaultDatabasePath() to

[jira] [Commented] (HIVE-1537) Allow users to specify LOCATION in CREATE DATABASE statement

2011-06-21 Thread Thiruvel Thirumoolan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13052736#comment-13052736 ] Thiruvel Thirumoolan commented on HIVE-1537: Usage: create database location '

[jira] [Commented] (HIVE-2229) Potentially Switch Build to Maven

2011-06-21 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13052729#comment-13052729 ] John Sichi commented on HIVE-2229: -- I'm -0 on this one. We end up needing to do a lot of

[jira] [Commented] (HIVE-306) Support "INSERT [INTO] destination"

2011-06-21 Thread jirapos...@reviews.apache.org (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-306?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13052725#comment-13052725 ] jirapos...@reviews.apache.org commented on HIVE-306: bq. On 2011-06-1

Re: Review Request: HIVE-306 Support INSERT INTO

2011-06-21 Thread Franklin Hu
> On 2011-06-16 18:08:03, Ning Zhang wrote: > > trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g, line 1397 > > > > > > Is that difficult to extend it with INSERT INTO DIRECTORY? We were not sure how widely it wo

[jira] [Commented] (HIVE-2225) Purge expired events

2011-06-21 Thread jirapos...@reviews.apache.org (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2225?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13052695#comment-13052695 ] jirapos...@reviews.apache.org commented on HIVE-2225: - ---

Review Request: Review request for HIVE-2225

2011-06-21 Thread Ashutosh Chauhan
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/940/ --- Review request for hive, Carl Steinbach and John Sichi. Summary --- This add

Re: After submiited the query Hive Server is down need to submit same query again

2011-06-21 Thread Shouguo Li
60 mins seems too long. there are many reason why a task runs slow. you have to supply more info for us to help you, :) how much data is that query crunching through? are you sure hive/hadoop is running on remote mode? is the cluster balanced? what are hive/hadoop configs look like, i.e. mapred.tas

[jira] [Updated] (HIVE-2230) Hive Client build error

2011-06-21 Thread Dmytro Korochkin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmytro Korochkin updated HIVE-2230: --- Description: While running ant {code} ant compile-cpp -Dthrift.home=/usr/local {code} to buil

[jira] [Created] (HIVE-2230) Hive Client build error

2011-06-21 Thread Dmytro Korochkin (JIRA)
Hive Client build error --- Key: HIVE-2230 URL: https://issues.apache.org/jira/browse/HIVE-2230 Project: Hive Issue Type: Bug Components: Clients, ODBC Environment: hive: {code} Path: . URL: http://svn.

[jira] [Created] (HIVE-2229) Potentially Switch Build to Maven

2011-06-21 Thread Ed Kohlwey (JIRA)
Potentially Switch Build to Maven - Key: HIVE-2229 URL: https://issues.apache.org/jira/browse/HIVE-2229 Project: Hive Issue Type: Improvement Reporter: Ed Kohlwey Priority: Minor I wa

After submiited the query Hive Server is down need to submit same query again

2011-06-21 Thread Chinna
Hi all, I am using Hive Server once submitted the query(It will take 60 mins) if Hive Server is down after 50 mins I cannot get the results of the submitted query. In this case I need to submit same query again. In case of CLI also same problem is there.. Any suggestions or any one hand