Daniel Barclay (Drill) created DRILL-2863:
---------------------------------------------
Summary: Slow code generation/compilation(/scalar replacement?)
for getColumns(...) query
Key: DRILL-2863
URL: https://issues.apache.org/jira/browse/DRILL-2863
Project: Apache Drill
Issue Type: Bug
Reporter: Daniel Barclay (Drill)
Calling Drill's JDBC driver's DatabaseMetaData.getColumns(...) method seems to
take an unusually long of time to execute.
Unit tests TestJdbcMetadata and
Drill2128GetColumnsDataTypeNotTypeCodeIntBugsTest have gotten slower recently,
seemingly in several increments: They needed their timeouts increased, from
around 50 s to 90 s, and then to 120 s, and that 120 s timeout is not long
enough for reliable runs (at least on my machine).
>From looking at the logs (with sufficiently verbose logging), it seems that
>the large SQL query in the implementation of getColumns() (currently in
>org.apache.drill.jdbc.MetaImpl) is leads to 513 kB of generated code.
That half a megabyte of generated Java code frequently takes around 110 seconds
to compile (on my machine).
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
