[jira] [Commented] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-03-22 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14375082#comment-14375082 ] Aihua Xu commented on HIVE-3454: This error is unrelated to the change and seems random.

[jira] [Commented] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-03-16 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14363355#comment-14363355 ] Aihua Xu commented on HIVE-3454: Thanks [~jdere]. We need to correct

[jira] [Commented] (HIVE-7018) Table and Partition tables have column LINK_TARGET_ID in Mysql scripts but not others

2015-03-17 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14365141#comment-14365141 ] Aihua Xu commented on HIVE-7018: I think it's just removing the ending ',' , not removing

[jira] [Updated] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-03-20 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-3454: --- Attachment: (was: HIVE-3454.3.patch) Problem with CAST(BIGINT as TIMESTAMP)

[jira] [Updated] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-03-20 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-3454: --- Attachment: HIVE-3454.3.patch Problem with CAST(BIGINT as TIMESTAMP) --

[jira] [Updated] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-03-20 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-3454: --- Attachment: HIVE-3454.3.patch Made additional changes to vectorized functions and unit tests. Problem with

[jira] [Updated] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-03-20 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-3454: --- Attachment: (was: HIVE-3454.3.patch) Problem with CAST(BIGINT as TIMESTAMP)

[jira] [Updated] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-03-21 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-3454: --- Attachment: HIVE-3454.3.patch Problem with CAST(BIGINT as TIMESTAMP) --

[jira] [Updated] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-03-21 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-3454: --- Attachment: (was: HIVE-3454.3.patch) Problem with CAST(BIGINT as TIMESTAMP)

[jira] [Commented] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-03-21 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14372840#comment-14372840 ] Aihua Xu commented on HIVE-3454: Attached should be the right patch now. Maybe I uploaded

[jira] [Updated] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-03-21 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-3454: --- Attachment: (was: HIVE-3454.3.patch) Problem with CAST(BIGINT as TIMESTAMP)

[jira] [Updated] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-03-21 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-3454: --- Attachment: HIVE-3454.3.patch Problem with CAST(BIGINT as TIMESTAMP) --

[jira] [Commented] (HIVE-7018) Table and Partition tables have column LINK_TARGET_ID in Mysql scripts but not others

2015-03-16 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14363764#comment-14363764 ] Aihua Xu commented on HIVE-7018: +1. Looks good to me. The code is not used and causes

[jira] [Commented] (HIVE-8789) UT: fix udf_context_aware

2015-03-16 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14363779#comment-14363779 ] Aihua Xu commented on HIVE-8789: Seems the query we are executing will not start a MR/spark

[jira] [Commented] (HIVE-9537) string expressions on a fixed length character do not preserve trailing spaces

2015-03-09 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14353274#comment-14353274 ] Aihua Xu commented on HIVE-9537: HIVE-9899 doc bug is opened to keep track of the doc

[jira] [Assigned] (HIVE-8789) UT: fix udf_context_aware

2015-03-09 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu reassigned HIVE-8789: -- Assignee: Aihua Xu UT: fix udf_context_aware -- Key:

[jira] [Resolved] (HIVE-9537) string expressions on a fixed length character do not preserve trailing spaces

2015-03-09 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu resolved HIVE-9537. Resolution: Not a Problem string expressions on a fixed length character do not preserve trailing spaces

[jira] [Updated] (HIVE-9917) After HIVE-3454 is done, make int to timestamp conversion configurable

2015-03-12 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9917?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-9917: --- Release Note: With the change of HIVE-9917, we support an additional configuration

[jira] [Commented] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-03-12 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14359406#comment-14359406 ] Aihua Xu commented on HIVE-3454: Yes. That's right. That patch is to change in the correct

[jira] [Updated] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-03-12 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-3454: --- Attachment: (was: HIVE-3454.2.patch) Problem with CAST(BIGINT as TIMESTAMP)

[jira] [Commented] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-03-10 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14355763#comment-14355763 ] Aihua Xu commented on HIVE-3454: I'm looking into the solution [~hagleitn] suggested. I

