[jira] [Commented] (HIVE-4144) Add "select database()" command to show the current database
[ https://issues.apache.org/jira/browse/HIVE-4144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14068174#comment-14068174 ] Lefty Leverenz commented on HIVE-4144: -- This is a function, so documentation will go in the UDF wiki. If I understand correctly, the function name is current_database() instead of database() as shown in the jira title. In addition to the UDF doc, this can be mentioned in other places where USE db_name is discussed. Currently that would be the "Use Database" and "Create Table" sections of the DDL doc and the Select doc. Quick reference (docs not updated yet): * [Operators and UDFs -- Misc. Functions (or separate section "Current Database Function") | https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-Misc.Functions] * [DDL -- Use Database | https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-UseDatabase] * [DDL -- Create Table | https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-CreateTable] * [Select -- Select Syntax | https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Select#LanguageManualSelect-SelectSyntax] > Add "select database()" command to show the current database > > > Key: HIVE-4144 > URL: https://issues.apache.org/jira/browse/HIVE-4144 > Project: Hive > Issue Type: Bug > Components: SQL >Reporter: Mark Grover >Assignee: Navis > Labels: TODOC13 > Fix For: 0.13.0 > > Attachments: D9597.5.patch, HIVE-4144.10.patch.txt, > HIVE-4144.11.patch.txt, HIVE-4144.12.patch.txt, HIVE-4144.13.patch.txt, > HIVE-4144.14.patch.txt, HIVE-4144.6.patch.txt, HIVE-4144.7.patch.txt, > HIVE-4144.8.patch.txt, HIVE-4144.9.patch.txt, HIVE-4144.D9597.1.patch, > HIVE-4144.D9597.2.patch, HIVE-4144.D9597.3.patch, HIVE-4144.D9597.4.patch > > > A recent hive-user mailing list conversation asked about having a command to > show the current database. > http://mail-archives.apache.org/mod_mbox/hive-user/201303.mbox/%3CCAMGr+0i+CRY69m3id=DxthmUCWLf0NxpKMCtROb=uauh2va...@mail.gmail.com%3E > MySQL seems to have a command to do so: > {code} > select database(); > {code} > http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_database > We should look into having something similar in Hive. -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Commented] (HIVE-4144) Add "select database()" command to show the current database
[ https://issues.apache.org/jira/browse/HIVE-4144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13892913#comment-13892913 ] Navis commented on HIVE-4144: - Precommit test makes me really lazy. I've forgot to update result file. > Add "select database()" command to show the current database > > > Key: HIVE-4144 > URL: https://issues.apache.org/jira/browse/HIVE-4144 > Project: Hive > Issue Type: Bug > Components: SQL >Reporter: Mark Grover >Assignee: Navis > Attachments: D9597.5.patch, HIVE-4144.10.patch.txt, > HIVE-4144.11.patch.txt, HIVE-4144.12.patch.txt, HIVE-4144.13.patch.txt, > HIVE-4144.14.patch.txt, HIVE-4144.6.patch.txt, HIVE-4144.7.patch.txt, > HIVE-4144.8.patch.txt, HIVE-4144.9.patch.txt, HIVE-4144.D9597.1.patch, > HIVE-4144.D9597.2.patch, HIVE-4144.D9597.3.patch, HIVE-4144.D9597.4.patch > > > A recent hive-user mailing list conversation asked about having a command to > show the current database. > http://mail-archives.apache.org/mod_mbox/hive-user/201303.mbox/%3CCAMGr+0i+CRY69m3id=DxthmUCWLf0NxpKMCtROb=uauh2va...@mail.gmail.com%3E > MySQL seems to have a command to do so: > {code} > select database(); > {code} > http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_database > We should look into having something similar in Hive. -- This message was sent by Atlassian JIRA (v6.1.5#6160)
[jira] [Commented] (HIVE-4144) Add "select database()" command to show the current database
[ https://issues.apache.org/jira/browse/HIVE-4144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13892299#comment-13892299 ] Hive QA commented on HIVE-4144: --- {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/12627053/HIVE-4144.14.patch.txt {color:red}ERROR:{color} -1 due to 2 failed/errored test(s), 5012 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_select_dummy_source org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_udf_current_database {noformat} Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1202/testReport Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1202/console 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: 2 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12627053 > Add "select database()" command to show the current database > > > Key: HIVE-4144 > URL: https://issues.apache.org/jira/browse/HIVE-4144 > Project: Hive > Issue Type: Bug > Components: SQL >Reporter: Mark Grover >Assignee: Navis > Attachments: D9597.5.patch, HIVE-4144.10.patch.txt, > HIVE-4144.11.patch.txt, HIVE-4144.12.patch.txt, HIVE-4144.13.patch.txt, > HIVE-4144.14.patch.txt, HIVE-4144.6.patch.txt, HIVE-4144.7.patch.txt, > HIVE-4144.8.patch.txt, HIVE-4144.9.patch.txt, HIVE-4144.D9597.1.patch, > HIVE-4144.D9597.2.patch, HIVE-4144.D9597.3.patch, HIVE-4144.D9597.4.patch > > > A recent hive-user mailing list conversation asked about having a command to > show the current database. > http://mail-archives.apache.org/mod_mbox/hive-user/201303.mbox/%3CCAMGr+0i+CRY69m3id=DxthmUCWLf0NxpKMCtROb=uauh2va...@mail.gmail.com%3E > MySQL seems to have a command to do so: > {code} > select database(); > {code} > http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_database > We should look into having something similar in Hive. -- This message was sent by Atlassian JIRA (v6.1.5#6160)
[jira] [Commented] (HIVE-4144) Add "select database()" command to show the current database
[ https://issues.apache.org/jira/browse/HIVE-4144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13891609#comment-13891609 ] Navis commented on HIVE-4144: - There was an issue to check privilege for dummy table so added skipping of it. Let's see test results. > Add "select database()" command to show the current database > > > Key: HIVE-4144 > URL: https://issues.apache.org/jira/browse/HIVE-4144 > Project: Hive > Issue Type: Bug > Components: SQL >Reporter: Mark Grover >Assignee: Navis > Attachments: D9597.5.patch, HIVE-4144.10.patch.txt, > HIVE-4144.11.patch.txt, HIVE-4144.12.patch.txt, HIVE-4144.13.patch.txt, > HIVE-4144.14.patch.txt, HIVE-4144.6.patch.txt, HIVE-4144.7.patch.txt, > HIVE-4144.8.patch.txt, HIVE-4144.9.patch.txt, HIVE-4144.D9597.1.patch, > HIVE-4144.D9597.2.patch, HIVE-4144.D9597.3.patch, HIVE-4144.D9597.4.patch > > > A recent hive-user mailing list conversation asked about having a command to > show the current database. > http://mail-archives.apache.org/mod_mbox/hive-user/201303.mbox/%3CCAMGr+0i+CRY69m3id=DxthmUCWLf0NxpKMCtROb=uauh2va...@mail.gmail.com%3E > MySQL seems to have a command to do so: > {code} > select database(); > {code} > http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_database > We should look into having something similar in Hive. -- This message was sent by Atlassian JIRA (v6.1.5#6160)
[jira] [Commented] (HIVE-4144) Add "select database()" command to show the current database
[ https://issues.apache.org/jira/browse/HIVE-4144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13890949#comment-13890949 ] Prasad Mujumdar commented on HIVE-4144: --- +1 Just restating since the patch was changed/rebased. > Add "select database()" command to show the current database > > > Key: HIVE-4144 > URL: https://issues.apache.org/jira/browse/HIVE-4144 > Project: Hive > Issue Type: Bug > Components: SQL >Reporter: Mark Grover >Assignee: Navis > Attachments: D9597.5.patch, HIVE-4144.10.patch.txt, > HIVE-4144.11.patch.txt, HIVE-4144.12.patch.txt, HIVE-4144.13.patch.txt, > HIVE-4144.6.patch.txt, HIVE-4144.7.patch.txt, HIVE-4144.8.patch.txt, > HIVE-4144.9.patch.txt, HIVE-4144.D9597.1.patch, HIVE-4144.D9597.2.patch, > HIVE-4144.D9597.3.patch, HIVE-4144.D9597.4.patch > > > A recent hive-user mailing list conversation asked about having a command to > show the current database. > http://mail-archives.apache.org/mod_mbox/hive-user/201303.mbox/%3CCAMGr+0i+CRY69m3id=DxthmUCWLf0NxpKMCtROb=uauh2va...@mail.gmail.com%3E > MySQL seems to have a command to do so: > {code} > select database(); > {code} > http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_database > We should look into having something similar in Hive. -- This message was sent by Atlassian JIRA (v6.1.5#6160)
[jira] [Commented] (HIVE-4144) Add "select database()" command to show the current database
[ https://issues.apache.org/jira/browse/HIVE-4144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13890151#comment-13890151 ] Navis commented on HIVE-4144: - Cannot reproduce. Seemed not related. > Add "select database()" command to show the current database > > > Key: HIVE-4144 > URL: https://issues.apache.org/jira/browse/HIVE-4144 > Project: Hive > Issue Type: Bug > Components: SQL >Reporter: Mark Grover >Assignee: Navis > Attachments: D9597.5.patch, HIVE-4144.10.patch.txt, > HIVE-4144.11.patch.txt, HIVE-4144.12.patch.txt, HIVE-4144.13.patch.txt, > HIVE-4144.6.patch.txt, HIVE-4144.7.patch.txt, HIVE-4144.8.patch.txt, > HIVE-4144.9.patch.txt, HIVE-4144.D9597.1.patch, HIVE-4144.D9597.2.patch, > HIVE-4144.D9597.3.patch, HIVE-4144.D9597.4.patch > > > A recent hive-user mailing list conversation asked about having a command to > show the current database. > http://mail-archives.apache.org/mod_mbox/hive-user/201303.mbox/%3CCAMGr+0i+CRY69m3id=DxthmUCWLf0NxpKMCtROb=uauh2va...@mail.gmail.com%3E > MySQL seems to have a command to do so: > {code} > select database(); > {code} > http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_database > We should look into having something similar in Hive. -- This message was sent by Atlassian JIRA (v6.1.5#6160)
[jira] [Commented] (HIVE-4144) Add "select database()" command to show the current database
[ https://issues.apache.org/jira/browse/HIVE-4144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13889712#comment-13889712 ] Hive QA commented on HIVE-4144: --- {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/12626617/HIVE-4144.13.patch.txt {color:red}ERROR:{color} -1 due to 2 failed/errored test(s), 4999 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_auto_sortmerge_join_16 org.apache.hcatalog.hbase.snapshot.lock.TestWriteLock.testRun {noformat} Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1166/testReport Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1166/console 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: 2 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12626617 > Add "select database()" command to show the current database > > > Key: HIVE-4144 > URL: https://issues.apache.org/jira/browse/HIVE-4144 > Project: Hive > Issue Type: Bug > Components: SQL >Reporter: Mark Grover >Assignee: Navis > Attachments: D9597.5.patch, HIVE-4144.10.patch.txt, > HIVE-4144.11.patch.txt, HIVE-4144.12.patch.txt, HIVE-4144.13.patch.txt, > HIVE-4144.6.patch.txt, HIVE-4144.7.patch.txt, HIVE-4144.8.patch.txt, > HIVE-4144.9.patch.txt, HIVE-4144.D9597.1.patch, HIVE-4144.D9597.2.patch, > HIVE-4144.D9597.3.patch, HIVE-4144.D9597.4.patch > > > A recent hive-user mailing list conversation asked about having a command to > show the current database. > http://mail-archives.apache.org/mod_mbox/hive-user/201303.mbox/%3CCAMGr+0i+CRY69m3id=DxthmUCWLf0NxpKMCtROb=uauh2va...@mail.gmail.com%3E > MySQL seems to have a command to do so: > {code} > select database(); > {code} > http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_database > We should look into having something similar in Hive. -- This message was sent by Atlassian JIRA (v6.1.5#6160)
[jira] [Commented] (HIVE-4144) Add "select database()" command to show the current database
[ https://issues.apache.org/jira/browse/HIVE-4144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13889308#comment-13889308 ] Navis commented on HIVE-4144: - Rebased to trunk > Add "select database()" command to show the current database > > > Key: HIVE-4144 > URL: https://issues.apache.org/jira/browse/HIVE-4144 > Project: Hive > Issue Type: Bug > Components: SQL >Reporter: Mark Grover >Assignee: Navis > Attachments: D9597.5.patch, HIVE-4144.10.patch.txt, > HIVE-4144.11.patch.txt, HIVE-4144.12.patch.txt, HIVE-4144.13.patch.txt, > HIVE-4144.6.patch.txt, HIVE-4144.7.patch.txt, HIVE-4144.8.patch.txt, > HIVE-4144.9.patch.txt, HIVE-4144.D9597.1.patch, HIVE-4144.D9597.2.patch, > HIVE-4144.D9597.3.patch, HIVE-4144.D9597.4.patch > > > A recent hive-user mailing list conversation asked about having a command to > show the current database. > http://mail-archives.apache.org/mod_mbox/hive-user/201303.mbox/%3CCAMGr+0i+CRY69m3id=DxthmUCWLf0NxpKMCtROb=uauh2va...@mail.gmail.com%3E > MySQL seems to have a command to do so: > {code} > select database(); > {code} > http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_database > We should look into having something similar in Hive. -- This message was sent by Atlassian JIRA (v6.1.5#6160)
[jira] [Commented] (HIVE-4144) Add "select database()" command to show the current database
[ https://issues.apache.org/jira/browse/HIVE-4144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13889299#comment-13889299 ] Hive QA commented on HIVE-4144: --- {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/12626585/HIVE-4144.12.patch.txt {color:red}ERROR:{color} -1 due to 4 failed/errored test(s), 4999 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_select_dummy_source org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_udf_current_database org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_auto_sortmerge_join_16 org.apache.hadoop.hive.cli.TestNegativeMinimrCliDriver.testNegativeCliDriver_mapreduce_stack_trace_hadoop20 {noformat} Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1159/testReport Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1159/console 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: 4 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12626585 > Add "select database()" command to show the current database > > > Key: HIVE-4144 > URL: https://issues.apache.org/jira/browse/HIVE-4144 > Project: Hive > Issue Type: Bug > Components: SQL >Reporter: Mark Grover >Assignee: Navis > Attachments: D9597.5.patch, HIVE-4144.10.patch.txt, > HIVE-4144.11.patch.txt, HIVE-4144.12.patch.txt, HIVE-4144.6.patch.txt, > HIVE-4144.7.patch.txt, HIVE-4144.8.patch.txt, HIVE-4144.9.patch.txt, > HIVE-4144.D9597.1.patch, HIVE-4144.D9597.2.patch, HIVE-4144.D9597.3.patch, > HIVE-4144.D9597.4.patch > > > A recent hive-user mailing list conversation asked about having a command to > show the current database. > http://mail-archives.apache.org/mod_mbox/hive-user/201303.mbox/%3CCAMGr+0i+CRY69m3id=DxthmUCWLf0NxpKMCtROb=uauh2va...@mail.gmail.com%3E > MySQL seems to have a command to do so: > {code} > select database(); > {code} > http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_database > We should look into having something similar in Hive. -- This message was sent by Atlassian JIRA (v6.1.5#6160)
[jira] [Commented] (HIVE-4144) Add "select database()" command to show the current database
[ https://issues.apache.org/jira/browse/HIVE-4144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13888255#comment-13888255 ] Prasad Mujumdar commented on HIVE-4144: --- +1 I have a couple of minor comments on the reviewboard, but those can be addressed in separate patch later. > Add "select database()" command to show the current database > > > Key: HIVE-4144 > URL: https://issues.apache.org/jira/browse/HIVE-4144 > Project: Hive > Issue Type: Bug > Components: SQL >Reporter: Mark Grover >Assignee: Navis > Attachments: D9597.5.patch, HIVE-4144.10.patch.txt, > HIVE-4144.11.patch.txt, HIVE-4144.6.patch.txt, HIVE-4144.7.patch.txt, > HIVE-4144.8.patch.txt, HIVE-4144.9.patch.txt, HIVE-4144.D9597.1.patch, > HIVE-4144.D9597.2.patch, HIVE-4144.D9597.3.patch, HIVE-4144.D9597.4.patch > > > A recent hive-user mailing list conversation asked about having a command to > show the current database. > http://mail-archives.apache.org/mod_mbox/hive-user/201303.mbox/%3CCAMGr+0i+CRY69m3id=DxthmUCWLf0NxpKMCtROb=uauh2va...@mail.gmail.com%3E > MySQL seems to have a command to do so: > {code} > select database(); > {code} > http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_database > We should look into having something similar in Hive. -- This message was sent by Atlassian JIRA (v6.1.5#6160)
[jira] [Commented] (HIVE-4144) Add "select database()" command to show the current database
[ https://issues.apache.org/jira/browse/HIVE-4144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13874230#comment-13874230 ] Navis commented on HIVE-4144: - [~leftylev] Most(all?)) of rdbs support single line select without real table, something like 'select 1+1'. This issue can help things like that rather than just showing current database. > Add "select database()" command to show the current database > > > Key: HIVE-4144 > URL: https://issues.apache.org/jira/browse/HIVE-4144 > Project: Hive > Issue Type: Bug > Components: SQL >Reporter: Mark Grover >Assignee: Navis > Attachments: D9597.5.patch, HIVE-4144.10.patch.txt, > HIVE-4144.11.patch.txt, HIVE-4144.6.patch.txt, HIVE-4144.7.patch.txt, > HIVE-4144.8.patch.txt, HIVE-4144.9.patch.txt, HIVE-4144.D9597.1.patch, > HIVE-4144.D9597.2.patch, HIVE-4144.D9597.3.patch, HIVE-4144.D9597.4.patch > > > A recent hive-user mailing list conversation asked about having a command to > show the current database. > http://mail-archives.apache.org/mod_mbox/hive-user/201303.mbox/%3CCAMGr+0i+CRY69m3id=DxthmUCWLf0NxpKMCtROb=uauh2va...@mail.gmail.com%3E > MySQL seems to have a command to do so: > {code} > select database(); > {code} > http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_database > We should look into having something similar in Hive. -- This message was sent by Atlassian JIRA (v6.1.5#6160)
[jira] [Commented] (HIVE-4144) Add "select database()" command to show the current database
[ https://issues.apache.org/jira/browse/HIVE-4144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13873285#comment-13873285 ] Lefty Leverenz commented on HIVE-4144: -- Just curious: why is this a SELECT statement rather than a variant of SHOW DATABASES? > Add "select database()" command to show the current database > > > Key: HIVE-4144 > URL: https://issues.apache.org/jira/browse/HIVE-4144 > Project: Hive > Issue Type: Bug > Components: SQL >Reporter: Mark Grover >Assignee: Navis > Attachments: D9597.5.patch, HIVE-4144.10.patch.txt, > HIVE-4144.11.patch.txt, HIVE-4144.6.patch.txt, HIVE-4144.7.patch.txt, > HIVE-4144.8.patch.txt, HIVE-4144.9.patch.txt, HIVE-4144.D9597.1.patch, > HIVE-4144.D9597.2.patch, HIVE-4144.D9597.3.patch, HIVE-4144.D9597.4.patch > > > A recent hive-user mailing list conversation asked about having a command to > show the current database. > http://mail-archives.apache.org/mod_mbox/hive-user/201303.mbox/%3CCAMGr+0i+CRY69m3id=DxthmUCWLf0NxpKMCtROb=uauh2va...@mail.gmail.com%3E > MySQL seems to have a command to do so: > {code} > select database(); > {code} > http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_database > We should look into having something similar in Hive. -- This message was sent by Atlassian JIRA (v6.1.5#6160)
[jira] [Commented] (HIVE-4144) Add "select database()" command to show the current database
[ https://issues.apache.org/jira/browse/HIVE-4144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13873231#comment-13873231 ] Hive QA commented on HIVE-4144: --- {color:green}Overall{color}: +1 all checks pass Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12623280/HIVE-4144.11.patch.txt {color:green}SUCCESS:{color} +1 4929 tests passed Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/929/testReport Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/929/console Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase {noformat} This message is automatically generated. ATTACHMENT ID: 12623280 > Add "select database()" command to show the current database > > > Key: HIVE-4144 > URL: https://issues.apache.org/jira/browse/HIVE-4144 > Project: Hive > Issue Type: Bug > Components: SQL >Reporter: Mark Grover >Assignee: Navis > Attachments: D9597.5.patch, HIVE-4144.10.patch.txt, > HIVE-4144.11.patch.txt, HIVE-4144.6.patch.txt, HIVE-4144.7.patch.txt, > HIVE-4144.8.patch.txt, HIVE-4144.9.patch.txt, HIVE-4144.D9597.1.patch, > HIVE-4144.D9597.2.patch, HIVE-4144.D9597.3.patch, HIVE-4144.D9597.4.patch > > > A recent hive-user mailing list conversation asked about having a command to > show the current database. > http://mail-archives.apache.org/mod_mbox/hive-user/201303.mbox/%3CCAMGr+0i+CRY69m3id=DxthmUCWLf0NxpKMCtROb=uauh2va...@mail.gmail.com%3E > MySQL seems to have a command to do so: > {code} > select database(); > {code} > http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_database > We should look into having something similar in Hive. -- This message was sent by Atlassian JIRA (v6.1.5#6160)
[jira] [Commented] (HIVE-4144) Add "select database()" command to show the current database
[ https://issues.apache.org/jira/browse/HIVE-4144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13872240#comment-13872240 ] Hive QA commented on HIVE-4144: --- {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/12623069/HIVE-4144.10.patch.txt {color:red}ERROR:{color} -1 due to 2 failed/errored test(s), 4927 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_bucket5 org.apache.hadoop.hive.ql.parse.TestParseNegative.testParseNegative_invalid_select {noformat} Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/922/testReport Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/922/console 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: 2 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12623069 > Add "select database()" command to show the current database > > > Key: HIVE-4144 > URL: https://issues.apache.org/jira/browse/HIVE-4144 > Project: Hive > Issue Type: Bug > Components: SQL >Reporter: Mark Grover >Assignee: Navis > Attachments: D9597.5.patch, HIVE-4144.10.patch.txt, > HIVE-4144.6.patch.txt, HIVE-4144.7.patch.txt, HIVE-4144.8.patch.txt, > HIVE-4144.9.patch.txt, HIVE-4144.D9597.1.patch, HIVE-4144.D9597.2.patch, > HIVE-4144.D9597.3.patch, HIVE-4144.D9597.4.patch > > > A recent hive-user mailing list conversation asked about having a command to > show the current database. > http://mail-archives.apache.org/mod_mbox/hive-user/201303.mbox/%3CCAMGr+0i+CRY69m3id=DxthmUCWLf0NxpKMCtROb=uauh2va...@mail.gmail.com%3E > MySQL seems to have a command to do so: > {code} > select database(); > {code} > http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_database > We should look into having something similar in Hive. -- This message was sent by Atlassian JIRA (v6.1.5#6160)
[jira] [Commented] (HIVE-4144) Add "select database()" command to show the current database
[ https://issues.apache.org/jira/browse/HIVE-4144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13819321#comment-13819321 ] Hive QA commented on HIVE-4144: --- {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/12613105/HIVE-4144.8.patch.txt {color:red}ERROR:{color} -1 due to 49 failed/errored test(s), 4604 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_ptf_negative_DistributeByOrderBy org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_ptf_negative_PartitionBySortBy org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_regex_col_2 org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_select_udtf_alias org.apache.hadoop.hive.ql.parse.TestParse.testParse_case_sensitivity org.apache.hadoop.hive.ql.parse.TestParse.testParse_cast1 org.apache.hadoop.hive.ql.parse.TestParse.testParse_groupby1 org.apache.hadoop.hive.ql.parse.TestParse.testParse_groupby2 org.apache.hadoop.hive.ql.parse.TestParse.testParse_groupby3 org.apache.hadoop.hive.ql.parse.TestParse.testParse_groupby4 org.apache.hadoop.hive.ql.parse.TestParse.testParse_groupby5 org.apache.hadoop.hive.ql.parse.TestParse.testParse_groupby6 org.apache.hadoop.hive.ql.parse.TestParse.testParse_input1 org.apache.hadoop.hive.ql.parse.TestParse.testParse_input2 org.apache.hadoop.hive.ql.parse.TestParse.testParse_input20 org.apache.hadoop.hive.ql.parse.TestParse.testParse_input3 org.apache.hadoop.hive.ql.parse.TestParse.testParse_input4 org.apache.hadoop.hive.ql.parse.TestParse.testParse_input5 org.apache.hadoop.hive.ql.parse.TestParse.testParse_input6 org.apache.hadoop.hive.ql.parse.TestParse.testParse_input7 org.apache.hadoop.hive.ql.parse.TestParse.testParse_input8 org.apache.hadoop.hive.ql.parse.TestParse.testParse_input9 org.apache.hadoop.hive.ql.parse.TestParse.testParse_input_part1 org.apache.hadoop.hive.ql.parse.TestParse.testParse_input_testsequencefile org.apache.hadoop.hive.ql.parse.TestParse.testParse_input_testxpath org.apache.hadoop.hive.ql.parse.TestParse.testParse_input_testxpath2 org.apache.hadoop.hive.ql.parse.TestParse.testParse_join1 org.apache.hadoop.hive.ql.parse.TestParse.testParse_join2 org.apache.hadoop.hive.ql.parse.TestParse.testParse_join3 org.apache.hadoop.hive.ql.parse.TestParse.testParse_join4 org.apache.hadoop.hive.ql.parse.TestParse.testParse_join5 org.apache.hadoop.hive.ql.parse.TestParse.testParse_join6 org.apache.hadoop.hive.ql.parse.TestParse.testParse_join7 org.apache.hadoop.hive.ql.parse.TestParse.testParse_join8 org.apache.hadoop.hive.ql.parse.TestParse.testParse_sample1 org.apache.hadoop.hive.ql.parse.TestParse.testParse_sample2 org.apache.hadoop.hive.ql.parse.TestParse.testParse_sample3 org.apache.hadoop.hive.ql.parse.TestParse.testParse_sample4 org.apache.hadoop.hive.ql.parse.TestParse.testParse_sample5 org.apache.hadoop.hive.ql.parse.TestParse.testParse_sample6 org.apache.hadoop.hive.ql.parse.TestParse.testParse_sample7 org.apache.hadoop.hive.ql.parse.TestParse.testParse_subq org.apache.hadoop.hive.ql.parse.TestParse.testParse_udf1 org.apache.hadoop.hive.ql.parse.TestParse.testParse_udf4 org.apache.hadoop.hive.ql.parse.TestParse.testParse_udf6 org.apache.hadoop.hive.ql.parse.TestParse.testParse_udf_case org.apache.hadoop.hive.ql.parse.TestParse.testParse_udf_when org.apache.hadoop.hive.ql.parse.TestParse.testParse_union org.apache.hadoop.hive.ql.parse.TestParseNegative.testParseNegative_invalid_select {noformat} Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/241/testReport Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/241/console Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests failed with: TestsFailedException: 49 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12613105 > Add "select database()" command to show the current database > > > Key: HIVE-4144 > URL: https://issues.apache.org/jira/browse/HIVE-4144 > Project: Hive > Issue Type: Bug > Components: SQL >Reporter: Mark Grover >Assignee: Navis > Attachments: D9597.5.patch, HIVE-4144.6.patch.txt, > HIVE-4144.7.patch.txt, HIVE-4144.8.patch.txt, HIVE-4144.D9597.1.patch, > HIVE-4144.D9597.2.patch, HIVE-4144.D9597.3.patch, HIVE-4144.D9597.4.patch > > > A recent hive-user mailing list conversation asked about having a command to > show the current database. > http://mail-archives.apache.org/mod_mbox/hive-user/201303.mbox/%3CCAMGr+0i+CRY69m3id=DxthmUCWLf0NxpKMCtROb=uauh2va...@mail.g
[jira] [Commented] (HIVE-4144) Add "select database()" command to show the current database
[ https://issues.apache.org/jira/browse/HIVE-4144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13800530#comment-13800530 ] Hive QA commented on HIVE-4144: --- {color:red}Overall{color}: -1 no tests executed Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12609375/D9597.5.patch Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/1180/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/1180/console Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Tests failed with: NonZeroExitCodeException: Command 'bash /data/hive-ptest/working/scratch/source-prep.sh' failed with exit status 1 and output '+ [[ -n '' ]] + export 'ANT_OPTS=-Xmx1g -XX:MaxPermSize=256m -Dhttp.proxyHost=localhost -Dhttp.proxyPort=3128' + ANT_OPTS='-Xmx1g -XX:MaxPermSize=256m -Dhttp.proxyHost=localhost -Dhttp.proxyPort=3128' + export 'M2_OPTS=-Xmx1g -XX:MaxPermSize=256m ' + M2_OPTS='-Xmx1g -XX:MaxPermSize=256m ' + cd /data/hive-ptest/working/ + tee /data/hive-ptest/logs/PreCommit-HIVE-Build-1180/source-prep.txt + [[ true == \t\r\u\e ]] + rm -rf ivy maven + mkdir -p maven ivy + [[ svn = \s\v\n ]] + [[ -n '' ]] + [[ -d apache-svn-trunk-source ]] + [[ ! -d apache-svn-trunk-source/.svn ]] + [[ ! -d apache-svn-trunk-source ]] + cd apache-svn-trunk-source + svn revert -R . Reverted 'common/src/java/org/apache/hadoop/hive/conf/HiveConf.java' Reverted 'common/src/java/org/apache/hadoop/hive/common/ObjectPair.java' Reverted 'ql/src/test/results/clientpositive/auto_sortmerge_join_9.q.out' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/PhysicalOptimizer.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/plan/ExplainWork.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/parse/ExplainSemanticAnalyzer.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/exec/Task.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/exec/ExplainTask.java' ++ awk '{print $2}' ++ egrep -v '^X|^Performing status on external' ++ svn status --no-ignore + rm -rf build hcatalog/build hcatalog/core/build hcatalog/storage-handlers/hbase/build hcatalog/server-extensions/build hcatalog/webhcat/svr/build hcatalog/webhcat/java-client/build hcatalog/hcatalog-pig-adapter/build common/src/gen ql/src/test/results/clientpositive/explain_rearrange.q.out ql/src/test/queries/clientpositive/explain_rearrange.q ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/StageIDsRearranger.java + svn update Fetching external item into 'hcatalog/src/test/e2e/harness' External at revision 1534082. At revision 1534082. + patchCommandPath=/data/hive-ptest/working/scratch/smart-apply-patch.sh + patchFilePath=/data/hive-ptest/working/scratch/build.patch + [[ -f /data/hive-ptest/working/scratch/build.patch ]] + chmod +x /data/hive-ptest/working/scratch/smart-apply-patch.sh + /data/hive-ptest/working/scratch/smart-apply-patch.sh /data/hive-ptest/working/scratch/build.patch The patch does not appear to apply with p0 to p2 + exit 1 ' {noformat} This message is automatically generated. > Add "select database()" command to show the current database > > > Key: HIVE-4144 > URL: https://issues.apache.org/jira/browse/HIVE-4144 > Project: Hive > Issue Type: Bug > Components: SQL >Reporter: Mark Grover >Assignee: Navis > Attachments: D9597.5.patch, HIVE-4144.D9597.1.patch, > HIVE-4144.D9597.2.patch, HIVE-4144.D9597.3.patch, HIVE-4144.D9597.4.patch > > > A recent hive-user mailing list conversation asked about having a command to > show the current database. > http://mail-archives.apache.org/mod_mbox/hive-user/201303.mbox/%3CCAMGr+0i+CRY69m3id=DxthmUCWLf0NxpKMCtROb=uauh2va...@mail.gmail.com%3E > MySQL seems to have a command to do so: > {code} > select database(); > {code} > http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_database > We should look into having something similar in Hive. -- This message was sent by Atlassian JIRA (v6.1#6144)
[jira] [Commented] (HIVE-4144) Add "select database()" command to show the current database
[ https://issues.apache.org/jira/browse/HIVE-4144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13700401#comment-13700401 ] Navis commented on HIVE-4144: - Yes, I've made generic dummy n-row input format and OneNullRowIF (for metadata-only query) to extend that. Quite a fun patch. > Add "select database()" command to show the current database > > > Key: HIVE-4144 > URL: https://issues.apache.org/jira/browse/HIVE-4144 > Project: Hive > Issue Type: Bug > Components: SQL >Reporter: Mark Grover >Assignee: Navis > Attachments: HIVE-4144.D9597.1.patch, HIVE-4144.D9597.2.patch > > > A recent hive-user mailing list conversation asked about having a command to > show the current database. > http://mail-archives.apache.org/mod_mbox/hive-user/201303.mbox/%3CCAMGr+0i+CRY69m3id=DxthmUCWLf0NxpKMCtROb=uauh2va...@mail.gmail.com%3E > MySQL seems to have a command to do so: > {code} > select database(); > {code} > http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_database > We should look into having something similar in Hive. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-4144) Add "select database()" command to show the current database
[ https://issues.apache.org/jira/browse/HIVE-4144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13700265#comment-13700265 ] Edward Capriolo commented on HIVE-4144: --- Navis. This is cool. I will review this soon. I did notice that there is already a Dummy input format like yours that was added to hive a while back. I think it was added to support queries only on meta-data. In any case we probably do not need two dummy Input formats in the project. > Add "select database()" command to show the current database > > > Key: HIVE-4144 > URL: https://issues.apache.org/jira/browse/HIVE-4144 > Project: Hive > Issue Type: Bug > Components: SQL >Reporter: Mark Grover >Assignee: Navis > Attachments: HIVE-4144.D9597.1.patch, HIVE-4144.D9597.2.patch > > > A recent hive-user mailing list conversation asked about having a command to > show the current database. > http://mail-archives.apache.org/mod_mbox/hive-user/201303.mbox/%3CCAMGr+0i+CRY69m3id=DxthmUCWLf0NxpKMCtROb=uauh2va...@mail.gmail.com%3E > MySQL seems to have a command to do so: > {code} > select database(); > {code} > http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_database > We should look into having something similar in Hive. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira