[jira] [Commented] (HIVE-16646) Alias in transform ... as clause shouldn't be case sensitive

2017-05-19 Thread Yongzhi Chen (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-16646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16017228#comment-16017228
 ] 

Yongzhi Chen commented on HIVE-16646:
-

Thanks [~leftylev], just added 2.4 to the fix version.

> Alias in transform ... as clause shouldn't be case sensitive
> 
>
> Key: HIVE-16646
> URL: https://issues.apache.org/jira/browse/HIVE-16646
> Project: Hive
>  Issue Type: Bug
>  Components: hpl/sql
>Reporter: Yibing Shi
>Assignee: Yibing Shi
> Fix For: 3.0.0, 2.4.0
>
> Attachments: HIVE-16646.1.patch, HIVE-16646.2.patch
>
>
> Create a table like below:
> {code:sql}
> CREATE TABLE hive_bug(col1 string);
> {code}
> Run below query in Hive:
> {code}
> from hive_bug select transform(col1) using '/bin/cat' as ( string);
> {code}
> The result would be:
> {noformat}
> 0: jdbc:hive2://localhost:1> from hive_bug select transform(col1) using 
> '/bin/cat' as ( string);
> ..
> INFO  : OK
> +---+--+
> |   |
> +---+--+
> +---+--+
> {noformat}
> The output column name is ** instead of the lowercase .



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

[jira] [Commented] (HIVE-16646) Alias in transform ... as clause shouldn't be case sensitive

2017-05-19 Thread Lefty Leverenz (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-16646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16016997#comment-16016997
 ] 

Lefty Leverenz commented on HIVE-16646:
---

[~ychena], you committed this to branch-2 as well as master so the fix version 
should be 2.4.0.  (3.0.0 can also be listed, but it isn't necessary.)

See commit 43f1d7791ed22411c701f4973316f49eaf004bf8.

> Alias in transform ... as clause shouldn't be case sensitive
> 
>
> Key: HIVE-16646
> URL: https://issues.apache.org/jira/browse/HIVE-16646
> Project: Hive
>  Issue Type: Bug
>  Components: hpl/sql
>Reporter: Yibing Shi
>Assignee: Yibing Shi
> Fix For: 3.0.0
>
> Attachments: HIVE-16646.1.patch, HIVE-16646.2.patch
>
>
> Create a table like below:
> {code:sql}
> CREATE TABLE hive_bug(col1 string);
> {code}
> Run below query in Hive:
> {code}
> from hive_bug select transform(col1) using '/bin/cat' as ( string);
> {code}
> The result would be:
> {noformat}
> 0: jdbc:hive2://localhost:1> from hive_bug select transform(col1) using 
> '/bin/cat' as ( string);
> ..
> INFO  : OK
> +---+--+
> |   |
> +---+--+
> +---+--+
> {noformat}
> The output column name is ** instead of the lowercase .



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

[jira] [Commented] (HIVE-16646) Alias in transform ... as clause shouldn't be case sensitive

2017-05-12 Thread Yongzhi Chen (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-16646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16007965#comment-16007965
 ] 

Yongzhi Chen commented on HIVE-16646:
-

The failures are not related.

> Alias in transform ... as clause shouldn't be case sensitive
> 
>
> Key: HIVE-16646
> URL: https://issues.apache.org/jira/browse/HIVE-16646
> Project: Hive
>  Issue Type: Bug
>  Components: hpl/sql
>Reporter: Yibing Shi
>Assignee: Yibing Shi
> Attachments: HIVE-16646.1.patch, HIVE-16646.2.patch
>
>
> Create a table like below:
> {code:sql}
> CREATE TABLE hive_bug(col1 string);
> {code}
> Run below query in Hive:
> {code}
> from hive_bug select transform(col1) using '/bin/cat' as ( string);
> {code}
> The result would be:
> {noformat}
> 0: jdbc:hive2://localhost:1> from hive_bug select transform(col1) using 
> '/bin/cat' as ( string);
> ..
> INFO  : OK
> +---+--+
> |   |
> +---+--+
> +---+--+
> {noformat}
> The output column name is ** instead of the lowercase .



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

[jira] [Commented] (HIVE-16646) Alias in transform ... as clause shouldn't be case sensitive

2017-05-12 Thread Yibing Shi (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-16646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16007695#comment-16007695
 ] 

Yibing Shi commented on HIVE-16646:
---

Pulled down the latest master branch, and applied the patch from [~ychena]. The 
failed tests listed above all succeed for me. Can we kick off the test again 
and see how it goes?


> Alias in transform ... as clause shouldn't be case sensitive
> 
>
> Key: HIVE-16646
> URL: https://issues.apache.org/jira/browse/HIVE-16646
> Project: Hive
>  Issue Type: Bug
>  Components: hpl/sql
>Reporter: Yibing Shi
>Assignee: Yibing Shi
> Attachments: HIVE-16646.1.patch, HIVE-16646.2.patch
>
>
> Create a table like below:
> {code:sql}
> CREATE TABLE hive_bug(col1 string);
> {code}
> Run below query in Hive:
> {code}
> from hive_bug select transform(col1) using '/bin/cat' as ( string);
> {code}
> The result would be:
> {noformat}
> 0: jdbc:hive2://localhost:1> from hive_bug select transform(col1) using 
> '/bin/cat' as ( string);
> ..
> INFO  : OK
> +---+--+
> |   |
> +---+--+
> +---+--+
> {noformat}
> The output column name is ** instead of the lowercase .



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

[jira] [Commented] (HIVE-16646) Alias in transform ... as clause shouldn't be case sensitive

2017-05-11 Thread Hive QA (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-16646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16007665#comment-16007665
 ] 

Hive QA commented on HIVE-16646:




Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12867633/HIVE-16646.2.patch

{color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 5 failed/errored test(s), 10688 tests 
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestBeeLineDriver.testCliDriver[mapjoin2] 
(batchId=236)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_if_expr]
 (batchId=144)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_join30]
 (batchId=149)
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainanalyze_3] 
(batchId=97)
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainuser_3] 
(batchId=97)
{noformat}

Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/5212/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/5212/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-5212/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 5 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12867633 - PreCommit-HIVE-Build

