The SHOW TABLES command returns a list of views created within a schema. Italso returns the tables that exist in Hive and HBase when you use storage plugin configurations for these data sources. See Storage PluginRegistration.
![Installer Installer](https://img.informer.com/pd/QSD-v13.3-main-screen-2.png)
It gives you accurate vulnerability management with scanning, detection, assessment, prioritization, and remediation capabilities. SanerNow is available on both cloud and on-premise, whose integrated patch management automates patching across all major OSs like Windows, MAC, Linux, and a vast collection of 3rd party software patches. RDQA is a R package for Qualitative Data Analysis, a free qualitative analysis software application (BSD license). It works on Windows, Linux/FreeBSD and Mac OSX platforms. RQDA is an easy to use tool to assist in the analysis of textual data. At the moment it only supports plain text formatted data. Compare the best Network Monitoring software of 2021 for your business. Find the highest rated Network Monitoring software pricing, reviews, free demos, trials, and more. Compare the best Network Monitoring software of 2021 for your business. Find the highest rated Network Monitoring software pricing, reviews, free demos, trials, and more.
Syntax
The SHOW TABLES command supports the following syntax:
Usage Notes
First issue the USE command to identify the schema for which you want to viewtables or views. For example, the following USE statement tells Drill that youonly want information from the
dfs.myviews
schema:In this example, “
myviews
” is a workspace created within thedfs
storage plugin configuration.When you use a particular schema and then issue the SHOW TABLES command, Drillreturns the tables and views within that schema.
Limitations
- You can create and query tables within the file system, however Drill does not return these tables when you issue the SHOW TABLES command. You can issue the SHOW FILES command to see a list of all files, tables, and views, including those created in Drill.
- You cannot create Hive or HBase tables in Drill.
Examples
The following examples demonstrate the steps that you can follow when you wantto issue the SHOW TABLES command on the file system, Hive, and HBase.
![Download Download](https://data-flair.training/blogs/wp-content/uploads/sites/2/2018/10/inst7.png)
Complete the following steps to see views that exist in a file system andtables that exist in Hive and HBase data sources:
Qlik Sense Desktop Download Mac Installer
- Issue the SHOW SCHEMAS command to see a list of available schemas.0: jdbc:drill:zk=drilldemo:5181> show schemas; |——————–| | SCHEMA_NAME | |——————–| | hive.default | | dfs.reviews | | dfs.flatten | | dfs.default | | dfs.root | | dfs.logs | | dfs.myviews | | dfs.clicks | | dfs.tmp | | sys | | hbase | | INFORMATION_SCHEMA | | s3.twitter | | s3.reviews | | s3.default | |——————–| 15 rows selected (0.072 seconds)
- Issue the USE command to switch to a particular schema. When you use a particular schema, Drill searches or queries within that schema only.0: jdbc:drill:zk=drilldemo:5181> use dfs.myviews; |——|—————————————–| | ok | summary | |——|—————————————–| | true | Default schema changed to ‘dfs.myviews’ | |——|—————————————–| 1 row selected (0.025 seconds)
- Issue the SHOW TABLES command to see the views or tables that exist within workspace.0: jdbc:drill:zk=drilldemo:5181> show tables; |————–|—————–| | TABLE_SCHEMA | TABLE_NAME | |————–|—————–| | dfs.myviews | logs_vw | | dfs.myviews | customers_vw | | dfs.myviews | s3_review_vw | | dfs.myviews | clicks_vw | | dfs.myviews | nestedclickview | | dfs.myviews | s3_user_vw | | dfs.myviews | s3_bus_vw | |————–|—————–| 7 rows selected (0.499 seconds) 0: jdbc:drill:zk=drilldemo:5181>
- Switch to the Hive schema and issue the SHOW TABLES command to see the Hive tables that exist.0: jdbc:drill:zk=drilldemo:5181> use hive; |——|———————————-| | ok | summary | |——|———————————-| | true | Default schema changed to ‘hive’ | |——|———————————-| 1 row selected (0.043 seconds)0: jdbc:drill:zk=drilldemo:5181> show tables; |————–|————| | TABLE_SCHEMA | TABLE_NAME | |————–|————| | hive.default | orders | | hive.default | products | |————–|————| 2 rows selected (0.552 seconds)
- Switch to the HBase schema and issue the SHOW TABLES command to see the HBase tables that exist within the schema.0: jdbc:drill:zk=drilldemo:5181> use hbase; |——|———————————–| | ok | summary | |——|———————————–| | true | Default schema changed to ‘hbase’ | |——|———————————–| 1 row selected (0.043 seconds)0: jdbc:drill:zk=drilldemo:5181> show tables; |————–|————| | TABLE_SCHEMA | TABLE_NAME | |————–|————| | hbase | customers | |————–|————| 1 row selected (0.412 seconds)
Qlik Sense Desktop Download Mac Version
← SHOW FILESUSE →