[jira] [Commented] (HIVE-3335) Thousand of CLOSE_WAIT socket when we using SymbolicInputFormat

[ https://issues.apache.org/jira/browse/HIVE-3335?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13428987#comment-13428987 ] Ashutosh Chauhan commented on HIVE-3335: [~showyou] Your analysis seems correct.

[jira] [Commented] (HIVE-3276) optimize union sub-queries

[ https://issues.apache.org/jira/browse/HIVE-3276?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13428996#comment-13428996 ] Namit Jain commented on HIVE-3276: -- Looked at it in more detail. It might be cleaner to

Re: Variable Substitution in Hive 0.6?

Does anyone is aware of Hive variable substitution works in Hive 0.6 or not? If you mean this https://issues.apache.org/jira/browse/HIVE-1096 then no, it's been implemented in Hive 0.7 Cheers, Lars

[jira] [Created] (HIVE-3336) [Hive-Hbase Integration]:Data is not inserted into the hbase table from the hive table if the value is null even if the row key is not null

Kristam Subba Swathi created HIVE-3336: -- Summary: [Hive-Hbase Integration]:Data is not inserted into the hbase table from the hive table if the value is null even if the row key is not null Key: HIVE-3336

[jira] [Assigned] (HIVE-3336) [Hive-Hbase Integration]:Data is not inserted into the hbase table from the hive table if the value is null even if the row key is not null

[ https://issues.apache.org/jira/browse/HIVE-3336?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chinna Rao Lalam reassigned HIVE-3336: -- Assignee: Chinna Rao Lalam [Hive-Hbase Integration]:Data is not inserted into the

[jira] [Commented] (HIVE-3293) Load file into a table does not update table statistics

[ https://issues.apache.org/jira/browse/HIVE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13429265#comment-13429265 ] Kevin Wilfong commented on HIVE-3293: - One comment on the diff, otherwise looks good.

[jira] [Commented] (HIVE-3268) expressions in cluster by are not working

[ https://issues.apache.org/jira/browse/HIVE-3268?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13429267#comment-13429267 ] Kevin Wilfong commented on HIVE-3268: - +1 expressions in cluster by

[jira] [Updated] (HIVE-3293) Load file into a table does not update table statistics

[ https://issues.apache.org/jira/browse/HIVE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-3293: - Status: Patch Available (was: Open) Load file into a table does not update table statistics

[jira] [Commented] (HIVE-3293) Load file into a table does not update table statistics

[ https://issues.apache.org/jira/browse/HIVE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13429283#comment-13429283 ] Kevin Wilfong commented on HIVE-3293: - Thanks Namit. +1 Load file

[jira] [Created] (HIVE-3337) Create Table Like should copy configured Table Parameters

Bhushan Mandhani created HIVE-3337: -- Summary: Create Table Like should copy configured Table Parameters Key: HIVE-3337 URL: https://issues.apache.org/jira/browse/HIVE-3337 Project: Hive

[jira] [Updated] (HIVE-3327) Remove the Unix specific absolute path of “Cat” utility in several .q files to make them run on Windows with CygWin in path.

[ https://issues.apache.org/jira/browse/HIVE-3327?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-3327: --- Resolution: Fixed Fix Version/s: (was: 0.9.1) Status: Resolved (was:

[jira] [Commented] (HIVE-3338) Archives broken for hadoop 1.0

[ https://issues.apache.org/jira/browse/HIVE-3338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13429346#comment-13429346 ] Vikram Dixit K commented on HIVE-3338: -- a

[jira] [Created] (HIVE-3338) Archives broken for hadoop 1.0

Vikram Dixit K created HIVE-3338: Summary: Archives broken for hadoop 1.0 Key: HIVE-3338 URL: https://issues.apache.org/jira/browse/HIVE-3338 Project: Hive Issue Type: Bug

[jira] [Updated] (HIVE-3338) Archives broken for hadoop 1.0

[ https://issues.apache.org/jira/browse/HIVE-3338?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vikram Dixit K updated HIVE-3338: - Attachment: HIVE-3338.patch Archives broken for hadoop 1.0 --

[jira] [Updated] (HIVE-3338) Archives broken for hadoop 1.0

[ https://issues.apache.org/jira/browse/HIVE-3338?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vikram Dixit K updated HIVE-3338: - Status: Patch Available (was: Open) Archives broken for hadoop 1.0

[jira] [Commented] (HIVE-3338) Archives broken for hadoop 1.0

[ https://issues.apache.org/jira/browse/HIVE-3338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13429348#comment-13429348 ] Vikram Dixit K commented on HIVE-3338: -- There is one issue that is not resolved. For

[jira] [Assigned] (HIVE-3299) UDF DAYNAME(date) to HIVE

[ https://issues.apache.org/jira/browse/HIVE-3299?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach reassigned HIVE-3299: Assignee: Namitha Babychan (was: Carl Steinbach) UDF DAYNAME(date) to HIVE

[jira] [Updated] (HIVE-3299) UDF DAYNAME(date) to HIVE

[ https://issues.apache.org/jira/browse/HIVE-3299?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-3299: - Fix Version/s: (was: 0.10.0) Status: Open (was: Patch Available) @Namitha: Thanks

Question regarding test query archive.q

Hi, The query test - archive.q that creates and uses hadoop archives was broken for hadoop 1.0. I have made the changes appropriately in the shims. https://issues.apache.org/jira/browse/HIVE-3338 There is one issue however: For archive.q test, in case of hadoop 20, the golden results seem to

[jira] [Commented] (HIVE-3337) Create Table Like should copy configured Table Parameters

[ https://issues.apache.org/jira/browse/HIVE-3337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13429383#comment-13429383 ] Carl Steinbach commented on HIVE-3337: -- Why do you need a configuration property? Why

[jira] [Updated] (HIVE-3293) Load file into a table does not update table statistics

[ https://issues.apache.org/jira/browse/HIVE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-3293: - Status: Open (was: Patch Available) Please attach the most recent version of the patch to this

[jira] [Updated] (HIVE-3268) expressions in cluster by are not working

[ https://issues.apache.org/jira/browse/HIVE-3268?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-3268: - Status: Open (was: Patch Available) Please attach the latest version of this patch to the

[jira] [Commented] (HIVE-3337) Create Table Like should copy configured Table Parameters

[ https://issues.apache.org/jira/browse/HIVE-3337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13429405#comment-13429405 ] Bhushan Mandhani commented on HIVE-3337: Because users might want to just copy the

[jira] [Commented] (HIVE-3268) expressions in cluster by are not working

[ https://issues.apache.org/jira/browse/HIVE-3268?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13429413#comment-13429413 ] Carl Steinbach commented on HIVE-3268: -- @Namit: I added comments on phabricator.

[jira] [Commented] (HIVE-3337) Create Table Like should copy configured Table Parameters

[ https://issues.apache.org/jira/browse/HIVE-3337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13429415#comment-13429415 ] Carl Steinbach commented on HIVE-3337: -- @Bhushan: Can you give me an example of a

[jira] [Commented] (HIVE-3337) Create Table Like should copy configured Table Parameters

[ https://issues.apache.org/jira/browse/HIVE-3337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13429433#comment-13429433 ] Carl Steinbach commented on HIVE-3337: -- bq. totalSize, numRows, last_modified_by, etc.

[jira] [Commented] (HIVE-3337) Create Table Like should copy configured Table Parameters

[ https://issues.apache.org/jira/browse/HIVE-3337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13429438#comment-13429438 ] Bhushan Mandhani commented on HIVE-3337: We have other parameters related to

Possible patch to fix column comments with non-native SerDe

My team and I have been trying, with limited success, to use the COMMENT feature of hive columns to maintain documentation for the tables and columns in our data-warehouse built on hive. However, we use a number of custom and non-native SerDes, and what happens to those tables is that the

[jira] [Commented] (HIVE-3337) Create Table Like should copy configured Table Parameters

[ https://issues.apache.org/jira/browse/HIVE-3337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13429450#comment-13429450 ] Bhushan Mandhani commented on HIVE-3337: Diff is at

[jira] [Updated] (HIVE-3337) Create Table Like should copy configured Table Parameters

[ https://issues.apache.org/jira/browse/HIVE-3337?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-3337: - Component/s: Configuration Create Table Like should copy configured Table Parameters

[jira] [Commented] (HIVE-3337) Create Table Like should copy configured Table Parameters

[ https://issues.apache.org/jira/browse/HIVE-3337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13429477#comment-13429477 ] Carl Steinbach commented on HIVE-3337: -- @Bhushan: Please see my comments on

Re: Possible patch to fix column comments with non-native SerDe

This was fixed in Hive 8 (https://issues.apache.org/jira/browse/HIVE-2171). Can you just apply that patch? On Mon, Aug 6, 2012 at 2:15 PM, Stephen R. Scaffidi sscaff...@tripadvisor.com wrote: My team and I have been trying, with limited success, to use the COMMENT feature of hive columns to

[jira] [Updated] (HIVE-3240) Fix non-deterministic results in newline.q and timestamp_lazy.q

[ https://issues.apache.org/jira/browse/HIVE-3240?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-3240: - Status: Open (was: Patch Available) @Zhenxiao: This needs a rebase after HIVE-3327. Please

[jira] [Commented] (HIVE-3242) Fix cascade_dbdrop.q when building hive on hadoop0.23

[ https://issues.apache.org/jira/browse/HIVE-3242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13429539#comment-13429539 ] Carl Steinbach commented on HIVE-3242: -- @Zhenxiao: Yes, your understanding is correct,

Re: Possible patch to fix column comments with non-native SerDe

Thanks! I'll see how it goes! (better yet, this could be what it takes to convince the team to upgrade!) On Aug 6, 2012, at 6:47 PM, Jakob Homan wrote: This was fixed in Hive 8 (https://issues.apache.org/jira/browse/HIVE-2171). Can you just apply that patch? On Mon, Aug 6, 2012 at 2:15

Hive-trunk-h0.21 - Build # 1594 - Still Failing

Changes for Build #1593 Changes for Build #1594 1 tests failed. REGRESSION: org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_union27 Error Message: Timeout occurred. Please note the time in the report does not reflect the time until the timeout. Stack Trace:

[jira] [Updated] (HIVE-2789) query_properties.q contains non-deterministic queries

[ https://issues.apache.org/jira/browse/HIVE-2789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-2789: - Summary: query_properties.q contains non-deterministic queries (was: When integrating into

[jira] [Commented] (HIVE-2789) query_properties.q contains non-deterministic queries

[ https://issues.apache.org/jira/browse/HIVE-2789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13429551#comment-13429551 ] Carl Steinbach commented on HIVE-2789: -- +1. Will commit if tests pass.

[jira] [Updated] (HIVE-3233) Error in semantic analysis:Invalid Table Alias

[ https://issues.apache.org/jira/browse/HIVE-3233?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Raihan Jamal updated HIVE-3233: --- Priority: Major (was: Minor) Error in semantic analysis:Invalid Table Alias

[jira] [Updated] (HIVE-2804) Task log retrieval fails on Hadoop 0.23

[ https://issues.apache.org/jira/browse/HIVE-2804?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-2804: - Status: Open (was: Patch Available) @Zhenxiao: Patch needs to be rebased against trunk. Thanks.

[jira] [Assigned] (HIVE-3216) DateDiff UDF overload with a unit parameter

[ https://issues.apache.org/jira/browse/HIVE-3216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan reassigned HIVE-3216: -- Assignee: Shefali Vohra DateDiff UDF overload with a unit parameter

[jira] [Updated] (HIVE-1173) Partition pruner cancels pruning if non-deterministic function present in filtering expression only in joins is present in query

[ https://issues.apache.org/jira/browse/HIVE-1173?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-1173: Affects Version/s: 0.10.0 Status: Open (was: Patch Available) Partition pruner cancels pruning

[jira] [Commented] (HIVE-3240) Fix non-deterministic results in newline.q and timestamp_lazy.q

[ https://issues.apache.org/jira/browse/HIVE-3240?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13429616#comment-13429616 ] Zhenxiao Luo commented on HIVE-3240: Patch rebased, Review request submitted at:

[jira] [Updated] (HIVE-3240) Fix non-deterministic results in newline.q and timestamp_lazy.q

[ https://issues.apache.org/jira/browse/HIVE-3240?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhenxiao Luo updated HIVE-3240: --- Attachment: HIVE-3240.2.patch.txt Fix non-deterministic results in newline.q and

[jira] [Updated] (HIVE-3240) Fix non-deterministic results in newline.q and timestamp_lazy.q

[ https://issues.apache.org/jira/browse/HIVE-3240?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhenxiao Luo updated HIVE-3240: --- Status: Patch Available (was: Open) Fix non-deterministic results in newline.q and

[jira] [Updated] (HIVE-3264) Add support for binary dataype to AvroSerde

[ https://issues.apache.org/jira/browse/HIVE-3264?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eli Reisman updated HIVE-3264: -- Attachment: HIVE-3264-5.patch Added a .q.out file to the party, still figuring out the build pricess

[jira] [Commented] (HIVE-3242) Fix cascade_dbdrop.q when building hive on hadoop0.23

[ https://issues.apache.org/jira/browse/HIVE-3242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13429624#comment-13429624 ] Zhenxiao Luo commented on HIVE-3242: @Ashutosh and Carl: Get it. Thanks for your

[jira] [Updated] (HIVE-3242) Fix cascade_dbdrop.q when building hive on hadoop0.23

[ https://issues.apache.org/jira/browse/HIVE-3242?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhenxiao Luo updated HIVE-3242: --- Status: Open (was: Patch Available) Fix cascade_dbdrop.q when building hive on hadoop0.23

[jira] [Updated] (HIVE-3242) Fix cascade_dbdrop.q when building hive on hadoop0.23

[ https://issues.apache.org/jira/browse/HIVE-3242?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhenxiao Luo updated HIVE-3242: --- Attachment: HIVE-3242.7.patch.txt Fix cascade_dbdrop.q when building hive on hadoop0.23

[jira] [Updated] (HIVE-3242) Fix cascade_dbdrop.q when building hive on hadoop0.23

[ https://issues.apache.org/jira/browse/HIVE-3242?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhenxiao Luo updated HIVE-3242: --- Status: Patch Available (was: Open) Fix cascade_dbdrop.q when building hive on hadoop0.23

Re: Review Request: This function overloads the current DateDiff(expr1, expr2) by adding another parameter to specify the units.

--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/6027/#review9924 --- trunk/ql/src/java/org/apache/hadoop/hive/ql/udf/UDFDateDiff.java

[jira] [Commented] (HIVE-3216) DateDiff UDF overload with a unit parameter

[ https://issues.apache.org/jira/browse/HIVE-3216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13429633#comment-13429633 ] Ashutosh Chauhan commented on HIVE-3216: [~shefaliv] I left some review comments on

Custom UserDefinedFunction in Hive

*Problem* I created the below UserDefinedFunction to get the yesterday's day in the format I wanted as I will be passing the format into this below method from the query. *public final class YesterdayDate extends UDF {* * * *public String evaluate(final String format) { * *

[jira] [Commented] (HIVE-2804) Task log retrieval fails on Hadoop 0.23

[ https://issues.apache.org/jira/browse/HIVE-2804?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13429657#comment-13429657 ] Zhenxiao Luo commented on HIVE-2804: Updated patch submitted for review at:

[jira] [Updated] (HIVE-2804) Task log retrieval fails on Hadoop 0.23

[ https://issues.apache.org/jira/browse/HIVE-2804?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhenxiao Luo updated HIVE-2804: --- Attachment: HIVE-2804.9.patch.txt Task log retrieval fails on Hadoop 0.23

[jira] [Updated] (HIVE-2804) Task log retrieval fails on Hadoop 0.23

[ https://issues.apache.org/jira/browse/HIVE-2804?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhenxiao Luo updated HIVE-2804: --- Status: Patch Available (was: Open) Task log retrieval fails on Hadoop 0.23

[jira] [Updated] (HIVE-3315) Propagate filers on inner join condition transitively

[ https://issues.apache.org/jira/browse/HIVE-3315?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-3315: Attachment: HIVE-3315.1.patch.txt Propagate filers on inner join condition transitively

[jira] [Commented] (HIVE-2804) Task log retrieval fails on Hadoop 0.23

[ https://issues.apache.org/jira/browse/HIVE-2804?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13429671#comment-13429671 ] Carl Steinbach commented on HIVE-2804: -- +1. Will commit if tests pass.

[jira] [Updated] (HIVE-3293) Load file into a table does not update table statistics

[ https://issues.apache.org/jira/browse/HIVE-3293?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-3293: - Attachment: hive.3293.2.patch Latest patch attached Load file into a table does not

[jira] [Commented] (HIVE-3304) sort merge join should work if both the tables are sorted in descending order

[ https://issues.apache.org/jira/browse/HIVE-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13429932#comment-13429932 ] Hudson commented on HIVE-3304: -- Integrated in Hive-trunk-h0.21 #1595 (See

Hive-trunk-h0.21 - Build # 1595 - Fixed

Changes for Build #1593 Changes for Build #1594 Changes for Build #1595 [hashutosh] HIVE-3327 :Remove the Unix specific absolute path of Cat utility in several .q files to make them run on Windows with CygWin in path. (Kanna Karanam via Ashutosh Chauhan) [kevinwilfong] HIVE-3304. sort merge