[jira] [Commented] (HIVE-20599) CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException
[ https://issues.apache.org/jira/browse/HIVE-20599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16626827#comment-16626827 ] Hive QA commented on HIVE-20599: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12941096/HIVE-20599.4.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:green}SUCCESS:{color} +1 due to 14996 tests passed Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/14032/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/14032/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-14032/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase {noformat} This message is automatically generated. ATTACHMENT ID: 12941096 - PreCommit-HIVE-Build > CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException > --- > > Key: HIVE-20599 > URL: https://issues.apache.org/jira/browse/HIVE-20599 > Project: Hive > Issue Type: Bug > Components: UDF >Affects Versions: 3.1.0 >Reporter: Naresh P R >Assignee: Naresh P R >Priority: Major > Fix For: 3.1.0 > > Attachments: HIVE-20599-branch-3.patch, > HIVE-20599.1-branch-3.1.patch, HIVE-20599.1-branch-3.patch, > HIVE-20599.1.patch, HIVE-20599.2.patch, HIVE-20599.3.patch, HIVE-20599.4.patch > > > SELECT CAST(from_utc_timestamp(timestamp '2018-05-02 15:30:30', 'PST') - > from_utc_timestamp(timestamp '1970-01-30 16:00:00', 'PST') AS STRING); > throws below Exception > {code:java} > Error: Error while compiling statement: FAILED: SemanticException Line 0:-1 > Wrong arguments ''PST'': No matching method for class > org.apache.hadoop.hive.ql.udf.UDFToString with (interval_day_time). Possible > choices: _FUNC_(bigint) _FUNC_(binary) _FUNC_(boolean) _FUNC_(date) > _FUNC_(decimal(38,18)) _FUNC_(double) _FUNC_(float) _FUNC_(int) > _FUNC_(smallint) _FUNC_(string) _FUNC_(timestamp) _FUNC_(tinyint) > _FUNC_(void) (state=42000,code=4){code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20599) CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException
[ https://issues.apache.org/jira/browse/HIVE-20599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16626778#comment-16626778 ] Hive QA commented on HIVE-20599: | (/) *{color:green}+1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 54s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 1m 32s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-14032/dev-support/hive-personality.sh | | git revision | master / e161b01 | | modules | C: ql U: ql | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-14032/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException > --- > > Key: HIVE-20599 > URL: https://issues.apache.org/jira/browse/HIVE-20599 > Project: Hive > Issue Type: Bug > Components: UDF >Affects Versions: 3.1.0 >Reporter: Naresh P R >Assignee: Naresh P R >Priority: Major > Fix For: 3.1.0 > > Attachments: HIVE-20599-branch-3.patch, > HIVE-20599.1-branch-3.1.patch, HIVE-20599.1-branch-3.patch, > HIVE-20599.1.patch, HIVE-20599.2.patch, HIVE-20599.3.patch, HIVE-20599.4.patch > > > SELECT CAST(from_utc_timestamp(timestamp '2018-05-02 15:30:30', 'PST') - > from_utc_timestamp(timestamp '1970-01-30 16:00:00', 'PST') AS STRING); > throws below Exception > {code:java} > Error: Error while compiling statement: FAILED: SemanticException Line 0:-1 > Wrong arguments ''PST'': No matching method for class > org.apache.hadoop.hive.ql.udf.UDFToString with (interval_day_time). Possible > choices: _FUNC_(bigint) _FUNC_(binary) _FUNC_(boolean) _FUNC_(date) > _FUNC_(decimal(38,18)) _FUNC_(double) _FUNC_(float) _FUNC_(int) > _FUNC_(smallint) _FUNC_(string) _FUNC_(timestamp) _FUNC_(tinyint) > _FUNC_(void) (state=42000,code=4){code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20599) CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException
[ https://issues.apache.org/jira/browse/HIVE-20599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16626073#comment-16626073 ] Hive QA commented on HIVE-20599: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12941019/HIVE-20599.3.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 14989 tests executed *Failed tests:* {noformat} TestMiniDruidCliDriver - did not produce a TEST-*.xml file (likely timed out) (batchId=193) [druidmini_dynamic_partition.q,druidmini_test_ts.q,druidmini_expressions.q,druidmini_test_alter.q,druidmini_test_insert.q] {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/14018/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/14018/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-14018/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase 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: 12941019 - PreCommit-HIVE-Build > CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException > --- > > Key: HIVE-20599 > URL: https://issues.apache.org/jira/browse/HIVE-20599 > Project: Hive > Issue Type: Bug > Components: UDF >Affects Versions: 3.1.0 >Reporter: Naresh P R >Assignee: Naresh P R >Priority: Major > Fix For: 3.1.0 > > Attachments: HIVE-20599-branch-3.patch, > HIVE-20599.1-branch-3.1.patch, HIVE-20599.1-branch-3.patch, > HIVE-20599.1.patch, HIVE-20599.2.patch, HIVE-20599.3.patch > > > SELECT CAST(from_utc_timestamp(timestamp '2018-05-02 15:30:30', 'PST') - > from_utc_timestamp(timestamp '1970-01-30 16:00:00', 'PST') AS STRING); > throws below Exception > {code:java} > Error: Error while compiling statement: FAILED: SemanticException Line 0:-1 > Wrong arguments ''PST'': No matching method for class > org.apache.hadoop.hive.ql.udf.UDFToString with (interval_day_time). Possible > choices: _FUNC_(bigint) _FUNC_(binary) _FUNC_(boolean) _FUNC_(date) > _FUNC_(decimal(38,18)) _FUNC_(double) _FUNC_(float) _FUNC_(int) > _FUNC_(smallint) _FUNC_(string) _FUNC_(timestamp) _FUNC_(tinyint) > _FUNC_(void) (state=42000,code=4){code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20599) CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException
[ https://issues.apache.org/jira/browse/HIVE-20599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16625937#comment-16625937 ] Hive QA commented on HIVE-20599: | (/) *{color:green}+1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 52s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 1m 28s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-14018/dev-support/hive-personality.sh | | git revision | master / a51e6ae | | modules | C: ql U: ql | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-14018/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException > --- > > Key: HIVE-20599 > URL: https://issues.apache.org/jira/browse/HIVE-20599 > Project: Hive > Issue Type: Bug > Components: UDF >Affects Versions: 3.1.0 >Reporter: Naresh P R >Assignee: Naresh P R >Priority: Major > Fix For: 3.1.0 > > Attachments: HIVE-20599-branch-3.patch, > HIVE-20599.1-branch-3.1.patch, HIVE-20599.1-branch-3.patch, > HIVE-20599.1.patch, HIVE-20599.2.patch, HIVE-20599.3.patch > > > SELECT CAST(from_utc_timestamp(timestamp '2018-05-02 15:30:30', 'PST') - > from_utc_timestamp(timestamp '1970-01-30 16:00:00', 'PST') AS STRING); > throws below Exception > {code:java} > Error: Error while compiling statement: FAILED: SemanticException Line 0:-1 > Wrong arguments ''PST'': No matching method for class > org.apache.hadoop.hive.ql.udf.UDFToString with (interval_day_time). Possible > choices: _FUNC_(bigint) _FUNC_(binary) _FUNC_(boolean) _FUNC_(date) > _FUNC_(decimal(38,18)) _FUNC_(double) _FUNC_(float) _FUNC_(int) > _FUNC_(smallint) _FUNC_(string) _FUNC_(timestamp) _FUNC_(tinyint) > _FUNC_(void) (state=42000,code=4){code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20599) CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException
[ https://issues.apache.org/jira/browse/HIVE-20599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16625213#comment-16625213 ] Hive QA commented on HIVE-20599: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12940955/HIVE-20599.2.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 14994 tests executed *Failed tests:* {noformat} org.apache.hive.jdbc.miniHS2.TestHs2ConnectionMetricsBinary.testOpenConnectionMetrics (batchId=255) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/14003/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/14003/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-14003/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase 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: 12940955 - PreCommit-HIVE-Build > CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException > --- > > Key: HIVE-20599 > URL: https://issues.apache.org/jira/browse/HIVE-20599 > Project: Hive > Issue Type: Bug > Components: UDF >Affects Versions: 3.1.0 >Reporter: Naresh P R >Assignee: Naresh P R >Priority: Major > Fix For: 3.1.0 > > Attachments: HIVE-20599-branch-3.patch, > HIVE-20599.1-branch-3.1.patch, HIVE-20599.1-branch-3.patch, > HIVE-20599.1.patch, HIVE-20599.2.patch > > > SELECT CAST(from_utc_timestamp(timestamp '2018-05-02 15:30:30', 'PST') - > from_utc_timestamp(timestamp '1970-01-30 16:00:00', 'PST') AS STRING); > throws below Exception > {code:java} > Error: Error while compiling statement: FAILED: SemanticException Line 0:-1 > Wrong arguments ''PST'': No matching method for class > org.apache.hadoop.hive.ql.udf.UDFToString with (interval_day_time). Possible > choices: _FUNC_(bigint) _FUNC_(binary) _FUNC_(boolean) _FUNC_(date) > _FUNC_(decimal(38,18)) _FUNC_(double) _FUNC_(float) _FUNC_(int) > _FUNC_(smallint) _FUNC_(string) _FUNC_(timestamp) _FUNC_(tinyint) > _FUNC_(void) (state=42000,code=4){code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20599) CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException
[ https://issues.apache.org/jira/browse/HIVE-20599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16625180#comment-16625180 ] Hive QA commented on HIVE-20599: | (/) *{color:green}+1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 54s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 1m 31s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-14003/dev-support/hive-personality.sh | | git revision | master / 80fd0ec | | modules | C: ql U: ql | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-14003/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException > --- > > Key: HIVE-20599 > URL: https://issues.apache.org/jira/browse/HIVE-20599 > Project: Hive > Issue Type: Bug > Components: UDF >Affects Versions: 3.1.0 >Reporter: Naresh P R >Assignee: Naresh P R >Priority: Major > Fix For: 3.1.0 > > Attachments: HIVE-20599-branch-3.patch, > HIVE-20599.1-branch-3.1.patch, HIVE-20599.1-branch-3.patch, > HIVE-20599.1.patch, HIVE-20599.2.patch > > > SELECT CAST(from_utc_timestamp(timestamp '2018-05-02 15:30:30', 'PST') - > from_utc_timestamp(timestamp '1970-01-30 16:00:00', 'PST') AS STRING); > throws below Exception > {code:java} > Error: Error while compiling statement: FAILED: SemanticException Line 0:-1 > Wrong arguments ''PST'': No matching method for class > org.apache.hadoop.hive.ql.udf.UDFToString with (interval_day_time). Possible > choices: _FUNC_(bigint) _FUNC_(binary) _FUNC_(boolean) _FUNC_(date) > _FUNC_(decimal(38,18)) _FUNC_(double) _FUNC_(float) _FUNC_(int) > _FUNC_(smallint) _FUNC_(string) _FUNC_(timestamp) _FUNC_(tinyint) > _FUNC_(void) (state=42000,code=4){code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20599) CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException
[ https://issues.apache.org/jira/browse/HIVE-20599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16625027#comment-16625027 ] Prasanth Jayachandran commented on HIVE-20599: -- Uploaded .1 as .2 master patch which is just test change. Hopefully it should get green run for commit. > CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException > --- > > Key: HIVE-20599 > URL: https://issues.apache.org/jira/browse/HIVE-20599 > Project: Hive > Issue Type: Bug > Components: UDF >Affects Versions: 3.1.0 >Reporter: Naresh P R >Assignee: Prasanth Jayachandran >Priority: Major > Fix For: 3.1.0 > > Attachments: HIVE-20599-branch-3.patch, > HIVE-20599.1-branch-3.1.patch, HIVE-20599.1-branch-3.patch, > HIVE-20599.1.patch, HIVE-20599.2.patch > > > SELECT CAST(from_utc_timestamp(timestamp '2018-05-02 15:30:30', 'PST') - > from_utc_timestamp(timestamp '1970-01-30 16:00:00', 'PST') AS STRING); > throws below Exception > {code:java} > Error: Error while compiling statement: FAILED: SemanticException Line 0:-1 > Wrong arguments ''PST'': No matching method for class > org.apache.hadoop.hive.ql.udf.UDFToString with (interval_day_time). Possible > choices: _FUNC_(bigint) _FUNC_(binary) _FUNC_(boolean) _FUNC_(date) > _FUNC_(decimal(38,18)) _FUNC_(double) _FUNC_(float) _FUNC_(int) > _FUNC_(smallint) _FUNC_(string) _FUNC_(timestamp) _FUNC_(tinyint) > _FUNC_(void) (state=42000,code=4){code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20599) CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException
[ https://issues.apache.org/jira/browse/HIVE-20599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16625026#comment-16625026 ] Prasanth Jayachandran commented on HIVE-20599: -- [~nareshpr] branch-3 failures seems to be already existing failures [https://builds.apache.org/view/H-L/view/Hive/job/PreCommit-HIVE-Build/13969/#showFailuresLink] [https://builds.apache.org/view/H-L/view/Hive/job/PreCommit-HIVE-Build/13968/#showFailuresLink] The above test report from some other patches are also showing similar failures. > CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException > --- > > Key: HIVE-20599 > URL: https://issues.apache.org/jira/browse/HIVE-20599 > Project: Hive > Issue Type: Bug > Components: UDF >Affects Versions: 3.1.0 >Reporter: Naresh P R >Assignee: Naresh P R >Priority: Major > Fix For: 3.1.0 > > Attachments: HIVE-20599-branch-3.patch, > HIVE-20599.1-branch-3.1.patch, HIVE-20599.1-branch-3.patch, > HIVE-20599.1.patch, HIVE-20599.2.patch > > > SELECT CAST(from_utc_timestamp(timestamp '2018-05-02 15:30:30', 'PST') - > from_utc_timestamp(timestamp '1970-01-30 16:00:00', 'PST') AS STRING); > throws below Exception > {code:java} > Error: Error while compiling statement: FAILED: SemanticException Line 0:-1 > Wrong arguments ''PST'': No matching method for class > org.apache.hadoop.hive.ql.udf.UDFToString with (interval_day_time). Possible > choices: _FUNC_(bigint) _FUNC_(binary) _FUNC_(boolean) _FUNC_(date) > _FUNC_(decimal(38,18)) _FUNC_(double) _FUNC_(float) _FUNC_(int) > _FUNC_(smallint) _FUNC_(string) _FUNC_(timestamp) _FUNC_(tinyint) > _FUNC_(void) (state=42000,code=4){code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20599) CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException
[ https://issues.apache.org/jira/browse/HIVE-20599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16624820#comment-16624820 ] Hive QA commented on HIVE-20599: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12940780/HIVE-20599.1-branch-3.patch {color:red}ERROR:{color} -1 due to build exiting with an error Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/13980/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/13980/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-13980/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Tests exited with: Exception: Patch URL https://issues.apache.org/jira/secure/attachment/12940780/HIVE-20599.1-branch-3.patch was found in seen patch url's cache and a test was probably run already on it. Aborting... {noformat} This message is automatically generated. ATTACHMENT ID: 12940780 - PreCommit-HIVE-Build > CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException > --- > > Key: HIVE-20599 > URL: https://issues.apache.org/jira/browse/HIVE-20599 > Project: Hive > Issue Type: Bug > Components: UDF >Affects Versions: 3.1.0 >Reporter: Naresh P R >Assignee: Naresh P R >Priority: Major > Fix For: 3.1.0 > > Attachments: HIVE-20599-branch-3.patch, > HIVE-20599.1-branch-3.1.patch, HIVE-20599.1-branch-3.patch, HIVE-20599.1.patch > > > SELECT CAST(from_utc_timestamp(timestamp '2018-05-02 15:30:30', 'PST') - > from_utc_timestamp(timestamp '1970-01-30 16:00:00', 'PST') AS STRING); > throws below Exception > {code:java} > Error: Error while compiling statement: FAILED: SemanticException Line 0:-1 > Wrong arguments ''PST'': No matching method for class > org.apache.hadoop.hive.ql.udf.UDFToString with (interval_day_time). Possible > choices: _FUNC_(bigint) _FUNC_(binary) _FUNC_(boolean) _FUNC_(date) > _FUNC_(decimal(38,18)) _FUNC_(double) _FUNC_(float) _FUNC_(int) > _FUNC_(smallint) _FUNC_(string) _FUNC_(timestamp) _FUNC_(tinyint) > _FUNC_(void) (state=42000,code=4){code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20599) CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException
[ https://issues.apache.org/jira/browse/HIVE-20599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16623779#comment-16623779 ] Hive QA commented on HIVE-20599: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12940780/HIVE-20599.1-branch-3.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 27 failed/errored test(s), 14432 tests executed *Failed tests:* {noformat} TestAlterTableMetadata - did not produce a TEST-*.xml file (likely timed out) (batchId=239) TestAutoPurgeTables - did not produce a TEST-*.xml file (likely timed out) (batchId=239) TestBeeLineDriver - did not produce a TEST-*.xml file (likely timed out) (batchId=260) TestDummy - did not produce a TEST-*.xml file (likely timed out) (batchId=260) TestLocationQueries - did not produce a TEST-*.xml file (likely timed out) (batchId=239) TestMiniDruidCliDriver - did not produce a TEST-*.xml file (likely timed out) (batchId=260) TestMiniDruidKafkaCliDriver - did not produce a TEST-*.xml file (likely timed out) (batchId=260) TestReplicationScenariosAcidTables - did not produce a TEST-*.xml file (likely timed out) (batchId=239) TestSemanticAnalyzerHookLoading - did not produce a TEST-*.xml file (likely timed out) (batchId=239) TestSparkStatistics - did not produce a TEST-*.xml file (likely timed out) (batchId=239) TestTezPerfCliDriver - did not produce a TEST-*.xml file (likely timed out) (batchId=260) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_mv] (batchId=85) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[mm_all] (batchId=71) org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[mm_all] (batchId=154) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[bucket_map_join_tez2] (batchId=159) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[materialized_view_partitioned_2] (batchId=173) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[materialized_view_partitioned_3] (batchId=173) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[materialized_view_rewrite_part_2] (batchId=157) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[results_cache_with_masking] (batchId=175) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[subquery_in] (batchId=173) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[union_assertion_type] (batchId=163) org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver[constprog_semijoin] (batchId=189) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[bucket_map_join_tez2] (batchId=114) org.apache.hadoop.hive.metastore.TestHiveMetaStoreAlterColumnPar.org.apache.hadoop.hive.metastore.TestHiveMetaStoreAlterColumnPar (batchId=234) org.apache.hadoop.hive.ql.TestWarehouseExternalDir.testManagedPaths (batchId=237) org.apache.hive.service.TestHS2ImpersonationWithRemoteMS.testImpersonation (batchId=245) org.apache.hive.spark.client.rpc.TestRpc.testServerPort (batchId=312) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/13953/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/13953/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-13953/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 27 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12940780 - PreCommit-HIVE-Build > CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException > --- > > Key: HIVE-20599 > URL: https://issues.apache.org/jira/browse/HIVE-20599 > Project: Hive > Issue Type: Bug > Components: UDF >Affects Versions: 3.1.0 >Reporter: Naresh P R >Assignee: Naresh P R >Priority: Major > Fix For: 3.1.0 > > Attachments: HIVE-20599-branch-3.patch, > HIVE-20599.1-branch-3.1.patch, HIVE-20599.1-branch-3.patch, HIVE-20599.1.patch > > > SELECT CAST(from_utc_timestamp(timestamp '2018-05-02 15:30:30', 'PST') - > from_utc_timestamp(timestamp '1970-01-30 16:00:00', 'PST') AS STRING); > throws below Exception > {code:java} > Error: Error while compiling statement: FAILED: SemanticException Line 0:-1 > Wrong arguments ''PST'': No matching method for class > org.apache.hadoop.hive.ql.udf.UDFToString with (interval_day_time). Possible > choices: _FUNC_(bigint) _FUNC_(binary) _FUNC_(boolean) _FUNC_(date) > _FUNC_(decima
[jira] [Commented] (HIVE-20599) CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException
[ https://issues.apache.org/jira/browse/HIVE-20599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16623728#comment-16623728 ] Naresh P R commented on HIVE-20599: --- Rebased to branch-3 & attached new patch. > CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException > --- > > Key: HIVE-20599 > URL: https://issues.apache.org/jira/browse/HIVE-20599 > Project: Hive > Issue Type: Bug > Components: UDF >Affects Versions: 3.1.0 >Reporter: Naresh P R >Assignee: Naresh P R >Priority: Major > Fix For: 3.1.0 > > Attachments: HIVE-20599-branch-3.patch, > HIVE-20599.1-branch-3.1.patch, HIVE-20599.1-branch-3.patch, HIVE-20599.1.patch > > > SELECT CAST(from_utc_timestamp(timestamp '2018-05-02 15:30:30', 'PST') - > from_utc_timestamp(timestamp '1970-01-30 16:00:00', 'PST') AS STRING); > throws below Exception > {code:java} > Error: Error while compiling statement: FAILED: SemanticException Line 0:-1 > Wrong arguments ''PST'': No matching method for class > org.apache.hadoop.hive.ql.udf.UDFToString with (interval_day_time). Possible > choices: _FUNC_(bigint) _FUNC_(binary) _FUNC_(boolean) _FUNC_(date) > _FUNC_(decimal(38,18)) _FUNC_(double) _FUNC_(float) _FUNC_(int) > _FUNC_(smallint) _FUNC_(string) _FUNC_(timestamp) _FUNC_(tinyint) > _FUNC_(void) (state=42000,code=4){code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20599) CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException
[ https://issues.apache.org/jira/browse/HIVE-20599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16623673#comment-16623673 ] Hive QA commented on HIVE-20599: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || | {color:red}-1{color} | {color:red} patch {color} | {color:red} 0m 19s{color} | {color:red} /data/hiveptest/logs/PreCommit-HIVE-Build-13953/patches/PreCommit-HIVE-Build-13953.patch does not apply to master. Rebase required? Wrong Branch? See http://cwiki.apache.org/confluence/display/Hive/HowToContribute for help. {color} | \\ \\ || Subsystem || Report/Notes || | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-13953/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException > --- > > Key: HIVE-20599 > URL: https://issues.apache.org/jira/browse/HIVE-20599 > Project: Hive > Issue Type: Bug > Components: UDF >Affects Versions: 3.1.0 >Reporter: Naresh P R >Assignee: Naresh P R >Priority: Major > Fix For: 3.1.0 > > Attachments: HIVE-20599-branch-3.patch, > HIVE-20599.1-branch-3.1.patch, HIVE-20599.1-branch-3.patch, HIVE-20599.1.patch > > > SELECT CAST(from_utc_timestamp(timestamp '2018-05-02 15:30:30', 'PST') - > from_utc_timestamp(timestamp '1970-01-30 16:00:00', 'PST') AS STRING); > throws below Exception > {code:java} > Error: Error while compiling statement: FAILED: SemanticException Line 0:-1 > Wrong arguments ''PST'': No matching method for class > org.apache.hadoop.hive.ql.udf.UDFToString with (interval_day_time). Possible > choices: _FUNC_(bigint) _FUNC_(binary) _FUNC_(boolean) _FUNC_(date) > _FUNC_(decimal(38,18)) _FUNC_(double) _FUNC_(float) _FUNC_(int) > _FUNC_(smallint) _FUNC_(string) _FUNC_(timestamp) _FUNC_(tinyint) > _FUNC_(void) (state=42000,code=4){code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20599) CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException
[ https://issues.apache.org/jira/browse/HIVE-20599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16623661#comment-16623661 ] Hive QA commented on HIVE-20599: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12940653/HIVE-20599-branch-3.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 115 failed/errored test(s), 14432 tests executed *Failed tests:* {noformat} TestAddPartitions - did not produce a TEST-*.xml file (likely timed out) (batchId=228) TestAddPartitionsFromPartSpec - did not produce a TEST-*.xml file (likely timed out) (batchId=230) TestAdminUser - did not produce a TEST-*.xml file (likely timed out) (batchId=236) TestAggregateStatsCache - did not produce a TEST-*.xml file (likely timed out) (batchId=230) TestAlterPartitions - did not produce a TEST-*.xml file (likely timed out) (batchId=230) TestAlterTableMetadata - did not produce a TEST-*.xml file (likely timed out) (batchId=252) TestAppendPartitions - did not produce a TEST-*.xml file (likely timed out) (batchId=230) TestAutoPurgeTables - did not produce a TEST-*.xml file (likely timed out) (batchId=252) TestBeeLineDriver - did not produce a TEST-*.xml file (likely timed out) (batchId=273) TestCachedStore - did not produce a TEST-*.xml file (likely timed out) (batchId=236) TestCatalogCaching - did not produce a TEST-*.xml file (likely timed out) (batchId=236) TestCatalogNonDefaultClient - did not produce a TEST-*.xml file (likely timed out) (batchId=228) TestCatalogNonDefaultSvr - did not produce a TEST-*.xml file (likely timed out) (batchId=236) TestCatalogOldClient - did not produce a TEST-*.xml file (likely timed out) (batchId=228) TestCatalogs - did not produce a TEST-*.xml file (likely timed out) (batchId=230) TestCheckConstraint - did not produce a TEST-*.xml file (likely timed out) (batchId=228) TestDataSourceProviderFactory - did not produce a TEST-*.xml file (likely timed out) (batchId=238) TestDatabases - did not produce a TEST-*.xml file (likely timed out) (batchId=230) TestDeadline - did not produce a TEST-*.xml file (likely timed out) (batchId=236) TestDefaultConstraint - did not produce a TEST-*.xml file (likely timed out) (batchId=230) TestDropPartitions - did not produce a TEST-*.xml file (likely timed out) (batchId=228) TestDummy - did not produce a TEST-*.xml file (likely timed out) (batchId=273) TestEmbeddedHiveMetaStore - did not produce a TEST-*.xml file (likely timed out) (batchId=231) TestExchangePartitions - did not produce a TEST-*.xml file (likely timed out) (batchId=230) TestFMSketchSerialization - did not produce a TEST-*.xml file (likely timed out) (batchId=238) TestFilterHooks - did not produce a TEST-*.xml file (likely timed out) (batchId=228) TestForeignKey - did not produce a TEST-*.xml file (likely timed out) (batchId=230) TestFunctions - did not produce a TEST-*.xml file (likely timed out) (batchId=228) TestGetPartitions - did not produce a TEST-*.xml file (likely timed out) (batchId=228) TestGetTableMeta - did not produce a TEST-*.xml file (likely timed out) (batchId=228) TestHLLNoBias - did not produce a TEST-*.xml file (likely timed out) (batchId=238) TestHLLSerialization - did not produce a TEST-*.xml file (likely timed out) (batchId=238) TestHdfsUtils - did not produce a TEST-*.xml file (likely timed out) (batchId=236) TestHiveAlterHandler - did not produce a TEST-*.xml file (likely timed out) (batchId=228) TestHiveMetaStoreGetMetaConf - did not produce a TEST-*.xml file (likely timed out) (batchId=236) TestHiveMetaStorePartitionSpecs - did not produce a TEST-*.xml file (likely timed out) (batchId=230) TestHiveMetaStoreSchemaMethods - did not produce a TEST-*.xml file (likely timed out) (batchId=236) TestHiveMetaStoreTimeout - did not produce a TEST-*.xml file (likely timed out) (batchId=238) TestHiveMetaStoreTxns - did not produce a TEST-*.xml file (likely timed out) (batchId=238) TestHiveMetaStoreWithEnvironmentContext - did not produce a TEST-*.xml file (likely timed out) (batchId=233) TestHiveMetastoreCli - did not produce a TEST-*.xml file (likely timed out) (batchId=228) TestHyperLogLog - did not produce a TEST-*.xml file (likely timed out) (batchId=238) TestHyperLogLogDense - did not produce a TEST-*.xml file (likely timed out) (batchId=238) TestHyperLogLogMerge - did not produce a TEST-*.xml file (likely timed out) (batchId=238) TestHyperLogLogSparse - did not produce a TEST-*.xml file (likely timed out) (batchId=238) TestJSONMessageDeserializer - did not produce a TEST-*.xml file (likely timed out) (batchId=236) TestListPartitions - did not produce a TEST-*.xml file (likely timed out) (batchId=228) TestLocationQueries - did not produce a TEST-*.xml file (likely timed out) (batchId=252) TestLockRequestBuilder - did not produce a TEST-*.xml file
[jira] [Commented] (HIVE-20599) CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException
[ https://issues.apache.org/jira/browse/HIVE-20599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16623560#comment-16623560 ] Hive QA commented on HIVE-20599: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || | {color:red}-1{color} | {color:red} patch {color} | {color:red} 0m 10s{color} | {color:red} /data/hiveptest/logs/PreCommit-HIVE-Build-13951/patches/PreCommit-HIVE-Build-13951.patch does not apply to master. Rebase required? Wrong Branch? See http://cwiki.apache.org/confluence/display/Hive/HowToContribute for help. {color} | \\ \\ || Subsystem || Report/Notes || | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-13951/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException > --- > > Key: HIVE-20599 > URL: https://issues.apache.org/jira/browse/HIVE-20599 > Project: Hive > Issue Type: Bug > Components: UDF >Affects Versions: 3.1.0 >Reporter: Naresh P R >Assignee: Naresh P R >Priority: Major > Fix For: 3.1.0 > > Attachments: HIVE-20599-branch-3.patch, > HIVE-20599.1-branch-3.1.patch, HIVE-20599.1.patch > > > SELECT CAST(from_utc_timestamp(timestamp '2018-05-02 15:30:30', 'PST') - > from_utc_timestamp(timestamp '1970-01-30 16:00:00', 'PST') AS STRING); > throws below Exception > {code:java} > Error: Error while compiling statement: FAILED: SemanticException Line 0:-1 > Wrong arguments ''PST'': No matching method for class > org.apache.hadoop.hive.ql.udf.UDFToString with (interval_day_time). Possible > choices: _FUNC_(bigint) _FUNC_(binary) _FUNC_(boolean) _FUNC_(date) > _FUNC_(decimal(38,18)) _FUNC_(double) _FUNC_(float) _FUNC_(int) > _FUNC_(smallint) _FUNC_(string) _FUNC_(timestamp) _FUNC_(tinyint) > _FUNC_(void) (state=42000,code=4){code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20599) CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException
[ https://issues.apache.org/jira/browse/HIVE-20599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16621994#comment-16621994 ] Naresh P R commented on HIVE-20599: --- Testcase failures are not related to changes. > CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException > --- > > Key: HIVE-20599 > URL: https://issues.apache.org/jira/browse/HIVE-20599 > Project: Hive > Issue Type: Bug > Components: UDF >Affects Versions: 3.1.0 >Reporter: Naresh P R >Assignee: Naresh P R >Priority: Major > Fix For: 3.1.0 > > Attachments: HIVE-20599.1-branch-3.1.patch, HIVE-20599.1.patch > > > SELECT CAST(from_utc_timestamp(timestamp '2018-05-02 15:30:30', 'PST') - > from_utc_timestamp(timestamp '1970-01-30 16:00:00', 'PST') AS STRING); > throws below Exception > {code:java} > Error: Error while compiling statement: FAILED: SemanticException Line 0:-1 > Wrong arguments ''PST'': No matching method for class > org.apache.hadoop.hive.ql.udf.UDFToString with (interval_day_time). Possible > choices: _FUNC_(bigint) _FUNC_(binary) _FUNC_(boolean) _FUNC_(date) > _FUNC_(decimal(38,18)) _FUNC_(double) _FUNC_(float) _FUNC_(int) > _FUNC_(smallint) _FUNC_(string) _FUNC_(timestamp) _FUNC_(tinyint) > _FUNC_(void) (state=42000,code=4){code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20599) CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException
[ https://issues.apache.org/jira/browse/HIVE-20599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16621697#comment-16621697 ] Hive QA commented on HIVE-20599: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12940451/HIVE-20599.1.patch {color:red}ERROR:{color} -1 due to build exiting with an error Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/13926/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/13926/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-13926/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Tests exited with: Exception: Patch URL https://issues.apache.org/jira/secure/attachment/12940451/HIVE-20599.1.patch was found in seen patch url's cache and a test was probably run already on it. Aborting... {noformat} This message is automatically generated. ATTACHMENT ID: 12940451 - PreCommit-HIVE-Build > CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException > --- > > Key: HIVE-20599 > URL: https://issues.apache.org/jira/browse/HIVE-20599 > Project: Hive > Issue Type: Bug > Components: UDF >Affects Versions: 3.1.0 >Reporter: Naresh P R >Assignee: Naresh P R >Priority: Major > Fix For: 3.1.0 > > Attachments: HIVE-20599.1-branch-3.1.patch, HIVE-20599.1.patch > > > SELECT CAST(from_utc_timestamp(timestamp '2018-05-02 15:30:30', 'PST') - > from_utc_timestamp(timestamp '1970-01-30 16:00:00', 'PST') AS STRING); > throws below Exception > {code:java} > Error: Error while compiling statement: FAILED: SemanticException Line 0:-1 > Wrong arguments ''PST'': No matching method for class > org.apache.hadoop.hive.ql.udf.UDFToString with (interval_day_time). Possible > choices: _FUNC_(bigint) _FUNC_(binary) _FUNC_(boolean) _FUNC_(date) > _FUNC_(decimal(38,18)) _FUNC_(double) _FUNC_(float) _FUNC_(int) > _FUNC_(smallint) _FUNC_(string) _FUNC_(timestamp) _FUNC_(tinyint) > _FUNC_(void) (state=42000,code=4){code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20599) CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException
[ https://issues.apache.org/jira/browse/HIVE-20599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16621694#comment-16621694 ] Hive QA commented on HIVE-20599: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12940451/HIVE-20599.1.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 3 failed/errored test(s), 14993 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.ql.exec.spark.TestSparkSessionTimeout.testMultiSessionSparkSessionTimeout (batchId=245) org.apache.hadoop.hive.ql.exec.spark.TestSparkSessionTimeout.testMultiSparkSessionTimeout (batchId=245) org.apache.hive.jdbc.TestJdbcWithMiniLlapArrow.testComplexQuery (batchId=251) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/13925/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/13925/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-13925/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 3 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12940451 - PreCommit-HIVE-Build > CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException > --- > > Key: HIVE-20599 > URL: https://issues.apache.org/jira/browse/HIVE-20599 > Project: Hive > Issue Type: Bug > Components: UDF >Affects Versions: 3.1.0 >Reporter: Naresh P R >Assignee: Naresh P R >Priority: Major > Fix For: 3.1.0 > > Attachments: HIVE-20599.1-branch-3.1.patch, HIVE-20599.1.patch > > > SELECT CAST(from_utc_timestamp(timestamp '2018-05-02 15:30:30', 'PST') - > from_utc_timestamp(timestamp '1970-01-30 16:00:00', 'PST') AS STRING); > throws below Exception > {code:java} > Error: Error while compiling statement: FAILED: SemanticException Line 0:-1 > Wrong arguments ''PST'': No matching method for class > org.apache.hadoop.hive.ql.udf.UDFToString with (interval_day_time). Possible > choices: _FUNC_(bigint) _FUNC_(binary) _FUNC_(boolean) _FUNC_(date) > _FUNC_(decimal(38,18)) _FUNC_(double) _FUNC_(float) _FUNC_(int) > _FUNC_(smallint) _FUNC_(string) _FUNC_(timestamp) _FUNC_(tinyint) > _FUNC_(void) (state=42000,code=4){code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20599) CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException
[ https://issues.apache.org/jira/browse/HIVE-20599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16621625#comment-16621625 ] Hive QA commented on HIVE-20599: | (/) *{color:green}+1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 1s{color} | {color:green} The patch has no whitespace issues. {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 59s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 1m 37s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-13925/dev-support/hive-personality.sh | | git revision | master / 9b376a7 | | modules | C: ql U: ql | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-13925/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException > --- > > Key: HIVE-20599 > URL: https://issues.apache.org/jira/browse/HIVE-20599 > Project: Hive > Issue Type: Bug > Components: UDF >Affects Versions: 3.1.0 >Reporter: Naresh P R >Assignee: Naresh P R >Priority: Major > Fix For: 3.1.0 > > Attachments: HIVE-20599.1-branch-3.1.patch, HIVE-20599.1.patch > > > SELECT CAST(from_utc_timestamp(timestamp '2018-05-02 15:30:30', 'PST') - > from_utc_timestamp(timestamp '1970-01-30 16:00:00', 'PST') AS STRING); > throws below Exception > {code:java} > Error: Error while compiling statement: FAILED: SemanticException Line 0:-1 > Wrong arguments ''PST'': No matching method for class > org.apache.hadoop.hive.ql.udf.UDFToString with (interval_day_time). Possible > choices: _FUNC_(bigint) _FUNC_(binary) _FUNC_(boolean) _FUNC_(date) > _FUNC_(decimal(38,18)) _FUNC_(double) _FUNC_(float) _FUNC_(int) > _FUNC_(smallint) _FUNC_(string) _FUNC_(timestamp) _FUNC_(tinyint) > _FUNC_(void) (state=42000,code=4){code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20599) CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException
[ https://issues.apache.org/jira/browse/HIVE-20599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16621166#comment-16621166 ] Prasanth Jayachandran commented on HIVE-20599: -- lgtm, +1. pending tests > CAST(INTERVAL_DAY_TIME AS STRING) is throwing SemanticException > --- > > Key: HIVE-20599 > URL: https://issues.apache.org/jira/browse/HIVE-20599 > Project: Hive > Issue Type: Bug > Components: UDF >Affects Versions: 3.1.0 >Reporter: Naresh P R >Assignee: Naresh P R >Priority: Major > Fix For: 3.1.0 > > Attachments: HIVE-20599.1-branch-3.1.patch, HIVE-20599.1.patch > > > SELECT CAST(from_utc_timestamp(timestamp '2018-05-02 15:30:30', 'PST') - > from_utc_timestamp(timestamp '1970-01-30 16:00:00', 'PST') AS STRING); > throws below Exception > {code:java} > Error: Error while compiling statement: FAILED: SemanticException Line 0:-1 > Wrong arguments ''PST'': No matching method for class > org.apache.hadoop.hive.ql.udf.UDFToString with (interval_day_time). Possible > choices: _FUNC_(bigint) _FUNC_(binary) _FUNC_(boolean) _FUNC_(date) > _FUNC_(decimal(38,18)) _FUNC_(double) _FUNC_(float) _FUNC_(int) > _FUNC_(smallint) _FUNC_(string) _FUNC_(timestamp) _FUNC_(tinyint) > _FUNC_(void) (state=42000,code=4){code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)