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 >
