Route 1: run ANALYZE TABLE ... REFRESH METADATA on the tables to have
them added to the tables collection in INFORMATION_SCHEMA.
Route 2: Use CREATE VIEW to create a view for every data set to be
exposed to MicroStrategy. Views are added to INFORMATION_SCHEMA.
On 2020/12/19 03:37, Indian A wrote:
Hello Charles
Ok. We are trying to use Microstrategy reporting via Apache Drill . Because
these are saved in files these do not show in microstrategy for us to access.
This is what we write inside Microstrategy to access tables in general
Select tables from information_schema.tables where table_schema in (‘dfs
.tmp’,’dfs’ ,’sys’)
Is these any way that I can show the files in dfs.tmp , because the above sql
is not able to pull the files that i create using the below create sql.
Create table dfs.tmp.tablename- I am writing this to create a table in dfs.tmp
Kindly advise
Best regards
Sandeep Amancharla
Sent from my iPhone
On Dec 18, 2020, at 6:07 PM, Charles Givre <[email protected]> wrote:
HI Sandeep,
Thanks for your interest in Drill. What you're describing is actually how
Drill is supposed to work. When you do a CREATE TABLE (CTAS) query, it is
actually creating a file, usually parquet, in the location you specified.
Therefore it doesn't show up when you do a SHOW TABLES query.
Best,
--C
On Dec 18, 2020, at 3:14 AM, Indian <[email protected]> wrote:
Hello All
I am creating a table using the following SQL. But the tables are created in file format . The tables show up when I type ‘show files in dfs.tmp’ But DO NOT SHOW up in table schema. Kindly advise.
Best Regards
Sandeep
Sent from Mail for Windows 10
Virus-free. www.avg.com
