Hi,
I have data in parquet file format .
when I run the query the data and see the execution plan I could see
following
statistics

> TOTAL FRAGMENTS: 1
>> DURATION: 01 min 0.233 sec
>> PLANNING: 59.818 sec
>> QUEUED: Not Available
>> EXECUTION: 0.415 sec
>
>

As its a paquet file format I tried enabling refresh meta data
and run below command
REFRESH TABLE METADATA <path to table> ;
then run the same query again on the same table same data (no changes in
data)  and could find the statistics as show below :

TOTAL FRAGMENTS: 13
>> DURATION: 14 min 14.604 sec
>> PLANNING: 33.087 sec
>> QUEUED: Not Available
>> EXECUTION: Not Available
>
>
The query is still running .

Can somebody help me  understand why the query taking so long once I issue
the refresh metadata command.

Aprreciate the help !

Thanks,
Divya

Reply via email to