[jira] Created: (HIVE-731) Hive Server getSchema() returns null schema properties

2009-08-06 Thread Eric Hwang (JIRA)
Hive Server getSchema() returns null schema properties -- Key: HIVE-731 URL: https://issues.apache.org/jira/browse/HIVE-731 Project: Hadoop Hive Issue Type: Bug Reporter: Eric

[jira] Commented: (HIVE-723) output columns should be redundant if an insert immediately follows

2009-08-06 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-723?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12739915#action_12739915 ] Zheng Shao commented on HIVE-723: - A second thought on this: If this feature is in, and the

[jira] Created: (HIVE-732) Hive to use LazyBinarySerDe

2009-08-06 Thread Zheng Shao (JIRA)
Hive to use LazyBinarySerDe --- Key: HIVE-732 URL: https://issues.apache.org/jira/browse/HIVE-732 Project: Hadoop Hive Issue Type: New Feature Components: Query Processor Reporter: Zheng Shao

[jira] Updated: (HIVE-732) Hive to use LazyBinarySerDe

2009-08-06 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zheng Shao updated HIVE-732: Attachment: HIVE-732.1.patch HIVE-732.1.patch does the job. Please note that this for code review purpose -

[jira] Created: (HIVE-733) allow specifying maximum number of serde exceptions to ignore

2009-08-06 Thread Zheng Shao (JIRA)
allow specifying maximum number of serde exceptions to ignore - Key: HIVE-733 URL: https://issues.apache.org/jira/browse/HIVE-733 Project: Hadoop Hive Issue Type: New Feature

[jira] Updated: (HIVE-733) allow specifying maximum number of serde exceptions to ignore

2009-08-06 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-733?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zheng Shao updated HIVE-733: Attachment: HIVE-733.1.patch HIVE-733.1.patch: This patch shows the idea. There is no test yet. Please

[jira] Commented: (HIVE-733) allow specifying maximum number of serde exceptions to ignore