> Alias in transform ... as clause shouldn't be case sensitive
> 
>
> Key: HIVE-16646
> URL: https://issues.apache.org/jira/browse/HIVE-16646
> Project: Hive
>  Issue Type: Bug
>  Components: hpl/sql
>Reporter: Yibing Shi
>Assignee: Yibing Shi
> Attachments: HIVE-16646.1.patch, HIVE-16646.2.patch
>
>
> Create a table like below:
> {code:sql}
> CREATE TABLE hive_bug(col1 string);
> {code}
> Run below query in Hive:
> {code}
> from hive_bug select transform(col1) using '/bin/cat' as ( string);
> {code}
> The result would be:
> {noformat}
> 0: jdbc:hive2://localhost:1> from hive_bug select transform(col1) using 
> '/bin/cat' as ( string);
> ..
> INFO  : OK
> +---+--+
> |   |
> +---+--+
> +---+--+
> {noformat}
> The output column name is ** instead of the lowercase .



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

[jira] [Commented] (HIVE-16646) Alias in transform ... as clause shouldn't be case sensitive

2017-05-11 Thread Yongzhi Chen (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-16646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16007511#comment-16007511
 ] 

Yongzhi Chen commented on HIVE-16646:
-

The patch LGTM +1

> Alias in transform ... as clause shouldn't be case sensitive
> 
>
> Key: HIVE-16646
> URL: https://issues.apache.org/jira/browse/HIVE-16646
> Project: Hive
>  Issue Type: Bug
>  Components: hpl/sql
>Reporter: Yibing Shi
>Assignee: Yibing Shi
> Attachments: HIVE-16646.1.patch, HIVE-16646.2.patch
>
>
> Create a table like below:
> {code:sql}
> CREATE TABLE hive_bug(col1 string);
> {code}
> Run below query in Hive:
> {code}
> from hive_bug select transform(col1) using '/bin/cat' as ( string);
> {code}
> The result would be:
> {noformat}
> 0: jdbc:hive2://localhost:1> from hive_bug select transform(col1) using 
> '/bin/cat' as ( string);
> ..
> INFO  : OK
> +---+--+
> |   |
> +---+--+
> +---+--+
> {noformat}
> The output column name is ** instead of the lowercase .



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

