Just for info :
After recreating tables with explicit columns CASTing have double
performace of this query (from 60 to 35 sec.)
Best regards,
Dmitry
> Hello
>
> I have load (as CTAS) into parquet-files StarShema Benchmark generated
> csv-data (scale factor 50)
>
> For one of bencmark query's
One quick note here, I don't think partitioning LINEORDER table on
LO_ORDERDATE would help this query. If you look at the query profile you
will see that Drill is reading everything from LINEORDER.
On Fri, Mar 18, 2016 at 7:57 AM, Dmitry Krivov wrote:
> Just for info :
>
>
Hello Dmitry,
Welcome to Drill's community :)
What version of Drill are you using ?
Also, can you share the query profile of your query, it helps to show what
taking most of the time.
Thanks
On Mon, Feb 22, 2016 at 10:54 AM, Dmitry Krivov
wrote:
> Hello
>
> I have load