column with default value not working for parquet files

[Prabhakar Bhosale <bh...@gmail.com>]

Hi Team,
I am trying to add a column with default into a parquet file by way of
defining a schema for the folder after enabling the metostore. I used the
following query to provide a schema. but the new column always returns null
value instead of giving default value. I am using drill 1.21.1

ANALYZE TABLE   table(dfs.tmp.`TESTCUST_1`
(type=>'parquet',schema=>'inline=(`TRANID`
VARCHAR,
    `CUST_ID` VARCHAR,
    `ACTID` VARCHAR,
    `TRANAMT` FLOAT NOT NULL properties {`DEFAULT` = `1.77`})')) REFRESH
METADATA;

REgards
Prabhakar

Re: column with default value not working for parquet files

[James Turton <ja...@somecomputer.xyz.INVALID>]

I don't think this feature is actually supported for Parquet files. How 
about defining a SQL view that includes a COALESCE(TRANAMT, 1.77) column 
expression?

On 2023/09/06 09:23, Prabhakar Bhosale wrote:
> Hi Team,
> I am trying to add a column with default into a parquet file by way of
> defining a schema for the folder after enabling the metostore. I used the
> following query to provide a schema. but the new column always returns null
> value instead of giving default value. I am using drill 1.21.1
>
> ANALYZE TABLE   table(dfs.tmp.`TESTCUST_1`
> (type=>'parquet',schema=>'inline=(`TRANID`
> VARCHAR,
>      `CUST_ID` VARCHAR,
>      `ACTID` VARCHAR,
>      `TRANAMT` FLOAT NOT NULL properties {`DEFAULT` = `1.77`})')) REFRESH
> METADATA;
>
> REgards
> Prabhakar
>