[
https://issues.apache.org/jira/browse/TRAFODION-3101?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16522684#comment-16522684
]
ASF GitHub Bot commented on TRAFODION-3101:
-------------------------------------------
Github user anoopsharma00 commented on a diff in the pull request:
https://github.com/apache/trafodion/pull/1619#discussion_r197905685
--- Diff: core/sql/regress/compGeneral/EXPECTED023 ---
@@ -23,6 +23,10 @@ SB_HISTOGRAMS
SB_HISTOGRAM_INTERVALS
SB_PERSISTENT_SAMPLES
+=======================
--- End diff --
This is not that much of science fiction.
get commands can be used as derived tables within selects.
For ex: one can do the following to get this result:
>>create table if not exists "finance" (a int);
--- SQL operation complete.
>>select left(b, 10) from
+>((select * from (get tables in schema sch) x(a))
+> union all
+> (select * from (get users) x(a))) z(b)
+>where b like 'finance%';
(EXPR)
----------------------------------------
finance
--- 1 row(s) selected.
>>
> enhance the 'get table' utility to return number of rows
> --------------------------------------------------------
>
> Key: TRAFODION-3101
> URL: https://issues.apache.org/jira/browse/TRAFODION-3101
> Project: Apache Trafodion
> Issue Type: Improvement
> Reporter: liu ming
> Assignee: liu ming
> Priority: Major
>
> when run 'get tables' command, it is desired to show the number of rows
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
