Re: Drill with Parquet

[Manjeet Singh]

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 <manjeet.chand...@gmail.com>
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