[jira] [Updated] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-03-10 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-3454: --- Attachment: (was: HIVE-3454.4.patch) Problem with CAST(BIGINT as TIMESTAMP)

[jira] [Updated] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-03-11 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-3454: --- Release Note: The behaviors of converting from BOOLEAN/TINYINT/SMALLINT/INT/BIGINT and converting from

[jira] [Updated] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-03-12 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-3454: --- Release Note: The behaviors of converting from BOOLEAN/TINYINT/SMALLINT/INT/BIGINT and converting from

[jira] [Updated] (HIVE-10085) Lateral view on top of a view throws RuntimeException

2015-03-25 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10085?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-10085: Attachment: HIVE-10085.patch When the sizes RowSchema and the columns after pruning are the same, right

[jira] [Commented] (HIVE-10085) Lateral view on top of a view throws RuntimeException

2015-03-25 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10085?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14380529#comment-14380529 ] Aihua Xu commented on HIVE-10085: - [~ashutoshc] Seems you have worked on this. Can you

[jira] [Commented] (HIVE-10085) Lateral view on top of a view throws RuntimeException

2015-03-25 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10085?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14380625#comment-14380625 ] Aihua Xu commented on HIVE-10085: - RB entry: https://reviews.apache.org/r/32491/ Lateral

[jira] [Commented] (HIVE-10085) Lateral view on top of a view throws RuntimeException

2015-03-25 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10085?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14380733#comment-14380733 ] Aihua Xu commented on HIVE-10085: - Please try again. First time to use the rbt tool. Seems

[jira] [Commented] (HIVE-10096) Investigate the random failure of TestCliDriver.testCliDriver_udaf_percentile_approx_23

2015-04-01 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10096?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14390577#comment-14390577 ] Aihua Xu commented on HIVE-10096: - Thanks Alexander. Didn't know you already had one to

[jira] [Updated] (HIVE-10085) Lateral view on top of a view throws RuntimeException

2015-03-26 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10085?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-10085: Attachment: HIVE-10085.patch Fixed some unit tests baseline. The failure from other 2 unit tests seems

[jira] [Updated] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-03-02 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-3454: --- Attachment: (was: HIVE-3454.4.patch) Problem with CAST(BIGINT as TIMESTAMP)

[jira] [Commented] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-03-03 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14345766#comment-14345766 ] Aihua Xu commented on HIVE-3454: [~jdere] Can you review the latest patch? Right now it

[jira] [Commented] (HIVE-9580) Server returns incorrect result from JOIN ON VARCHAR columns

2015-03-04 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14347507#comment-14347507 ] Aihua Xu commented on HIVE-9580: The issue is caused by: we always assume that the join

[jira] [Commented] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-03-04 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14348023#comment-14348023 ] Aihua Xu commented on HIVE-3454: Of course, since we need to support LLAP, UDF approach

[jira] [Commented] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-03-04 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14347905#comment-14347905 ] Aihua Xu commented on HIVE-3454: I agree that for non thread-safe statics, it will cause

[jira] [Commented] (HIVE-9580) Server returns incorrect result from JOIN ON VARCHAR columns

2015-03-04 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14347729#comment-14347729 ] Aihua Xu commented on HIVE-9580: Seems Hive can handle the join over any kind of data

[jira] [Assigned] (HIVE-10093) Unnecessary HMSHandler initialization for default MemoryTokenStore on HS2

2015-03-26 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10093?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu reassigned HIVE-10093: --- Assignee: Aihua Xu Unnecessary HMSHandler initialization for default MemoryTokenStore on HS2

[jira] [Commented] (HIVE-10093) Unnecessary HMSHandler initialization for default MemoryTokenStore on HS2

2015-03-26 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10093?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14382418#comment-14382418 ] Aihua Xu commented on HIVE-10093: - I will work on that. Unnecessary HMSHandler

[jira] [Commented] (HIVE-10093) Unnecessary HMSHandler initialization for default MemoryTokenStore on HS2

