Re: 查询无结果

2019-01-29 Thread Yifei Wu
Hi, liwei, It sounds like a Kylin Query bug, could you open a jira to describe this question and how to reproduce this question in detail, for it be very helpful for Locating the root cause. BR Yifei Wu 在 2019/1/30 下午2:49,“廉立伟” 写入: select count(*),EXCHANGE_NAME from

Re: 查询无结果

2019-01-29 Thread 廉立伟
select count(*),EXCHANGE_NAME from HUOBI_GLOBAL.HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY group by EXCHANGE_NAME order by EXCHANGE_NAME 这样的话有结果 有b11 但是where的时候就没有 获取 Outlook for iOS 收件人: Li Feng 发送时间: 星期三, 一月 30, 2019 13:15 收件人:

[jira] [Created] (KYLIN-3799) Wrong hive-exec jar may be found by find-hive-dependency.sh on CDH

2019-01-29 Thread nichunen (JIRA)
nichunen created KYLIN-3799: --- Summary: Wrong hive-exec jar may be found by find-hive-dependency.sh on CDH Key: KYLIN-3799 URL: https://issues.apache.org/jira/browse/KYLIN-3799 Project: Kylin

Re: 查询无结果

2019-01-29 Thread Li Feng
Hi Liwei Try select count(*),EXCHANGE_NAME from HUOBI_GLOBAL.HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY group by EXCHANGE_NAME order by EXCHANGE_NAME and check whether there exists 'b11' value. BR, Lee 在 19/1/30 下午1:08,“廉立伟” 写入: 怎么没结果 你们解决下呀 获取 Outlook for

Re: 查询无结果

2019-01-29 Thread 廉立伟
怎么没结果 你们解决下呀 获取 Outlook for iOS 收件人: 廉立伟 发送时间: 星期三, 一月 30, 2019 10:23 收件人: dev@kylin.apache.org 主题: Re: 查询无结果 这样查询结果为0,但是我的数据中确实有EXCHANGE_NAME = 'b11',怎么查不出来呢 select count(*) from HUOBI_GLOBAL.HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY

[jira] [Created] (KYLIN-3798) SQL Server cannot list databases

2019-01-29 Thread XiaoXiang Yu (JIRA)
XiaoXiang Yu created KYLIN-3798: --- Summary: SQL Server cannot list databases Key: KYLIN-3798 URL: https://issues.apache.org/jira/browse/KYLIN-3798 Project: Kylin Issue Type: Bug

Re: 查询无结果

2019-01-29 Thread 廉立伟
这样查询结果为0,但是我的数据中确实有EXCHANGE_NAME = 'b11',怎么查不出来呢 select count(*) from HUOBI_GLOBAL.HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY where HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY.EXCHANGE_NAME = 'b11' 在 2019/1/30 上午10:21,“JiaTao Tao” 写入: select count(*) from

Re: 查询无结果

2019-01-29 Thread JiaTao Tao
Hi, Kylin is not for "select *" style query. See http://kylin.apache.org/docs/gettingstarted/faq.html (Why I got an error when running a “select * “ query?) Try " select count(*) from HUOBI_GLOBAL.HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY where HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY.EXCHANGE_NAME

Re: 查询无结果

2019-01-29 Thread 廉立伟
你好 我这样查询有结果, EXCHANGE_NAME为b11 select EXCHANGE_NAME from HUOBI_GLOBAL.HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY group by EXCHANGE_NAME 但是我这样查询结果为0,这是为啥呢 select EXCHANGE_NAME from HUOBI_GLOBAL.HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY where HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY.EXCHANGE_NAME =

Re: 查询无结果

2019-01-29 Thread JiaTao Tao
Hi, Can not see your pic, can you describe your problem? 廉立伟 于2019年1月29日周二 下午2:26写道: > > > 你好 加where查询没有结果 为啥 > > M *lianli...@huobi.com * > > > -- Regards! Aron Tao

Re: SQL Server JDBC Datasource doesnt list tables.

2019-01-29 Thread Xiaoxiang Yu
Hi Gladson, I reproduce the same situation in my dev env,. The question is caused by org.apache.kylin.source.jdbc.metadata.SQLServerJdbcMetadata.java(Line:53) didn't report null in "TABLE_CATALOG" column. This can be verified by following code: String

查询无结果

2019-01-29 Thread 廉立伟
你好 加where查询没有结果 为啥 [cid:image001.png@01D4B821.B1CF9570] M lianli...@huobi.com

??????kylin cube statistics ????

2019-01-29 Thread Chao Long
Hi ?? (1) Cube merging will merge the files under ??cube_statistics?? directory of the merging segments. (2) ??cube_statistics?? save the cube's estimated information(like cuboid rowcount, cuboid size), and it is used in many places, like spliting hbase region, estimating the partition

SQL Server JDBC Datasource doesnt list tables.

2019-01-29 Thread Gladson Vas
Hi,     I followed all the steps in this url  http://kylin.apache.org/docs/tutorial/setup_jdbc_datasource.html , but when i click on Load table button or Load table from tree i don't seem to have any tables loaded from the SQL Server data source.There are no errors/exceptions in the logs too.

[jira] [Created] (KYLIN-3795) Submit Spark jobs via Apache Livy

2019-01-29 Thread Shaofeng SHI (JIRA)
Shaofeng SHI created KYLIN-3795: --- Summary: Submit Spark jobs via Apache Livy Key: KYLIN-3795 URL: https://issues.apache.org/jira/browse/KYLIN-3795 Project: Kylin Issue Type: New Feature

[jira] [Created] (KYLIN-3796) MongoDB as data source

2019-01-29 Thread Shaofeng SHI (JIRA)
Shaofeng SHI created KYLIN-3796: --- Summary: MongoDB as data source Key: KYLIN-3796 URL: https://issues.apache.org/jira/browse/KYLIN-3796 Project: Kylin Issue Type: New Feature

[jira] [Created] (KYLIN-3794) mergeToInClause in TupleFilterVisitor cannot work properly in some edge cases

2019-01-29 Thread Zhong Yanghong (JIRA)
Zhong Yanghong created KYLIN-3794: - Summary: mergeToInClause in TupleFilterVisitor cannot work properly in some edge cases Key: KYLIN-3794 URL: https://issues.apache.org/jira/browse/KYLIN-3794