Drill with Parquet

[Manjeet Singh]

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