2015-03-26 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10093?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14382771#comment-14382771 ] Aihua Xu commented on HIVE-10093: - RB: https://reviews.apache.org/r/32551/ Unnecessary

[jira] [Commented] (HIVE-10093) Unnecessary HMSHandler initialization for default MemoryTokenStore on HS2

2015-03-26 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10093?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14382727#comment-14382727 ] Aihua Xu commented on HIVE-10093: - [~szehon] Can you take a look at the change?

[jira] [Assigned] (HIVE-10096) Investigate the random failure of TestCliDriver.testCliDriver_udaf_percentile_approx_23

2015-03-26 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10096?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu reassigned HIVE-10096: --- Assignee: Aihua Xu Investigate the random failure of

[jira] [Commented] (HIVE-10085) Lateral view on top of a view throws RuntimeException

2015-03-26 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10085?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14383171#comment-14383171 ] Aihua Xu commented on HIVE-10085: - This unit test failure seems unrelated. Lateral view

[jira] [Updated] (HIVE-10093) Unnecessary HMSHandler initialization for default MemoryTokenStore on HS2

2015-03-26 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10093?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-10093: Attachment: HIVE-10093.patch Address comments. Unnecessary HMSHandler initialization for default

[jira] [Updated] (HIVE-10093) Unnecessary HMSHandler initialization for default MemoryTokenStore on HS2

2015-03-26 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10093?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-10093: Attachment: (was: HIVE-10093.patch) Unnecessary HMSHandler initialization for default MemoryTokenStore

[jira] [Commented] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-03-24 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14378367#comment-14378367 ] Aihua Xu commented on HIVE-3454: Thanks [~csun] and [~jdere]. Problem with CAST(BIGINT as

[jira] [Commented] (HIVE-10093) Unnecessary HMSHandler initialization for default MemoryTokenStore on HS2

2015-03-27 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10093?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14385033#comment-14385033 ] Aihua Xu commented on HIVE-10093: - Whoops. I included it by accident. Unnecessary

[jira] [Commented] (HIVE-10093) Unnecessary HMSHandler initialization for default MemoryTokenStore on HS2

2015-03-27 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10093?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14385042#comment-14385042 ] Aihua Xu commented on HIVE-10093: - Thanks Szehon. Unnecessary HMSHandler initialization

[jira] [Assigned] (HIVE-10149) Shuffle Hive data before storing in Parquet

2015-04-02 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10149?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu reassigned HIVE-10149: --- Assignee: Aihua Xu Shuffle Hive data before storing in Parquet

[jira] [Commented] (HIVE-9917) After HIVE-3454 is done, make int to timestamp conversion configurable

2015-04-02 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14393415#comment-14393415 ] Aihua Xu commented on HIVE-9917: Already created. Please see the link above. After

[jira] [Commented] (HIVE-9917) After HIVE-3454 is done, make int to timestamp conversion configurable

2015-04-03 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14394923#comment-14394923 ] Aihua Xu commented on HIVE-9917: Thanks Jason. Regarding implicit conversion, I checked

[jira] [Commented] (HIVE-9917) After HIVE-3454 is done, make int to timestamp conversion configurable

2015-04-21 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14505332#comment-14505332 ] Aihua Xu commented on HIVE-9917: I see. Yeah. I was using --no-prefix. After HIVE-3454

[jira] [Commented] (HIVE-9917) After HIVE-3454 is done, make int to timestamp conversion configurable

2015-04-21 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14505392#comment-14505392 ] Aihua Xu commented on HIVE-9917: [~jdere] Can you submit the patch for me then? Thanks.

[jira] [Commented] (HIVE-10454) Query against partitioned table in strict mode failed with No partition predicate found even if partition predicate is specified.

2015-04-23 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14509254#comment-14509254 ] Aihua Xu commented on HIVE-10454: - That condition doesn't check how many partitions will

[jira] [Commented] (HIVE-9917) After HIVE-3454 is done, make int to timestamp conversion configurable