[jira] [Commented] (HIVE-16646) Alias in transform ... as clause shouldn't be case sensitive

2017-05-11 Thread Yongzhi Chen (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-16646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16007510#comment-16007510
 ] 

Yongzhi Chen commented on HIVE-16646:
-

The failures are not related. 
Following two tests passed in my local machine:
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[orc_merge_incompat2] 
(batchId=79)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[columnstats_part_coltype]
 (batchId=156)
The rest failures aged more than 2.




> Alias in transform ... as clause shouldn't be case sensitive
> 
>
> Key: HIVE-16646
> URL: https://issues.apache.org/jira/browse/HIVE-16646
> Project: Hive
>  Issue Type: Bug
>  Components: hpl/sql
>Reporter: Yibing Shi
>Assignee: Yibing Shi
> Attachments: HIVE-16646.1.patch, HIVE-16646.2.patch
>
>
> Create a table like below:
> {code:sql}
> CREATE TABLE hive_bug(col1 string);
> {code}
> Run below query in Hive:
> {code}
> from hive_bug select transform(col1) using '/bin/cat' as ( string);
> {code}
> The result would be:
> {noformat}
> 0: jdbc:hive2://localhost:1> from hive_bug select transform(col1) using 
> '/bin/cat' as ( string);
> ..
> INFO  : OK
> +---+--+
> |   |
> +---+--+
> +---+--+
> {noformat}
> The output column name is ** instead of the lowercase .



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

[jira] [Commented] (HIVE-16646) Alias in transform ... as clause shouldn't be case sensitive

2017-05-11 Thread Hive QA (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-16646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16007464#comment-16007464
 ] 

Hive QA commented on HIVE-16646:




Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12867633/HIVE-16646.2.patch

{color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 5 failed/errored test(s), 10688 tests 
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[orc_merge_incompat2] 
(batchId=79)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[columnstats_part_coltype]
 (batchId=156)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_join30]
 (batchId=149)
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainanalyze_3] 
(batchId=97)
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainuser_3] 
(batchId=97)
{noformat}

Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/5206/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/5206/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-5206/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 5 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12867633 - PreCommit-HIVE-Build

> Alias in transform ... as clause shouldn't be case sensitive
> 
>
> Key: HIVE-16646
> URL: https://issues.apache.org/jira/browse/HIVE-16646
> Project: Hive
>  Issue Type: Bug
>  Components: hpl/sql
>Reporter: Yibing Shi
>Assignee: Yibing Shi
> Attachments: HIVE-16646.1.patch, HIVE-16646.2.patch
>
>
> Create a table like below:
> {code:sql}
> CREATE TABLE hive_bug(col1 string);
> {code}
> Run below query in Hive:
> {code}
> from hive_bug select transform(col1) using '/bin/cat' as ( string);
> {code}
> The result would be:
> {noformat}
> 0: jdbc:hive2://localhost:1> from hive_bug select transform(col1) using 
> '/bin/cat' as ( string);
> ..
> INFO  : OK
> +---+--+
> |   |
> +---+--+
> +---+--+
> {noformat}
> The output column name is ** instead of the lowercase .



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

[jira] [Commented] (HIVE-16646) Alias in transform ... as clause shouldn't be case sensitive

2017-05-11 Thread Yibing Shi (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-16646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16007339#comment-16007339
 ] 

Yibing Shi commented on HIVE-16646:
---

Thank you, [~ychena]!

> Alias in transform ... as clause shouldn't be case sensitive
> 
>
> Key: HIVE-16646
> URL: https://issues.apache.org/jira/browse/HIVE-16646
> Project: Hive
>  Issue Type: Bug
>  Components: hpl/sql
>Reporter: Yibing Shi
>Assignee: Yibing Shi
> Attachments: HIVE-16646.1.patch, HIVE-16646.2.patch
>
>
> Create a table like below:
> {code:sql}
> CREATE TABLE hive_bug(col1 string);
> {code}
> Run below query in Hive:
> {code}
> from hive_bug select transform(col1) using '/bin/cat' as ( string);
> {code}
> The result would be:
> {noformat}
> 0: jdbc:hive2://localhost:1> from hive_bug select transform(col1) using 
> '/bin/cat' as ( string);
> ..
> INFO  : OK
> +---+--+
> |   |
> +---+--+
> +---+--+
> {noformat}
> The output column name is ** instead of the lowercase .



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

