You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Hive QA (JIRA)" <ji...@apache.org> on 2019/02/21 09:02:00 UTC
[jira] [Commented] (HIVE-21301) Show tables statement to include
views and materialized views
[ https://issues.apache.org/jira/browse/HIVE-21301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16773844#comment-16773844 ]
Hive QA commented on HIVE-21301:
--------------------------------
| (x) *{color:red}-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:green}+1{color} | {color:green} mvninstall {color} | {color:green} 8m 6s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 2s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 44s{color} | {color:green} master passed {color} |
| {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 3m 50s{color} | {color:blue} ql in master has 2260 extant Findbugs warnings. {color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 56s{color} | {color:green} master passed {color} |
|| || || || {color:brown} Patch Compile Tests {color} ||
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 25s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 3s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 3s{color} | {color:green} the patch passed {color} |
| {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 45s{color} | {color:red} ql: The patch generated 3 new + 660 unchanged - 1 fixed = 663 total (was 661) {color} |
| {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} |
| {color:red}-1{color} | {color:red} findbugs {color} | {color:red} 3m 56s{color} | {color:red} ql generated 10 new + 2250 unchanged - 10 fixed = 2260 total (was 2260) {color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 56s{color} | {color:green} the patch passed {color} |
|| || || || {color:brown} Other Tests {color} ||
| {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 13s{color} | {color:green} The patch does not generate ASF License warnings. {color} |
| {color:black}{color} | {color:black} {color} | {color:black} 23m 29s{color} | {color:black} {color} |
\\
\\
|| Reason || Tests ||
| FindBugs | module:ql |
| | Should org.apache.hadoop.hive.ql.parse.HiveParser$DFA234 be a _static_ inner class? At HiveParser.java:inner class? At HiveParser.java:[lines 47554-47567] |
| | Dead store to LA29_128 in org.apache.hadoop.hive.ql.parse.HiveParser$DFA29.specialStateTransition(int, IntStream) At HiveParser.java:org.apache.hadoop.hive.ql.parse.HiveParser$DFA29.specialStateTransition(int, IntStream) At HiveParser.java:[line 47293] |
| | Dead store to LA29_130 in org.apache.hadoop.hive.ql.parse.HiveParser$DFA29.specialStateTransition(int, IntStream) At HiveParser.java:org.apache.hadoop.hive.ql.parse.HiveParser$DFA29.specialStateTransition(int, IntStream) At HiveParser.java:[line 47306] |
| | Dead store to LA29_132 in org.apache.hadoop.hive.ql.parse.HiveParser$DFA29.specialStateTransition(int, IntStream) At HiveParser.java:org.apache.hadoop.hive.ql.parse.HiveParser$DFA29.specialStateTransition(int, IntStream) At HiveParser.java:[line 47319] |
| | Dead store to LA29_134 in org.apache.hadoop.hive.ql.parse.HiveParser$DFA29.specialStateTransition(int, IntStream) At HiveParser.java:org.apache.hadoop.hive.ql.parse.HiveParser$DFA29.specialStateTransition(int, IntStream) At HiveParser.java:[line 47332] |
| | Dead store to LA29_136 in org.apache.hadoop.hive.ql.parse.HiveParser$DFA29.specialStateTransition(int, IntStream) At HiveParser.java:org.apache.hadoop.hive.ql.parse.HiveParser$DFA29.specialStateTransition(int, IntStream) At HiveParser.java:[line 47345] |
| | Dead store to LA29_138 in org.apache.hadoop.hive.ql.parse.HiveParser$DFA29.specialStateTransition(int, IntStream) At HiveParser.java:org.apache.hadoop.hive.ql.parse.HiveParser$DFA29.specialStateTransition(int, IntStream) At HiveParser.java:[line 47358] |
| | Dead store to LA29_140 in org.apache.hadoop.hive.ql.parse.HiveParser$DFA29.specialStateTransition(int, IntStream) At HiveParser.java:org.apache.hadoop.hive.ql.parse.HiveParser$DFA29.specialStateTransition(int, IntStream) At HiveParser.java:[line 47371] |
| | Dead store to LA29_142 in org.apache.hadoop.hive.ql.parse.HiveParser$DFA29.specialStateTransition(int, IntStream) At HiveParser.java:org.apache.hadoop.hive.ql.parse.HiveParser$DFA29.specialStateTransition(int, IntStream) At HiveParser.java:[line 47384] |
| | Should org.apache.hadoop.hive.ql.parse.HiveParser$DFA292 be a _static_ inner class? At HiveParser.java:inner class? At HiveParser.java:[lines 47690-47703] |
\\
\\
|| Subsystem || Report/Notes ||
| Optional Tests | asflicense javac javadoc findbugs checkstyle compile |
| 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-16176/dev-support/hive-personality.sh |
| git revision | master / 89b9f12 |
| Default Java | 1.8.0_111 |
| findbugs | v3.0.0 |
| checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-16176/yetus/diff-checkstyle-ql.txt |
| findbugs | http://104.198.109.242/logs//PreCommit-HIVE-Build-16176/yetus/new-findbugs-ql.html |
| modules | C: ql U: ql |
| Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-16176/yetus.txt |
| Powered by | Apache Yetus http://yetus.apache.org |
This message was automatically generated.
> Show tables statement to include views and materialized views
> -------------------------------------------------------------
>
> Key: HIVE-21301
> URL: https://issues.apache.org/jira/browse/HIVE-21301
> Project: Hive
> Issue Type: Bug
> Affects Versions: 4.0.0, 3.2.0
> Reporter: Jesus Camacho Rodriguez
> Assignee: Jesus Camacho Rodriguez
> Priority: Major
> Attachments: HIVE-21301.patch
>
>
> HIVE-19974 introduced backwards incompatible change, with {{SHOW TABLES}} statement showing only managed/external tables in the system.
> This issue will restore old behavior, with {{SHOW TABLES}} showing all queryable entities, including views and materialized views.
> Instead, to provide information about table types, {{SHOW EXTENDED TABLES}} statement is introduced, which includes an additional column with the table type for each of the tables listed.
> Besides, the possibility to filter the show tables statements with a {{WHERE `table_type` = 'ANY_TYPE'}} clause is introduced.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)