2015-04-23 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14509570#comment-14509570 ] Aihua Xu commented on HIVE-9917: Thanks [~jdere]. After HIVE-3454 is done, make int to

[jira] [Commented] (HIVE-10454) Query against partitioned table in strict mode failed with No partition predicate found even if partition predicate is specified.

2015-04-23 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14509545#comment-14509545 ] Aihua Xu commented on HIVE-10454: - In this query, I'm not filtering the rows but filtering

[jira] [Updated] (HIVE-10419) can't do query on partitioned view with analytic function in strictmode

2015-04-23 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10419?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-10419: Attachment: (was: HIVE-10419.patch) can't do query on partitioned view with analytic function in

[jira] [Updated] (HIVE-10454) Query against partitioned table in strict mode failed with No partition predicate found even if partition predicate is specified.

2015-04-23 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-10454: Attachment: HIVE-10454.patch Query against partitioned table in strict mode failed with No partition

[jira] [Updated] (HIVE-10419) can't do query on partitioned view with analytic function in strictmode

2015-04-23 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10419?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-10419: Attachment: HIVE-10419.patch can't do query on partitioned view with analytic function in strictmode

[jira] [Commented] (HIVE-9917) After HIVE-3454 is done, make int to timestamp conversion configurable

2015-04-20 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14502858#comment-14502858 ] Aihua Xu commented on HIVE-9917: [~jdere] You are talking about vector_between_in.q.out,

[jira] [Commented] (HIVE-9917) After HIVE-3454 is done, make int to timestamp conversion configurable

2015-04-20 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14502860#comment-14502860 ] Aihua Xu commented on HIVE-9917: Sorry. Alex Pivovarov's fix. :) After HIVE-3454 is done,

[jira] [Commented] (HIVE-10312) SASL.QOP in JDBC URL is ignored for Delegation token Authentication

2015-04-20 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10312?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14502923#comment-14502923 ] Aihua Xu commented on HIVE-10312: - [~mkazia] Regarding JDBC driver ignores the SASL.QOP,

[jira] [Commented] (HIVE-9917) After HIVE-3454 is done, make int to timestamp conversion configurable

2015-04-21 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14505623#comment-14505623 ] Aihua Xu commented on HIVE-9917: No. I mean check in this code change to trunk? After

[jira] [Commented] (HIVE-10399) from_unixtime_millis() Hive UDF

2015-04-21 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14505871#comment-14505871 ] Aihua Xu commented on HIVE-10399: - I don't think you need such UDF. You can just call

[jira] [Commented] (HIVE-10192) insert into table failed for partitioned table.

2015-04-21 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10192?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14506120#comment-14506120 ] Aihua Xu commented on HIVE-10192: - [~Ganesh.Sathish] Are you still having the issue? I

[jira] [Resolved] (HIVE-10354) Investigate the test failure of TestHadoop20SAuthBridge.testSaslWithHiveMetaStore

2015-04-21 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10354?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu resolved HIVE-10354. - Resolution: Fixed The issue may be related to the env. Resolve for now and let's reopen it if it

[jira] [Updated] (HIVE-10454) Query against partitioned table in strict mode failed with No partition predicate found even if partition predicate is specified.

2015-04-22 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-10454: Description: The following queries fail: {noformat} create table t1 (c1 int) PARTITIONED BY (c2 string);

[jira] [Assigned] (HIVE-10454) Query against partitioned table in strict mode failed with No partition predicate found even if partition predicate is specified.

2015-04-22 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu reassigned HIVE-10454: --- Assignee: Aihua Xu Query against partitioned table in strict mode failed with No partition

[jira] [Updated] (HIVE-10454) Query against partitioned table in strict mode failed with No partition predicate found even if partition predicate is specified.

2015-04-28 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-10454: Attachment: HIVE-10454.patch Query against partitioned table in strict mode failed with No partition

[jira] [Updated] (HIVE-10454) Query against partitioned table in strict mode failed with No partition predicate found even if partition predicate is specified.

