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

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 廉立伟
你好 我这样查询有结果, 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, 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 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

[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 廉立伟
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 收件人:

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 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 廉立伟
怎么没结果 你们解决下呀 获取 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

[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

??????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

[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

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.

查询无结果

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