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

2015-03-26 Thread Hive QA (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-10085?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14383029#comment-14383029
 ] 

Hive QA commented on HIVE-10085:




{color:red}Overall{color}: -1 at least one tests failed

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

{color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 8677 tests executed
*Failed tests:*
{noformat}
org.apache.hive.jdbc.TestSSL.testSSLFetchHttp
{noformat}

Test results: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/3172/testReport
Console output: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/3172/console
Test logs: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-3172/

Messages:
{noformat}
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: 1 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12707520 - PreCommit-HIVE-TRUNK-Build

 Lateral view on top of a view throws RuntimeException
 -

 Key: HIVE-10085
 URL: https://issues.apache.org/jira/browse/HIVE-10085
 Project: Hive
  Issue Type: Bug
  Components: Query Processor
Affects Versions: 1.2.0
Reporter: Aihua Xu
Assignee: Aihua Xu
 Attachments: HIVE-10085.patch


 Following the following sqls to create table and view and execute a select 
 statement. It will throw the runtime exception:
 {noformat}
 FAILED: RuntimeException 
 org.apache.hadoop.hive.ql.exec.UDFArgumentTypeException: map or list is 
 expected at function SIZE, but int is found
 {noformat}
 {noformat} 
 CREATE TABLE t1( symptom STRING,  pattern ARRAYINT,  occurrence INT, index 
 INT);
 CREATE OR REPLACE VIEW v1 AS
 SELECT TRIM(pd.symptom) AS symptom, pd.index, pd.pattern, pd.occurrence, 
 pd.occurrence as cnt from t1 pd;
 SELECT pattern_data.symptom, pattern_data.index, pattern_data.occurrence, 
 pattern_data.cnt, size(pattern_data.pattern) as pattern_length, 
 pattern.pattern_id
 FROM v1 pattern_data LATERAL VIEW explode(pattern) pattern AS pattern_id;
 {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[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 on top of a view throws RuntimeException
 -

 Key: HIVE-10085
 URL: https://issues.apache.org/jira/browse/HIVE-10085
 Project: Hive
  Issue Type: Bug
  Components: Query Processor
Affects Versions: 1.2.0
Reporter: Aihua Xu
Assignee: Aihua Xu
 Attachments: HIVE-10085.patch


 Following the following sqls to create table and view and execute a select 
 statement. It will throw the runtime exception:
 {noformat}
 FAILED: RuntimeException 
 org.apache.hadoop.hive.ql.exec.UDFArgumentTypeException: map or list is 
 expected at function SIZE, but int is found
 {noformat}
 {noformat} 
 CREATE TABLE t1( symptom STRING,  pattern ARRAYINT,  occurrence INT, index 
 INT);
 CREATE OR REPLACE VIEW v1 AS
 SELECT TRIM(pd.symptom) AS symptom, pd.index, pd.pattern, pd.occurrence, 
 pd.occurrence as cnt from t1 pd;
 SELECT pattern_data.symptom, pattern_data.index, pattern_data.occurrence, 
 pattern_data.cnt, size(pattern_data.pattern) as pattern_length, 
 pattern.pattern_id
 FROM v1 pattern_data LATERAL VIEW explode(pattern) pattern AS pattern_id;
 {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


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

2015-03-25 Thread Ashutosh Chauhan (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-10085?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14380536#comment-14380536
 ] 

Ashutosh Chauhan commented on HIVE-10085:
-

Can you create a RB entry for this?

 Lateral view on top of a view throws RuntimeException
 -

 Key: HIVE-10085
 URL: https://issues.apache.org/jira/browse/HIVE-10085
 Project: Hive
  Issue Type: Bug
  Components: Query Processor
Affects Versions: 1.2.0
Reporter: Aihua Xu
Assignee: Aihua Xu
 Attachments: HIVE-10085.patch


 Following the following sqls to create table and view and execute a select 
 statement. It will throw the runtime exception:
 {noformat}
 FAILED: RuntimeException 
 org.apache.hadoop.hive.ql.exec.UDFArgumentTypeException: map or list is 
 expected at function SIZE, but int is found
 {noformat}
 {noformat} 
 CREATE TABLE t1( symptom STRING,  pattern ARRAYINT,  occurrence INT, index 
 INT);
 CREATE OR REPLACE VIEW v1 AS
 SELECT TRIM(pd.symptom) AS symptom, pd.index, pd.pattern, pd.occurrence, 
 pd.occurrence as cnt from t1 pd;
 SELECT pattern_data.symptom, pattern_data.index, pattern_data.occurrence, 
 pattern_data.cnt, size(pattern_data.pattern) as pattern_length, 
 pattern.pattern_id
 FROM v1 pattern_data LATERAL VIEW explode(pattern) pattern AS pattern_id;
 {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[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 help me review the change? 

 Lateral view on top of a view throws RuntimeException
 -

 Key: HIVE-10085
 URL: https://issues.apache.org/jira/browse/HIVE-10085
 Project: Hive
  Issue Type: Bug
  Components: Query Processor
Affects Versions: 1.2.0
Reporter: Aihua Xu
Assignee: Aihua Xu
 Attachments: HIVE-10085.patch


 Following the following sqls to create table and view and execute a select 
 statement. It will throw the runtime exception:
 {noformat}
 FAILED: RuntimeException 
 org.apache.hadoop.hive.ql.exec.UDFArgumentTypeException: map or list is 
 expected at function SIZE, but int is found
 {noformat}
 {noformat} 
 CREATE TABLE t1( symptom STRING,  pattern ARRAYINT,  occurrence INT, index 
 INT);
 CREATE OR REPLACE VIEW v1 AS
 SELECT TRIM(pd.symptom) AS symptom, pd.index, pd.pattern, pd.occurrence, 
 pd.occurrence as cnt from t1 pd;
 SELECT pattern_data.symptom, pattern_data.index, pattern_data.occurrence, 
 pattern_data.cnt, size(pattern_data.pattern) as pattern_length, 
 pattern.pattern_id
 FROM v1 pattern_data LATERAL VIEW explode(pattern) pattern AS pattern_id;
 {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[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 view on top of a view throws RuntimeException
 -

 Key: HIVE-10085
 URL: https://issues.apache.org/jira/browse/HIVE-10085
 Project: Hive
  Issue Type: Bug
  Components: Query Processor
Affects Versions: 1.2.0
Reporter: Aihua Xu
Assignee: Aihua Xu
 Attachments: HIVE-10085.patch


 Following the following sqls to create table and view and execute a select 
 statement. It will throw the runtime exception:
 {noformat}
 FAILED: RuntimeException 
 org.apache.hadoop.hive.ql.exec.UDFArgumentTypeException: map or list is 
 expected at function SIZE, but int is found
 {noformat}
 {noformat} 
 CREATE TABLE t1( symptom STRING,  pattern ARRAYINT,  occurrence INT, index 
 INT);
 CREATE OR REPLACE VIEW v1 AS
 SELECT TRIM(pd.symptom) AS symptom, pd.index, pd.pattern, pd.occurrence, 
 pd.occurrence as cnt from t1 pd;
 SELECT pattern_data.symptom, pattern_data.index, pattern_data.occurrence, 
 pattern_data.cnt, size(pattern_data.pattern) as pattern_length, 
 pattern.pattern_id
 FROM v1 pattern_data LATERAL VIEW explode(pattern) pattern AS pattern_id;
 {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[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 I still need to set 
permission and publish.

 Lateral view on top of a view throws RuntimeException
 -

 Key: HIVE-10085
 URL: https://issues.apache.org/jira/browse/HIVE-10085
 Project: Hive
  Issue Type: Bug
  Components: Query Processor
Affects Versions: 1.2.0
Reporter: Aihua Xu
Assignee: Aihua Xu
 Attachments: HIVE-10085.patch


 Following the following sqls to create table and view and execute a select 
 statement. It will throw the runtime exception:
 {noformat}
 FAILED: RuntimeException 
 org.apache.hadoop.hive.ql.exec.UDFArgumentTypeException: map or list is 
 expected at function SIZE, but int is found
 {noformat}
 {noformat} 
 CREATE TABLE t1( symptom STRING,  pattern ARRAYINT,  occurrence INT, index 
 INT);
 CREATE OR REPLACE VIEW v1 AS
 SELECT TRIM(pd.symptom) AS symptom, pd.index, pd.pattern, pd.occurrence, 
 pd.occurrence as cnt from t1 pd;
 SELECT pattern_data.symptom, pattern_data.index, pattern_data.occurrence, 
 pattern_data.cnt, size(pattern_data.pattern) as pattern_length, 
 pattern.pattern_id
 FROM v1 pattern_data LATERAL VIEW explode(pattern) pattern AS pattern_id;
 {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


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

2015-03-25 Thread Ashutosh Chauhan (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-10085?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14380680#comment-14380680
 ] 

Ashutosh Chauhan commented on HIVE-10085:
-

Above link says:
{noformat}
You don't have access to this review request.
This review request is private. You must be a requested reviewer, either 
directly or on a requested group, and have permission to access the repository 
in order to view this review request.
{noformat}

 Lateral view on top of a view throws RuntimeException
 -

 Key: HIVE-10085
 URL: https://issues.apache.org/jira/browse/HIVE-10085
 Project: Hive
  Issue Type: Bug
  Components: Query Processor
Affects Versions: 1.2.0
Reporter: Aihua Xu
Assignee: Aihua Xu
 Attachments: HIVE-10085.patch


 Following the following sqls to create table and view and execute a select 
 statement. It will throw the runtime exception:
 {noformat}
 FAILED: RuntimeException 
 org.apache.hadoop.hive.ql.exec.UDFArgumentTypeException: map or list is 
 expected at function SIZE, but int is found
 {noformat}
 {noformat} 
 CREATE TABLE t1( symptom STRING,  pattern ARRAYINT,  occurrence INT, index 
 INT);
 CREATE OR REPLACE VIEW v1 AS
 SELECT TRIM(pd.symptom) AS symptom, pd.index, pd.pattern, pd.occurrence, 
 pd.occurrence as cnt from t1 pd;
 SELECT pattern_data.symptom, pattern_data.index, pattern_data.occurrence, 
 pattern_data.cnt, size(pattern_data.pattern) as pattern_length, 
 pattern.pattern_id
 FROM v1 pattern_data LATERAL VIEW explode(pattern) pattern AS pattern_id;
 {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


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

2015-03-25 Thread Hive QA (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-10085?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14381066#comment-14381066
 ] 

Hive QA commented on HIVE-10085:




{color:red}Overall{color}: -1 at least one tests failed

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

{color:red}ERROR:{color} -1 due to 5 failed/errored test(s), 8338 tests executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_skewjoin_mapjoin6
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_skewjoinopt10
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_udaf_percentile_approx_23
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_skewjoinopt10
org.apache.hive.jdbc.TestJdbcWithLocalClusterSpark.testTempTable
{noformat}

Test results: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/3155/testReport
Console output: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/3155/console
Test logs: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-3155/

Messages:
{noformat}
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: 12707263 - PreCommit-HIVE-TRUNK-Build

 Lateral view on top of a view throws RuntimeException
 -

 Key: HIVE-10085
 URL: https://issues.apache.org/jira/browse/HIVE-10085
 Project: Hive
  Issue Type: Bug
  Components: Query Processor
Affects Versions: 1.2.0
Reporter: Aihua Xu
Assignee: Aihua Xu
 Attachments: HIVE-10085.patch


 Following the following sqls to create table and view and execute a select 
 statement. It will throw the runtime exception:
 {noformat}
 FAILED: RuntimeException 
 org.apache.hadoop.hive.ql.exec.UDFArgumentTypeException: map or list is 
 expected at function SIZE, but int is found
 {noformat}
 {noformat} 
 CREATE TABLE t1( symptom STRING,  pattern ARRAYINT,  occurrence INT, index 
 INT);
 CREATE OR REPLACE VIEW v1 AS
 SELECT TRIM(pd.symptom) AS symptom, pd.index, pd.pattern, pd.occurrence, 
 pd.occurrence as cnt from t1 pd;
 SELECT pattern_data.symptom, pattern_data.index, pattern_data.occurrence, 
 pattern_data.cnt, size(pattern_data.pattern) as pattern_length, 
 pattern.pattern_id
 FROM v1 pattern_data LATERAL VIEW explode(pattern) pattern AS pattern_id;
 {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)