2015-04-28 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-10454: Attachment: (was: HIVE-10454.patch) Query against partitioned table in strict mode failed with No

[jira] [Assigned] (HIVE-10140) Window boundary is not compared correctly

2015-04-28 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10140?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu reassigned HIVE-10140: --- Assignee: Aihua Xu Window boundary is not compared correctly

[jira] [Commented] (HIVE-10140) Window boundary is not compared correctly

2015-04-28 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10140?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14518017#comment-14518017 ] Aihua Xu commented on HIVE-10140: - Let me take a look. Window boundary is not compared

[jira] [Updated] (HIVE-10454) Query against partitioned table in strict mode failed with No partition predicate found even if partition predicate is specified.

2015-04-29 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-10454: Attachment: (was: HIVE-10454.patch) Query against partitioned table in strict mode failed with No

[jira] [Updated] (HIVE-10454) Query against partitioned table in strict mode failed with No partition predicate found even if partition predicate is specified.

2015-04-29 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-10454: Attachment: HIVE-10454.patch Query against partitioned table in strict mode failed with No partition

[jira] [Commented] (HIVE-10454) Query against partitioned table in strict mode failed with No partition predicate found even if partition predicate is specified.

2015-04-29 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14520166#comment-14520166 ] Aihua Xu commented on HIVE-10454: - Two unit tests failure are related. Fixed in the new

[jira] [Commented] (HIVE-10140) Window boundary is not compared correctly

2015-04-30 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10140?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14521531#comment-14521531 ] Aihua Xu commented on HIVE-10140: - Yes, we have some issues in there. It should work like

[jira] [Updated] (HIVE-10140) Window boundary is not compared correctly

2015-04-30 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10140?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-10140: Attachment: HIVE-10140.patch Window boundary is not compared correctly

[jira] [Commented] (HIVE-10454) Query against partitioned table in strict mode failed with No partition predicate found even if partition predicate is specified.

2015-04-30 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14522169#comment-14522169 ] Aihua Xu commented on HIVE-10454: - The failures seems unrelated to the patch. Query

[jira] [Commented] (HIVE-10140) Window boundary is not compared correctly

2015-05-01 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10140?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14523257#comment-14523257 ] Aihua Xu commented on HIVE-10140: - The unit tests are not related to the change. Window

[jira] [Commented] (HIVE-10140) Window boundary is not compared correctly

2015-05-01 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10140?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14523261#comment-14523261 ] Aihua Xu commented on HIVE-10140: - [~ashutoshc] Can you help review the change? The change

[jira] [Assigned] (HIVE-10555) Windowing function for count(*) with preceding rows doesn't work as expected

2015-05-04 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10555?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu reassigned HIVE-10555: --- Assignee: Aihua Xu Windowing function for count(*) with preceding rows doesn't work as expected

[jira] [Commented] (HIVE-3235) Support jobId notification for MaredTasks

2015-05-04 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3235?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14526973#comment-14526973 ] Aihua Xu commented on HIVE-3235: [~navis] Can we get this reviewed and committed?

[jira] [Commented] (HIVE-10454) Query against partitioned table in strict mode failed with No partition predicate found even if partition predicate is specified.

2015-05-04 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14526982#comment-14526982 ] Aihua Xu commented on HIVE-10454: - [~ashutoshc] Can you help review this patch as well?

[jira] [Updated] (HIVE-10454) Query against partitioned table in strict mode failed with No partition predicate found even if partition predicate is specified.

2015-05-01 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-10454: Attachment: (was: HIVE-10454.2.patch) Query against partitioned table in strict mode failed with No

[jira] [Updated] (HIVE-10454) Query against partitioned table in strict mode failed with No partition predicate found even if partition predicate is specified.

2015-05-01 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-10454: Attachment: HIVE-10454.2.patch Query against partitioned table in strict mode failed with No partition

[jira] [Commented] (HIVE-10454) Query against partitioned table in strict mode failed with No partition predicate found even if partition predicate is specified.