2009-08-06 Thread Andraz Tori (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-733?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12739931#action_12739931 ] Andraz Tori commented on HIVE-733: -- +1 this makes sense, I'd set the default to larger

[jira] Updated: (HIVE-578) Refactor partition pruning code as an optimizer transformation

2009-08-06 Thread Ashish Thusoo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-578?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashish Thusoo updated HIVE-578: --- Attachment: patch-578_2.txt New patch with tests and changes. Refactor partition pruning code as an

[jira] Commented: (HIVE-578) Refactor partition pruning code as an optimizer transformation

2009-08-06 Thread Ashish Thusoo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12739946#action_12739946 ] Ashish Thusoo commented on HIVE-578: @Namit 1. I have added a bunch of tests with the new

[jira] Commented: (HIVE-679) Integrate JDBC driver with SQuirrelSQL for querying

2009-08-06 Thread Ashish Thusoo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12739952#action_12739952 ] Ashish Thusoo commented on HIVE-679: Looks good from the first pass. I am going to look

[jira] Updated: (HIVE-643) Hive to recognized escaped strings

2009-08-06 Thread Ashish Thusoo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-643?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashish Thusoo updated HIVE-643: --- Assignee: Emil Ibrishimov Hive to recognized escaped strings --

[jira] Commented: (HIVE-643) Hive to recognized escaped strings

2009-08-06 Thread Ashish Thusoo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-643?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12739955#action_12739955 ] Ashish Thusoo commented on HIVE-643: This seems to have been checked in. Namit can you

[jira] Commented: (HIVE-471) A UDF for simple reflection

2009-08-06 Thread Ashish Thusoo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12739965#action_12739965 ] Ashish Thusoo commented on HIVE-471: Sorry in the delay in responding. Zheng would be

[jira] Commented: (HIVE-645) A UDF that can export data to JDBC databases.

2009-08-06 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-645?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740064#action_12740064 ] Edward Capriolo commented on HIVE-645: -- @Ashish, I see your logic on this. My thinking

[jira] Commented: (HIVE-454) Support escaping of ; in strings in cli

2009-08-06 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740073#action_12740073 ] Edward Capriolo commented on HIVE-454: -- Digging into this some more it seems that the

[jira] Commented: (HIVE-344) Fix the Hive CLI to run on cygwin under windows

2009-08-06 Thread Ashish Thusoo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-344?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740106#action_12740106 ] Ashish Thusoo commented on HIVE-344: The first tests seem to be ok. Will do a bit more

[jira] Commented: (HIVE-721) Integration with HadoopDB

2009-08-06 Thread Azza Abouzeid (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-721?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740139#action_12740139 ] Azza Abouzeid commented on HIVE-721: BTW: we checked out code from the trunk around July

[jira] Updated: (HIVE-713) Integrate operator counters into query plan to view progress of queries

2009-08-06 Thread Raghotham Murthy (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-713?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Raghotham Murthy updated HIVE-713: -- Attachment: hive-713.3.patch Could not get TBinaryProtocol/TMemoryBuffer combination to work

[jira] Commented: (HIVE-578) Refactor partition pruning code as an optimizer transformation

2009-08-06 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740181#action_12740181 ] Zheng Shao commented on HIVE-578: - We should add a separate parameter to enable the new

[jira] Commented: (HIVE-713) Integrate operator counters into query plan to view progress of queries

2009-08-06 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-713?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740182#action_12740182 ] Edward Capriolo commented on HIVE-713: -- I am looking to get some hive-jmx integeration

[jira] Commented: (HIVE-713) Integrate operator counters into query plan to view progress of queries

2009-08-06 Thread Raghotham Murthy (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-713?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740197#action_12740197 ] Raghotham Murthy commented on HIVE-713: --- I am not very familiar with JMX, but it seems

[jira] Commented: (HIVE-713) Integrate operator counters into query plan to view progress of queries

2009-08-06 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-713?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740207#action_12740207 ] Edward Capriolo commented on HIVE-713: -- True. If we were able to implement JMX we could

[jira] Commented: (HIVE-729) select expression with optional as

2009-08-06 Thread Raghotham Murthy (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740212#action_12740212 ] Raghotham Murthy commented on HIVE-729: --- looks good. will commit if tests pass.

[jira] Commented: (HIVE-729) select expression with optional as

2009-08-06 Thread Raghotham Murthy (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740235#action_12740235 ] Raghotham Murthy commented on HIVE-729: --- there was one test failure: [junit] diff

[jira] Commented: (HIVE-713) Integrate operator counters into query plan to view progress of queries

2009-08-06 Thread Raghotham Murthy (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-713?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740238#action_12740238 ] Raghotham Murthy commented on HIVE-713: --- Some tests are failing with the latest patch.

[jira] Commented: (HIVE-729) select expression with optional as

2009-08-06 Thread Ashish Thusoo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740242#action_12740242 ] Ashish Thusoo commented on HIVE-729: I think it is safe to change this test. Since the

[jira] Updated: (HIVE-454) Support escaping of ; in strings in cli

2009-08-06 Thread Ashish Thusoo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashish Thusoo updated HIVE-454: --- Assignee: Edward Capriolo (was: Ashish Thusoo) Ownership = Patch submitter... Support escaping of ;

[jira] Created: (HIVE-734) problem in dealing with null

2009-08-06 Thread Zheng Shao (JIRA)
problem in dealing with null Key: HIVE-734 URL: https://issues.apache.org/jira/browse/HIVE-734 Project: Hadoop Hive Issue Type: Bug Reporter: Zheng Shao Assignee: Ning Zhang This

[jira] Commented: (HIVE-734) problem in dealing with null

2009-08-06 Thread Ashish Thusoo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740257#action_12740257 ] Ashish Thusoo commented on HIVE-734: select null from null from zshao_tt ?? or is it

[jira] Updated: (HIVE-734) problem in dealing with null

2009-08-06 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-734?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zheng Shao updated HIVE-734: Description: This command fails with the following error: {code} hive/bin/hive -e INSERT OVERWRITE LOCAL

[jira] Commented: (HIVE-734) problem in dealing with null

2009-08-06 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740258#action_12740258 ] Zheng Shao commented on HIVE-734: - corrected. it's select null from zshao_tt problem in

[jira] Updated: (HIVE-729) select expression with optional as

2009-08-06 Thread Ashish Thusoo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-729?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashish Thusoo updated HIVE-729: --- Attachment: HIVE-729.2.patch Uploaded patch with the fixed test case. select expression with

[jira] Commented: (HIVE-729) select expression with optional as

2009-08-06 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740267#action_12740267 ] Namit Jain commented on HIVE-729: - I agree - the test output can be changed +1 select

[jira] Commented: (HIVE-734) problem in dealing with null

2009-08-06 Thread Ning Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740277#action_12740277 ] Ning Zhang commented on HIVE-734: - Thanks guys! I figured that out too. Debugging now.

[jira] Commented: (HIVE-645) A UDF that can export data to JDBC databases.

2009-08-06 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-645?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740279#action_12740279 ] Namit Jain commented on HIVE-645: - I think it can have very serious side-affects. What is

[jira] Updated: (HIVE-643) Hive to recognized escaped strings

2009-08-06 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-643?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-643: Resolution: Fixed Hadoop Flags: [Reviewed] Status: Resolved (was: Patch Available)

[jira] Commented: (HIVE-733) allow specifying maximum number of serde exceptions to ignore

2009-08-06 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-733?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740284#action_12740284 ] Namit Jain commented on HIVE-733: - The parameter makes complete sense - in fact, traditional

[jira] Commented: (HIVE-732) Hive to use LazyBinarySerDe

2009-08-06 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740287#action_12740287 ] Namit Jain commented on HIVE-732: - Instead of supporting: CREATE TABLE xxx (...) ROW FORMAT

[jira] Updated: (HIVE-578) Refactor partition pruning code as an optimizer transformation

2009-08-06 Thread Ashish Thusoo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-578?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashish Thusoo updated HIVE-578: --- Attachment: patch-578_3.txt New patch where the ppr is controlled by a boolean parameter. It kicks in

[jira] Updated: (HIVE-729) select expression with optional as

2009-08-06 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-729?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-729: Resolution: Fixed Hadoop Flags: [Reviewed] Status: Resolved (was: Patch Available)

[jira] Resolved: (HIVE-218) predicate on partitioning column is ignored in many places

2009-08-06 Thread Ashish Thusoo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-218?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashish Thusoo resolved HIVE-218. Resolution: Duplicate Duplicate of HIVE-578 predicate on partitioning column is ignored in many

[jira] Commented: (HIVE-645) A UDF that can export data to JDBC databases.

2009-08-06 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-645?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740312#action_12740312 ] Edward Capriolo commented on HIVE-645: -- My jiras got a lot of attention today. I feel

[VOTE] Branching and releasing for 0.4.0

2009-08-06 Thread Ashish Thusoo
Hi Folks, The following is a proposed schedule for 0.4.0 branching. Please vote on it by tomorrow and say whether you are ok with it or not. 8/7/2009 - Branch out 0.4.0 (branching to happen by mid night) 8/14/2009 - Code freeze on 0.4.0 8/28/2009 - Release 0.4.0 Thanks, Ashish

[jira] Updated: (HIVE-431) Auto-add table property select to be the select statement that created the table

2009-08-06 Thread Adam Kramer (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-431?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Kramer updated HIVE-431: - Description: A syntactic copy of the query that was used to fill a table would often be AMAZINGLY useful

[jira] Commented: (HIVE-431) Auto-add table property select to be the select statement that created the table

2009-08-06 Thread Adam Kramer (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-431?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740329#action_12740329 ] Adam Kramer commented on HIVE-431: -- Another note: This isn't done or represented in normal

[jira] Commented: (HIVE-734) problem in dealing with null

2009-08-06 Thread Ning Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740353#action_12740353 ] Ning Zhang commented on HIVE-734: - The error is threw during semantic analysis where the

[jira] Commented: (HIVE-734) problem in dealing with null

2009-08-06 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740358#action_12740358 ] Zheng Shao commented on HIVE-734: - +1 on the idea. We have WritableVoidObjectInspector,

[jira] Commented: (HIVE-187) ODBC driver

2009-08-06 Thread Eric Hwang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-187?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740377#action_12740377 ] Eric Hwang commented on HIVE-187: - I have added a wiki page documenting the Hive ODBC Driver.

[jira] Commented: (HIVE-734) problem in dealing with null

2009-08-06 Thread Ning Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740388#action_12740388 ] Ning Zhang commented on HIVE-734: - Thanks for the pointer Zheng. We certainly can use

[jira] Commented: (HIVE-732) Hive to use LazyBinarySerDe

2009-08-06 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740389#action_12740389 ] Zheng Shao commented on HIVE-732: - ROW FORMAT BINARY is just a shortcut to ROW FORMAT SERDE

[jira] Commented: (HIVE-734) problem in dealing with null

2009-08-06 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740392#action_12740392 ] Zheng Shao commented on HIVE-734: - We do handle NULL in the WHERE clause and AND, OR

[jira] Created: (HIVE-736) MetaStoreUtils get_fields() does not return partition column

2009-08-06 Thread Eric Hwang (JIRA)
MetaStoreUtils get_fields() does not return partition column Key: HIVE-736 URL: https://issues.apache.org/jira/browse/HIVE-736 Project: Hadoop Hive Issue Type: Bug

[jira] Commented: (HIVE-736) MetaStoreUtils get_fields() does not return partition column

2009-08-06 Thread Raghotham Murthy (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-736?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740404#action_12740404 ] Raghotham Murthy commented on HIVE-736: --- As a work around, can you execute describe

[jira] Commented: (HIVE-734) problem in dealing with null

2009-08-06 Thread Ning Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740406#action_12740406 ] Ning Zhang commented on HIVE-734: - I wasn't able to get an example in HIVE. I tried to insert

[jira] Commented: (HIVE-736) MetaStoreUtils get_fields() does not return partition column

2009-08-06 Thread Eric Hwang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-736?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740407#action_12740407 ] Eric Hwang commented on HIVE-736: - That would work, but I was hoping to solve both this and

[jira] Commented: (HIVE-736) MetaStoreUtils get_fields() does not return partition column

2009-08-06 Thread Eric Hwang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-736?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740414#action_12740414 ] Eric Hwang commented on HIVE-736: - Actually I just talked to Zheng offline and I guess the

[jira] Commented: (HIVE-679) Integrate JDBC driver with SQuirrelSQL for querying

2009-08-06 Thread Bill Graham (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740418#action_12740418 ] Bill Graham commented on HIVE-679: -- I'd think the database version should be the version of