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 <https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10 > > > > <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> > Virus-free. www.avg.com > <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>