2015-05-01 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14523796#comment-14523796 ] Aihua Xu commented on HIVE-10454: - I reverted the alias change in

[jira] [Updated] (HIVE-10454) Query against partitioned table in strict mode failed with No partition predicate found even if partition predicate is specified.

2015-05-01 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-10454: Attachment: (was: HIVE-10454.2.patch) Query against partitioned table in strict mode failed with No

[jira] [Updated] (HIVE-10454) Query against partitioned table in strict mode failed with No partition predicate found even if partition predicate is specified.

2015-05-01 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-10454: Attachment: HIVE-10454.2.patch Query against partitioned table in strict mode failed with No partition

[jira] [Updated] (HIVE-10454) Query against partitioned table in strict mode failed with No partition predicate found even if partition predicate is specified.

2015-05-01 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-10454: Attachment: HIVE-10454.2.patch Query against partitioned table in strict mode failed with No partition

[jira] [Commented] (HIVE-10454) Query against partitioned table in strict mode failed with No partition predicate found even if partition predicate is specified.

2015-05-01 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14523625#comment-14523625 ] Aihua Xu commented on HIVE-10454: - Submitted new patch to save the partition filter status

[jira] [Commented] (HIVE-10140) Window boundary is not compared correctly

2015-05-01 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10140?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14523751#comment-14523751 ] Aihua Xu commented on HIVE-10140: - In my patch, {{ROWS between 2 preceding and 10

[jira] [Commented] (HIVE-10140) Window boundary is not compared correctly

2015-05-01 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10140?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14523754#comment-14523754 ] Aihua Xu commented on HIVE-10140: - {{Window range invalid, start boundary is greater than

[jira] [Commented] (HIVE-10140) Window boundary is not compared correctly

2015-05-01 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10140?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14523756#comment-14523756 ] Aihua Xu commented on HIVE-10140: - Yes. I verified against Oracle. Trying to follow what

[jira] [Resolved] (HIVE-10353) Investigate test failure on TestHadoop20SAuthBridge.testMetastoreProxyUser

2015-04-28 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu resolved HIVE-10353. - Resolution: Cannot Reproduce Seems this issue doesn't happen any more. Will reopen if it happens again.

[jira] [Updated] (HIVE-10555) Windowing function for count(*) with preceding rows doesn't work as expected

2015-04-30 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10555?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-10555: Description: The following windowing function always returns 0 for count(*). {noformat} Table t1 key

[jira] [Commented] (HIVE-10140) Window boundary is not compared correctly

2015-04-30 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10140?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14521651#comment-14521651 ] Aihua Xu commented on HIVE-10140: - We should fix this before HIVE-10555. Window boundary

[jira] [Commented] (HIVE-10454) Query against partitioned table in strict mode failed with No partition predicate found even if partition predicate is specified.

2015-05-01 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14523214#comment-14523214 ] Aihua Xu commented on HIVE-10454: - Before the change, we only check predicates on

[jira] [Commented] (HIVE-10454) Query against partitioned table in strict mode failed with No partition predicate found even if partition predicate is specified.

2015-05-05 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14528436#comment-14528436 ] Aihua Xu commented on HIVE-10454: - It makes sense. Seems before I misunderstood Xuefu's

[jira] [Updated] (HIVE-10643) Refactoring Windowing for sum() to pass WindowFrameDef instead of two numbers (1 for number of preceding and 1 for number of following)

2015-05-07 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10643?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-10643: Description: The functionality should not be affected. Instead of passing 2 numbers (1 for # of preceding

[jira] [Updated] (HIVE-10650) Improve sum() function over windowing to support additional range formats

2015-05-07 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10650?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-10650: Summary: Improve sum() function over windowing to support additional range formats (was: Improve sum()

[jira] [Assigned] (HIVE-10650) Improve sum() function over windowing to support additional range formats

2015-05-07 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10650?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu reassigned HIVE-10650: --- Assignee: Aihua Xu Improve sum() function over windowing to support additional range formats

  1   2   3   4   5   6   7   8   9   10   >