[jira] [Commented] (HIVE-10085) Lateral view on top of a view throws RuntimeException
[
https://issues.apache.org/jira/browse/HIVE-10085?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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 ARRAY, 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
[
https://issues.apache.org/jira/browse/HIVE-10085?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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 ARRAY, 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
[
https://issues.apache.org/jira/browse/HIVE-10085?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14381168#comment-14381168
]
Ashutosh Chauhan commented on HIVE-10085:
-
+1
> 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 ARRAY, 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
[
https://issues.apache.org/jira/browse/HIVE-10085?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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 ARRAY, 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
[
https://issues.apache.org/jira/browse/HIVE-10085?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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 ARRAY, 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
[
https://issues.apache.org/jira/browse/HIVE-10085?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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 ARRAY, 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
[
https://issues.apache.org/jira/browse/HIVE-10085?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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 ARRAY, 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
[
https://issues.apache.org/jira/browse/HIVE-10085?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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 ARRAY, 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
[
https://issues.apache.org/jira/browse/HIVE-10085?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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 ARRAY, 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)
