Hello Manjeet, What error do you see on the prompt from where you submit the CTAS statement ? Can you please share the stacktrace/error information from the drillbit.log file ? is your CTAS (the one that failed), is it over CSV/JSON files ?
And when you say your SELECT statement is not working, what do you see on the prompt, an error/Exception, no results ? Can you also share the schema details for your parquet file (* 02a566d.snappy.parquet) in your SELECT statement ? What version of Drill are you using ? On Mon, Dec 26, 2016 at 12:16 PM, Manjeet Singh <[email protected]> wrote: > Hi all > > I have checked that even my simplest query is not working > > SELECT AAA FROM > dfs.'/user/olap/EntityProfiling/DomainParquet/ > Domain-1-_1481273732716/part-r-00000-7c4b50c5-0318-4243- > 9f76-9822c02a566d.snappy.parquet'; > > > Thanks > Manjeet > > On Mon, Dec 26, 2016 at 11:26 AM, Manjeet Singh < > [email protected]> > wrote: > > > Hi All, > > > > I have query, I want to create table/ view on drill I have data stored in > > parquet files on hdfs > > > > > > i am using below command but not able to create table > > > > > > CREATE TABLE 'ttttt'( > > "AAA", "Domain", "certValidity", "protocol", "LastActive", "GetCount", > > "PostCount", "Data_Transfer", "Data_Receive", "Total_Communication", > > "Last_Active") AS SELECT "AAA", "Domain", "certValidity", "protocol", > > "LastActive", "GetCount", "PostCount", "Data_Transfer", "Data_Receive", > > "Total_Communication", "Last_Active" FROM dfs."/user/Domain-1-_ > > 1481273732716/*"; > > > > below is the schema > > > > -- AAA: string (nullable = true) > > |-- BTSID: string (nullable = true) > > |-- OIME: string (nullable = true) > > |-- OIMS: string (nullable = true) > > |-- application: string (nullable = true) > > |-- applicationCount: string (nullable = true) > > |-- dataRx: string (nullable = true) > > |-- dataTx: string (nullable = true) > > |-- day: string (nullable = true) > > |-- duration: string (nullable = true) > > |-- locationLatLong: string (nullable = true) > > |-- month: string (nullable = true) > > |-- protocol: string (nullable = true) > > |-- protocolCount: string (nullable = true) > > |-- serverIP: string (nullable = true) > > |-- startTime: string (nullable = true) > > |-- totalVolume: string (nullable = true) > > |-- year: string (nullable = true) > > > > can anyone help me out? > > > > Thanks > > Manjeet > > > > -- > > luv all > > > > > > -- > luv all >
