[
https://issues.apache.org/jira/browse/DRILL-3056?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14729911#comment-14729911
]
Victoria Markman commented on DRILL-3056:
-----------------------------------------
Verified by auditing drillbit.log for this query:
{code}
2015-09-03 22:20:49,029 [2a17383e-9495-f55c-e89a-d7e1b37fe167:foreman] WARN
o.a.d.e.p.logical.DrillValuesRel - Converting exact decimal into approximate
decimal. Should be fixed once decimal is implemented.
2015-09-03 22:20:49,029 [2a17383e-9495-f55c-e89a-d7e1b37fe167:foreman] WARN
o.a.d.e.p.logical.DrillValuesRel - Converting exact decimal into approximate
decimal. Should be fixed once decimal is implemented.
2015-09-03 22:20:49,029 [2a17383e-9495-f55c-e89a-d7e1b37fe167:foreman] WARN
o.a.d.e.p.logical.DrillValuesRel - Converting exact decimal into approximate
decimal. Should be fixed once decimal is implemented.
2015-09-03 22:20:49,029 [2a17383e-9495-f55c-e89a-d7e1b37fe167:foreman] WARN
o.a.d.e.p.logical.DrillValuesRel - Converting exact decimal into approximate
decimal. Should be fixed once decimal is implemented.
2015-09-03 22:20:49,029 [2a17383e-9495-f55c-e89a-d7e1b37fe167:foreman] WARN
o.a.d.e.p.logical.DrillValuesRel - Converting exact decimal into approximate
decimal. Should be fixed once decimal is implemented.
2015-09-03 22:20:49,029 [2a17383e-9495-f55c-e89a-d7e1b37fe167:foreman] WARN
o.a.d.e.p.logical.DrillValuesRel - Converting exact decimal into approximate
decimal. Should be fixed once decimal is implemented.
2015-09-03 22:20:49,029 [2a17383e-9495-f55c-e89a-d7e1b37fe167:foreman] WARN
o.a.d.e.p.logical.DrillValuesRel - Converting exact decimal into approximate
decimal. Should be fixed once decimal is implemented.
2015-09-03 22:20:49,029 [2a17383e-9495-f55c-e89a-d7e1b37fe167:foreman] WARN
o.a.d.e.p.logical.DrillValuesRel - Converting exact decimal into approximate
decimal. Should be fixed once decimal is implemented.
2015-09-03 22:20:49,029 [2a17383e-9495-f55c-e89a-d7e1b37fe167:foreman] WARN
o.a.d.e.p.logical.DrillValuesRel - Converting exact decimal into approximate
decimal. Should be fixed once decimal is implemented.
2015-09-03 22:20:49,029 [2a17383e-9495-f55c-e89a-d7e1b37fe167:foreman] WARN
o.a.d.e.p.logical.DrillValuesRel - Converting exact decimal into approximate
decimal. Should be fixed once decimal is implemented.
2015-09-03 22:20:49,029 [2a17383e-9495-f55c-e89a-d7e1b37fe167:foreman] WARN
o.a.d.e.p.logical.DrillValuesRel - Converting exact decimal into approximate
decimal. Should be fixed once decimal is implemented.
2015-09-03 22:20:49,029 [2a17383e-9495-f55c-e89a-d7e1b37fe167:foreman] WARN
o.a.d.e.p.logical.DrillValuesRel - Converting exact decimal into approximate
decimal. Should be fixed once decimal is implemented.
2015-09-03 22:20:49,029 [2a17383e-9495-f55c-e89a-d7e1b37fe167:foreman] WARN
o.a.d.e.p.logical.DrillValuesRel - Converting exact decimal into approximate
decimal. Should be fixed once decimal is implemented.
2015-09-03 22:20:49,029 [2a17383e-9495-f55c-e89a-d7e1b37fe167:foreman] WARN
o.a.d.e.p.logical.DrillValuesRel - Converting exact decimal into approximate
decimal. Should be fixed once decimal is implemented.
2015-09-03 22:20:49,029 [2a17383e-9495-f55c-e89a-d7e1b37fe167:foreman] WARN
o.a.d.e.p.logical.DrillValuesRel - Converting exact decimal into approximate
decimal. Should be fixed once decimal is implemented.
2015-09-03 22:20:49,030 [2a17383e-9495-f55c-e89a-d7e1b37fe167:foreman] WARN
o.a.d.e.p.logical.DrillValuesRel - Converting exact decimal into approximate
decimal. Should be fixed once decimal is implemented.
2015-09-03 22:20:49,030 [2a17383e-9495-f55c-e89a-d7e1b37fe167:foreman] WARN
o.a.d.e.p.logical.DrillValuesRel - Converting exact decimal into approximate
decimal. Should be fixed once decimal is implemented.
2015-09-03 22:20:49,030 [2a17383e-9495-f55c-e89a-d7e1b37fe167:foreman] WARN
o.a.d.e.p.logical.DrillValuesRel - Converting exact decimal into approximate
decimal. Should be fixed once decimal is implemented.
2015-09-03 22:20:49,030 [2a17383e-9495-f55c-e89a-d7e1b37fe167:foreman] WARN
o.a.d.e.p.logical.DrillValuesRel - Converting exact decimal into approximate
decimal. Should be fixed once decimal is implemented.
2015-09-03 22:20:49,030 [2a17383e-9495-f55c-e89a-d7e1b37fe167:foreman] WARN
o.a.d.e.p.logical.DrillValuesRel - Converting exact decimal into approximate
decimal. Should be fixed once decimal is implemented.
2015-09-03 22:20:49,030 [2a17383e-9495-f55c-e89a-d7e1b37fe167:foreman] WARN
o.a.d.e.p.logical.DrillValuesRel - Converting exact decimal into approximate
decimal. Should be fixed once decimal is implemented.
2015-09-03 22:20:49,030 [2a17383e-9495-f55c-e89a-d7e1b37fe167:foreman] WARN
o.a.d.e.p.logical.DrillValuesRel - Converting exact decimal into approximate
decimal. Should be fixed once decimal is implemented.
2015-09-03 22:20:49,030 [2a17383e-9495-f55c-e89a-d7e1b37fe167:foreman] WARN
o.a.d.e.p.logical.DrillValuesRel - Converting exact decimal into approximate
decimal. Should be fixed once decimal is implemented.
2015-09-03 22:20:49,030 [2a17383e-9495-f55c-e89a-d7e1b37fe167:foreman] WARN
o.a.d.e.p.logical.DrillValuesRel - Converting exact decimal into approximate
decimal. Should be fixed once decimal is implemented.
2015-09-03 22:20:49,030 [2a17383e-9495-f55c-e89a-d7e1b37fe167:foreman] WARN
o.a.d.e.p.logical.DrillValuesRel - Converting exact decimal into approximate
decimal. Should be fixed once decimal is implemented.
2015-09-03 22:20:49,030 [2a17383e-9495-f55c-e89a-d7e1b37fe167:foreman] WARN
o.a.d.e.p.logical.DrillValuesRel - Converting exact decimal into approximate
decimal. Should be fixed once decimal is implemented.
2015-09-03 22:20:49,034 [2a17383e-9495-f55c-e89a-d7e1b37fe167:foreman] INFO
o.a.d.e.store.parquet.FooterGatherer - Fetch Parquet Footers: Executed 1 out of
1 using 1 threads. Time: 0ms total, 0.919198ms avg, 0ms max.
2015-09-03 22:20:49,034 [2a17383e-9495-f55c-e89a-d7e1b37fe167:foreman] INFO
o.a.d.e.store.parquet.FooterGatherer - Fetch Parquet Footers: Executed 1 out of
1 using 1 threads. Earliest start: 0.583000 μs, Latest start: 0.583000 μs,
Average start: 0.583000 μs .
2015-09-03 22:20:49,087 [2a17383e-9495-f55c-e89a-d7e1b37fe167:foreman] INFO
o.a.drill.exec.work.foreman.Foreman - State change requested. PENDING -->
RUNNING
2015-09-03 22:20:49,089 [2a17383e-9495-f55c-e89a-d7e1b37fe167:frag:0:0] INFO
o.a.d.e.w.fragment.FragmentExecutor - 2a17383e-9495-f55c-e89a-d7e1b37fe167:0:0:
State change requested AWAITING_ALLOCATION --> RUNNING
2015-09-03 22:20:49,089 [2a17383e-9495-f55c-e89a-d7e1b37fe167:frag:0:0] INFO
o.a.d.e.w.f.FragmentStatusReporter - 2a17383e-9495-f55c-e89a-d7e1b37fe167:0:0:
State to report: RUNNING
2015-09-03 22:20:49,132 [2a17383e-9495-f55c-e89a-d7e1b37fe167:frag:0:0] INFO
o.a.d.e.w.fragment.FragmentExecutor - 2a17383e-9495-f55c-e89a-d7e1b37fe167:0:0:
State change requested RUNNING --> FINISHED
2015-09-03 22:20:49,132 [2a17383e-9495-f55c-e89a-d7e1b37fe167:frag:0:0] INFO
o.a.d.e.w.f.FragmentStatusReporter - 2a17383e-9495-f55c-e89a-d7e1b37fe167:0:0:
State to report: FINISHED
2015-09-03 22:20:49,133 [BitServer-4] INFO o.a.drill.exec.work.foreman.Foreman
- State change requested. RUNNING --> COMPLETED
2015-09-03 22:20:49,138 [BitServer-4] INFO o.a.drill.exec.work.foreman.Foreman
- foreman cleaning up.
{code}
I feel that we need to put a note in our documentation about this somewhere.
Because it might be confusing for users debugging issues.
> Numeric literal in an IN list is casted to decimal even when decimal type is
> disabled
> -------------------------------------------------------------------------------------
>
> Key: DRILL-3056
> URL: https://issues.apache.org/jira/browse/DRILL-3056
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Affects Versions: 1.0.0
> Reporter: Victoria Markman
> Assignee: Mehant Baid
> Labels: document
> Fix For: 1.2.0
>
>
> {code}
> 0: jdbc:drill:schema=dfs> select * from sys.options where name like
> '%decimal%';
> +------------+------------+------------+------------+------------+------------+------------+------------+
> | name | kind | type | status | num_val | string_val
> | bool_val | float_val |
> +------------+------------+------------+------------+------------+------------+------------+------------+
> | planner.enable_decimal_data_type | BOOLEAN | SYSTEM | DEFAULT |
> null | null | false | null |
> +------------+------------+------------+------------+------------+------------+------------+------------+
> 1 row selected (0.212 seconds)
> {code}
> In list that contains more than 20 numeric literals.
> We are casting number with the decimal point to decimal type even though
> decimal type is disabled:
> {code}
> 0: jdbc:drill:schema=dfs> explain plan including all attributes for select *
> from t1 where a1 in
> (1,2,3,4,5,6,7,8,9,0,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25.0);
> +------------+------------+
> | text | json |
> +------------+------------+
> | 00-00 Screen : rowType = RecordType(ANY *): rowcount = 10.0, cumulative
> cost = {24.0 rows, 158.0 cpu, 0.0 io, 0.0 network, 35.2 memory}, id = 4921
> 00-01 Project(*=[$0]) : rowType = RecordType(ANY *): rowcount = 10.0,
> cumulative cost = {23.0 rows, 157.0 cpu, 0.0 io, 0.0 network, 35.2 memory},
> id = 4920
> 00-02 Project(T7¦¦*=[$0]) : rowType = RecordType(ANY T7¦¦*): rowcount
> = 10.0, cumulative cost = {23.0 rows, 157.0 cpu, 0.0 io, 0.0 network, 35.2
> memory}, id = 4919
> 00-03 HashJoin(condition=[=($2, $3)], joinType=[inner]) : rowType =
> RecordType(ANY T7¦¦*, ANY a1, ANY a10, DECIMAL(11, 1) ROW_VALUE): rowcount =
> 10.0, cumulative cost = {23.0 rows, 157.0 cpu, 0.0 io, 0.0 network, 35.2
> memory}, id = 4918
> 00-05 Project(T7¦¦*=[$0], a1=[$1], a10=[$1]) : rowType =
> RecordType(ANY T7¦¦*, ANY a1, ANY a10): rowcount = 10.0, cumulative cost =
> {10.0 rows, 20.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 4915
> 00-07 Project(T7¦¦*=[$0], a1=[$1]) : rowType = RecordType(ANY
> T7¦¦*, ANY a1): rowcount = 10.0, cumulative cost = {10.0 rows, 20.0 cpu, 0.0
> io, 0.0 network, 0.0 memory}, id = 4914
> 00-08 Scan(groupscan=[ParquetGroupScan
> [entries=[ReadEntryWithPath [path=maprfs:/drill/testdata/subqueries/t1]],
> selectionRoot=/drill/testdata/subqueries/t1, numFiles=1, columns=[`*`]]]) :
> rowType = (DrillRecordRow[*, a1]): rowcount = 10.0, cumulative cost = {10.0
> rows, 20.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 4913
> 00-04 HashAgg(group=[{0}]) : rowType = RecordType(DECIMAL(11, 1)
> ROW_VALUE): rowcount = 1.0, cumulative cost = {2.0 rows, 9.0 cpu, 0.0 io, 0.0
> network, 17.6 memory}, id = 4917
> 00-06 Values : rowType = RecordType(DECIMAL(11, 1) ROW_VALUE):
> rowcount = 1.0, cumulative cost = {1.0 rows, 1.0 cpu, 0.0 io, 0.0 network,
> 0.0 memory}, id = 4916
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