[jira] [Commented] (HIVE-16646) Alias in transform ... as clause shouldn't be case sensitive

2017-05-11 Thread Yongzhi Chen (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-16646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16007014#comment-16007014
 ] 

Yongzhi Chen commented on HIVE-16646:
-

[~Yibing], I generate another patch to include the output and also change a 
little on the test to make it more relevant to the fix. 
In order to attach it, I have to temporary change the assignee of the bug, then 
change back to you.  

> Alias in transform ... as clause shouldn't be case sensitive
> 
>
> Key: HIVE-16646
> URL: https://issues.apache.org/jira/browse/HIVE-16646
> Project: Hive
>  Issue Type: Bug
>  Components: hpl/sql
>Reporter: Yibing Shi
>Assignee: Yibing Shi
> Attachments: HIVE-16646.1.patch
>
>
> Create a table like below:
> {code:sql}
> CREATE TABLE hive_bug(col1 string);
> {code}
> Run below query in Hive:
> {code}
> from hive_bug select transform(col1) using '/bin/cat' as ( string);
> {code}
> The result would be:
> {noformat}
> 0: jdbc:hive2://localhost:1> from hive_bug select transform(col1) using 
> '/bin/cat' as ( string);
> ..
> INFO  : OK
> +---+--+
> |   |
> +---+--+
> +---+--+
> {noformat}
> The output column name is ** instead of the lowercase .



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

[jira] [Commented] (HIVE-16646) Alias in transform ... as clause shouldn't be case sensitive

2017-05-11 Thread Yongzhi Chen (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-16646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16006546#comment-16006546
 ] 

Yongzhi Chen commented on HIVE-16646:
-

[~Yibing], you should include the test result file in the patch too. 
(transform3.q.out)

> Alias in transform ... as clause shouldn't be case sensitive
> 
>
> Key: HIVE-16646
> URL: https://issues.apache.org/jira/browse/HIVE-16646
> Project: Hive
>  Issue Type: Bug
>  Components: hpl/sql
>Reporter: Yibing Shi
>Assignee: Yibing Shi
> Attachments: HIVE-16646.1.patch
>
>
> Create a table like below:
> {code:sql}
> CREATE TABLE hive_bug(col1 string);
> {code}
> Run below query in Hive:
> {code}
> from hive_bug select transform(col1) using '/bin/cat' as ( string);
> {code}
> The result would be:
> {noformat}
> 0: jdbc:hive2://localhost:1> from hive_bug select transform(col1) using 
> '/bin/cat' as ( string);
> ..
> INFO  : OK
> +---+--+
> |   |
> +---+--+
> +---+--+
> {noformat}
> The output column name is ** instead of the lowercase .



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

[jira] [Commented] (HIVE-16646) Alias in transform ... as clause shouldn't be case sensitive

2017-05-11 Thread Yibing Shi (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-16646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16006394#comment-16006394
 ] 

Yibing Shi commented on HIVE-16646:
---

Another query that can show this problem more clearly is:
{code:sql}
select t.col from ( 
select transform(col) using 'cat' as (COL string) from transform3_t1
) t;
{code}

It fails with below error:
{noformat}
FAILED: SemanticException [Error 10002]: Line 1:9 Invalid column reference 'col'
{noformat}

Changing {{as (COL string)}} to {{as (col string)}} makes the query run 
properly.

> Alias in transform ... as clause shouldn't be case sensitive
> 
>
> Key: HIVE-16646
> URL: https://issues.apache.org/jira/browse/HIVE-16646
> Project: Hive
>  Issue Type: Bug
>  Components: hpl/sql
>Reporter: Yibing Shi
>
> Create a table like below:
> {code:sql}
> CREATE TABLE hive_bug(col1 string);
> {code}
> Run below query in Hive:
> {code}
> from hive_bug select transform(col1) using '/bin/cat' as ( string);
> {code}
> The result would be:
> {noformat}
> 0: jdbc:hive2://localhost:1> from hive_bug select transform(col1) using 
> '/bin/cat' as ( string);
> ..
> INFO  : OK
> +---+--+
> |   |
> +---+--+
> +---+--+
> {noformat}
> The output column name is ** instead of the lowercase .



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)