Hi Manjeet, PFB link it will you.
https://www.mapr.com/blog/how-convert-csv-file-apache-parquet-using-apache-drill Best Regards, ANKIT BEOHAR On Mon, Dec 26, 2016 at 2:29 PM, Khurram Faraaz <[email protected]> wrote: > 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 > > >
