[jira] [Created] (KYLIN-3403) Querying sample cube with filter "KYLIN_CAL_DT.WEEK_BEG_DT >= CAST('2001-09-09' AS DATE)" returns unexpected empty result set
Yifan Zhang created KYLIN-3403:
--
Summary: Querying sample cube with filter
"KYLIN_CAL_DT.WEEK_BEG_DT >= CAST('2001-09-09' AS DATE)" returns unexpected
empty result set
Key: KYLIN-3403
URL: https://issues.apache.org/jira/browse/KYLIN-3403
Project: Kylin
Issue Type: Bug
Components: Query Engine
Reporter: Yifan Zhang
Assignee: Yifan Zhang
2018-05-16 13:30:17,824 DEBUG [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-162]
cachesync.CachedCrudAssist : Loaded 3 ColumnACL(s) out of 3 resource
2018-05-16 13:30:17,840 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-162]
routing.QueryRouter : Find candidates by table DEFAULT.KYLIN_SALES and
project=learn_kylin :
INVERTED_INDEX[name=kylin_sales_cube],CUBE[name=kylin_sales_cube]
2018-05-16 13:30:17,841 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-162]
routing.QueryRouter : Applying rule: class
org.apache.kylin.query.routing.rules.RemoveBlackoutRealizationsRule,
realizations before:
[INVERTED_INDEX[name=kylin_sales_cube],CUBE[name=kylin_sales_cube]],
realizations after:
[INVERTED_INDEX[name=kylin_sales_cube],CUBE[name=kylin_sales_cube]]
2018-05-16 13:30:17,843 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-162]
routing.QueryRouter : Applying rule: class
org.apache.kylin.query.routing.rules.RemoveUncapableRealizationsRule,
realizations before:
[INVERTED_INDEX[name=kylin_sales_cube],CUBE[name=kylin_sales_cube]],
realizations after:
[INVERTED_INDEX[name=kylin_sales_cube],CUBE[name=kylin_sales_cube]]
2018-05-16 13:30:17,844 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-162]
rules.RealizationSortRule : INVERTED_INDEX[name=kylin_sales_cube] priority 1
cost 8360. CUBE[name=kylin_sales_cube] priority 1 cost 836.
2018-05-16 13:30:17,844 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-162]
routing.QueryRouter : Applying rule: class
org.apache.kylin.query.routing.rules.RealizationSortRule, realizations before:
[INVERTED_INDEX[name=kylin_sales_cube],CUBE[name=kylin_sales_cube]],
realizations after:
[CUBE[name=kylin_sales_cube],INVERTED_INDEX[name=kylin_sales_cube]]
2018-05-16 13:30:17,844 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-162]
routing.QueryRouter : The realizations remaining:
[CUBE[name=kylin_sales_cube],INVERTED_INDEX[name=kylin_sales_cube]],and the
final chosen one for current olap context 0 is CUBE[name=kylin_sales_cube]
2018-05-16 13:30:18,042 DEBUG [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-162]
enumerator.OLAPEnumerator : query storage...
2018-05-16 13:30:18,082 DEBUG [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-162]
gtrecord.GTCubeStorageQueryBase : Need storage aggregation
2018-05-16 13:30:18,083 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-162]
gtrecord.GTCubeStorageQueryBase : exactAggregation is false because need
storage aggregation
2018-05-16 13:30:18,091 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-162]
lookup.SnapshotManager : Loading snapshotTable from
/table_snapshot/DEFAULT.KYLIN_CAL_DT/2d3d125a-30f7-438f-bede-7212c5666f4a.snapshot,
with loadData: true
2018-05-16 13:30:18,197 DEBUG [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-162]
lookup.SnapshotManager : Loaded snapshot at
/table_snapshot/DEFAULT.KYLIN_CAL_DT/2d3d125a-30f7-438f-bede-7212c5666f4a.snapshot
2018-05-16 13:30:18,426 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-162]
gtrecord.GTCubeStorageQueryBase : Filter column set for query: []
2018-05-16 13:30:18,426 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-162]
gtrecord.GTCubeStorageQueryBase : Filter mask is: 0
2018-05-16 13:30:18,426 DEBUG [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-162]
gtrecord.GTCubeStorageQueryBase : storageLimitLevel set to NO_LIMIT because
derived column require post aggregation: [DEFAULT.KYLIN_SALES.PART_DT]
2018-05-16 13:30:18,426 DEBUG [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-162]
gtrecord.GTCubeStorageQueryBase : storageLimitLevel set to NO_LIMIT because the
query has order by
2018-05-16 13:30:18,427 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-162]
gtrecord.GTCubeStorageQueryBase : Cuboid identified: cube=kylin_sales_cube,
cuboidId=16384, groupsD=[], filterD=[], limitPushdown=2147483647,
limitLevel=NO_LIMIT, storageAggr=true
2018-05-16 13:30:18,429 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-162]
gtrecord.CubeSegmentScanner : Init CubeSegmentScanner for segment
2012010100_20180403152544
2018-05-16 13:30:18,476 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-162]
gtrecord.ScannerWorker : Segment
kylin_sales_cube[2012010100_20180403152544] will be skipped
2018-05-16 13:30:18,477 DEBUG [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-162]
enumerator.OLAPEnumerator : return TupleIterator...
2018-05-16 13:30:18,481 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-162]
service.QueryService : Processed rows for each storageContext: 0
2018-05-16 13:30:18,481 INFO [Query
[jira] [Created] (KYLIN-2583) Code refactor, move data source statement to query module
Yifan Zhang created KYLIN-2583: -- Summary: Code refactor, move data source statement to query module Key: KYLIN-2583 URL: https://issues.apache.org/jira/browse/KYLIN-2583 Project: Kylin Issue Type: Improvement Reporter: Yifan Zhang Assignee: Yifan Zhang Priority: Minor -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Created] (KYLIN-2569) Long Query fails on ODBC driver
Yifan Zhang created KYLIN-2569:
--
Summary: Long Query fails on ODBC driver
Key: KYLIN-2569
URL: https://issues.apache.org/jira/browse/KYLIN-2569
Project: Kylin
Issue Type: Bug
Components: Driver - ODBC
Environment: Windows, IBM Cognos & MS PowerQuery
Reporter: Yifan Zhang
Such long query will fail, so as other queries with similar length
{code:sql}
select 'This is a long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long long long long long long
long long long long long long long long long long long
[jira] [Created] (KYLIN-2558) ODBC: SQLPrepare(SQLPrepareW) should prepare query metadata
Yifan Zhang created KYLIN-2558:
--
Summary: ODBC: SQLPrepare(SQLPrepareW) should prepare query
metadata
Key: KYLIN-2558
URL: https://issues.apache.org/jira/browse/KYLIN-2558
Project: Kylin
Issue Type: Bug
Components: Driver - ODBC
Affects Versions: v1.6.0
Reporter: Yifan Zhang
When use SSRS BI to save query to dataset, error will be thrown out.
Root cause, SQLPrepareW does not prepare column info and SQLNumResultCols will
fail.
{code:title=driver_debug.log}
[DEBUG]SQLPrepareW called on: 191574520
[INFO ]SQLFreeStmt called, 191574520 with option 0
[DEBUG]SQLFreeStmt called for Result
[DEBUG]The query being prepared is :
[DEBUG]SELECT COUNT(*) AS AA
FROM kylin_sales
[DEBUG]SQLNumResultCols called
[DEBUG]_SQLPutDiagRow called, handle type is 3
[DEBUG]DiagMsg: [Kylin][ODBC 1.0(w) Driver]no resultset or IRD
{code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
[jira] [Created] (KYLIN-2539) Useless filter dimension will impact cuboid selection.
Yifan Zhang created KYLIN-2539: -- Summary: Useless filter dimension will impact cuboid selection. Key: KYLIN-2539 URL: https://issues.apache.org/jira/browse/KYLIN-2539 Project: Kylin Issue Type: Bug Reporter: Yifan Zhang Query1: select count(*) from test_kylin_fact where (cal_dt > DATE'2012-01-01') and (seller_id is null or 1 = 1) Query2: select count(*) from test_kylin_fact where (cal_dt > DATE'2012-01-01') Q1 and Q2 return identical result but hit different cuboid: 43051 and 1310735, and result in different query performance. -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Created] (KYLIN-2473) ODBC: Date type values not displayed in MSTR sample view
Yifan Zhang created KYLIN-2473: -- Summary: ODBC: Date type values not displayed in MSTR sample view Key: KYLIN-2473 URL: https://issues.apache.org/jira/browse/KYLIN-2473 Project: Kylin Issue Type: Bug Components: Driver - ODBC Reporter: Yifan Zhang Priority: Minor Attachments: Screen Shot 2017-02-28 at 16.40.29.png MSTR BI with Kylin ODBC connectivity configured. When viewing sample data of selected table, all data type can be displayed except Date. -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Created] (KYLIN-2108) Support usage of schema name "default" in SQL
Yifan Zhang created KYLIN-2108: -- Summary: Support usage of schema name "default" in SQL Key: KYLIN-2108 URL: https://issues.apache.org/jira/browse/KYLIN-2108 Project: Kylin Issue Type: Improvement Components: Query Engine Reporter: Yifan Zhang Assignee: Yifan Zhang Priority: Minor Calcite will treat "DEFAULT" as internal keyword, while "DEFAULT" is also used as HIVE's default schema name. We need to escape such case of usage by quote it. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
