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 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
收件人: dev@kylin.apache.org
主题: Re: 查询无结果

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 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
where HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY.EXCHANGE_NAME = 'b11'


在 2019/1/30 上午10:21,“JiaTao Tao” 写入:

select
count(*)
from HUOBI_GLOBAL.HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY
where HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY.EXCHANGE_NAME = 'b11'








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
收件人: dev@kylin.apache.org
主题: Re: 查询无结果

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 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
where HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY.EXCHANGE_NAME = 'b11'


在 2019/1/30 上午10:21,“JiaTao Tao” 写入:

select
count(*)
from HUOBI_GLOBAL.HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY
where HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY.EXCHANGE_NAME = 'b11'





[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
  Issue Type: Bug
  Components: Environment 
Affects Versions: v2.6.0
Reporter: nichunen
Assignee: nichunen
 Fix For: Future






--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


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 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
where HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY.EXCHANGE_NAME = 'b11'


在 2019/1/30 上午10:21,“JiaTao Tao” 写入:

select
count(*)
from HUOBI_GLOBAL.HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY
where HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY.EXCHANGE_NAME = 'b11'





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
where HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY.EXCHANGE_NAME = 'b11'


在 2019/1/30 上午10:21,“JiaTao Tao” 写入:

select
count(*)
from HUOBI_GLOBAL.HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY
where HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY.EXCHANGE_NAME = 'b11'



[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
  Components: RDBMS Source
Reporter: XiaoXiang Yu
Assignee: XiaoXiang Yu
 Attachments: image-2019-01-30-11-14-11-939.png, 
image-2019-01-30-11-14-38-581.png, image-2019-01-30-11-15-07-865.png

 

  !image-2019-01-30-11-14-11-939.png!

 

  !image-2019-01-30-11-15-07-865.png!

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


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 HUOBI_GLOBAL.HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY
where HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY.EXCHANGE_NAME = 'b11'



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 = 'b11'
"
and see if there's any unexpected. It's more reasonable.


廉立伟  于2019年1月30日周三 上午1:49写道:

>
> 你好
> 我这样查询有结果, 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 = 'b11'
>
> 在 2019/1/30 上午9:45,“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
>
>
>

-- 


Regards!

Aron Tao


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 = 'b11'

在 2019/1/30 上午9:45,“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: 查询无结果

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 
sqlServerUrl="jdbc:sqlserver://cdh1.cloudera.com:1433;user=SA;password=Kyligence2019;DatabaseName=xiaoxiang_test";

Connection con = DriverManager.getConnection(sqlServerUrl);
DatabaseMetaData meta = con.getMetaData();

System.out.println("");
ResultSet rs1 = meta.getCatalogs();
while(rs1.next()){
System.out.println(String.format("Catalog \t%s", rs1.getString(1)));

}

rs1 = meta.getSchemas();
System.out.println("");
while(rs1.next()){
System.out.println(String.format("Schemas \t%s\t%s", 
rs1.getString(1), rs1.getString(2)));
}

Output as follow:


Catalog master
Catalog model
Catalog msdb
Catalog tempdb
Catalog xiaoxiang_test

Schemas db_accessadmin  null
Schemas db_backupoperator   null
Schemas db_datareader   null
Schemas db_datawriter   null
Schemas db_ddladmin null
Schemas db_denydatareader   null
Schemas db_denydatawriter   null
Schemas db_ownernull
Schemas db_securityadminnull
Schemas dbo null
Schemas guest   null
Schemas INFORMATION_SCHEMA  null
Schemas sys null


By the way, which version of sqlserver as you use, and which version of jdbc 
driver are you use? Maybe we can try to fix this by change the way of fetching 
metadata(catalog) in SQLServerJdbcMetadata.

If you find any mistake, please let me know.


Best wishes,
Xiaoxiang Yu 
 

On [DATE], "[NAME]" <[ADDRESS]> wrote:

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.
kylin.properties:

kylin.source.default=8kylin.source.jdbc.connection-url=jdbc:sqlserver://hostname:1433;database=samplekylin.source.jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriverkylin.source.jdbc.dialect=mssqlkylin.source.jdbc.user=userkylin.source.jdbc.pass=passkylin.source.jdbc.sqoop-home=sqoophomekylin.source.jdbc.filed-delimiter=|kylin.source.jdbc.sqoop-mapper-num=4
kylin.log
2019-01-28 22:52:27,948 DEBUG [http-bio-7070-exec-1] common.KylinConfig:328 
: KYLIN_CONF property was not set, will seek KYLIN_HOME env variable2019-01-28 
22:52:28,017 INFO  [FetcherRunner 992042775-44] 
threadpool.DefaultFetcherRunner:94 : Job Fetcher: 0 should running, 0 actual 
running, 0 stopped, 0 ready, 0 already succeed, 0 error, 0 discarded, 0 
others2019-01-28 22:52:28,123 INFO  [http-bio-7070-exec-4] 
common.KylinConfig:455 : Creating new manager instance of class 
org.apache.kylin.metadata.project.ProjectManager2019-01-28 22:52:28,125 INFO  
[http-bio-7070-exec-4] project.ProjectManager:81 : Initializing ProjectManager 
with metadata url kylin_metadata@hbase2019-01-28 22:52:28,129 DEBUG 
[http-bio-7070-exec-4] cachesync.CachedCrudAssist:118 : Reloading 
ProjectInstance from 
kylin_metadata(key='/project')@kylin_metadata@hbase2019-01-28 22:52:28,188 
DEBUG [http-bio-7070-exec-4] cachesync.CachedCrudAssist:127 : Loaded 1 
ProjectInstance(s) out of 1 resource2019-01-28 22:52:28,304 DEBUG 
[http-bio-7070-exec-5] project.ProjectL2Cache:198 : Loading L2 project cache 
for Testing2019-01-28 22:52:28,325 INFO  [http-bio-7070-exec-5] 
common.KylinConfig:455 : Creating new manager instance of class 
org.apache.kylin.metadata.TableMetadataManager2019-01-28 22:52:28,326 DEBUG 
[http-bio-7070-exec-5] cachesync.CachedCrudAssist:118 : Reloading TableDesc 
from kylin_metadata(key='/table')@kylin_metadata@hbase2019-01-28 22:52:28,333 
INFO  [http-bio-7070-exec-1] common.KylinConfig:455 : Creating new manager 
instance of class org.apache.kylin.metadata.model.DataModelManager2019-01-28 
22:52:28,360 DEBUG [http-bio-7070-exec-5] cachesync.CachedCrudAssist:127 : 
Loaded 0 TableDesc(s) out of 0 resource2019-01-28 22:52:28,361 DEBUG 
[http-bio-7070-exec-5] cachesync.CachedCrudAssist:118 : Reloading TableExtDesc 
from kylin_metadata(key='/table_exd')@kylin_metadata@hbase2019-01-28 
22:52:28,391 DEBUG [http-bio-7070-exec-5] cachesync.CachedCrudAssist:127 : 
Loaded 0 TableExtDesc(s) out of 0 resource2019-01-28 22:52:28,392 DEBUG 
[http-bio-7070-exec-5] cachesync.CachedCrudAssist:118 : Reloading 
ExternalFilterDesc from 
kylin_metadata(key='/ext_filter')@kylin_metadata@hbase2019-01-28 22:52:28,421 
DEBUG [http-bio-7070-exec-5] cachesync.CachedCrudAssist:127 : Loaded 0 
ExternalFilterDesc(s) out of 0 resource2019-01-28 22:52:28,423 DEBUG 

查询无结果

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 num in spark cubing. So you'd better not 
delete it. 



--
Best Regards,
Chao Long


--  --
??: ""<1059790...@qq.com>;
: 2019??1??29??(??) 3:19
??: "dev";

: kylin cube statistics 



--  --
??: ""<1059790...@qq.com>;
: 2019??1??28??(??) 11:42
??: "dev";

: kylin cube statistics 



??  cube merge cube_statistics  ??cube_statistics 


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.
kylin.properties:
kylin.source.default=8kylin.source.jdbc.connection-url=jdbc:sqlserver://hostname:1433;database=samplekylin.source.jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriverkylin.source.jdbc.dialect=mssqlkylin.source.jdbc.user=userkylin.source.jdbc.pass=passkylin.source.jdbc.sqoop-home=sqoophomekylin.source.jdbc.filed-delimiter=|kylin.source.jdbc.sqoop-mapper-num=4
kylin.log
2019-01-28 22:52:27,948 DEBUG [http-bio-7070-exec-1] common.KylinConfig:328 : 
KYLIN_CONF property was not set, will seek KYLIN_HOME env variable2019-01-28 
22:52:28,017 INFO  [FetcherRunner 992042775-44] 
threadpool.DefaultFetcherRunner:94 : Job Fetcher: 0 should running, 0 actual 
running, 0 stopped, 0 ready, 0 already succeed, 0 error, 0 discarded, 0 
others2019-01-28 22:52:28,123 INFO  [http-bio-7070-exec-4] 
common.KylinConfig:455 : Creating new manager instance of class 
org.apache.kylin.metadata.project.ProjectManager2019-01-28 22:52:28,125 INFO  
[http-bio-7070-exec-4] project.ProjectManager:81 : Initializing ProjectManager 
with metadata url kylin_metadata@hbase2019-01-28 22:52:28,129 DEBUG 
[http-bio-7070-exec-4] cachesync.CachedCrudAssist:118 : Reloading 
ProjectInstance from 
kylin_metadata(key='/project')@kylin_metadata@hbase2019-01-28 22:52:28,188 
DEBUG [http-bio-7070-exec-4] cachesync.CachedCrudAssist:127 : Loaded 1 
ProjectInstance(s) out of 1 resource2019-01-28 22:52:28,304 DEBUG 
[http-bio-7070-exec-5] project.ProjectL2Cache:198 : Loading L2 project cache 
for Testing2019-01-28 22:52:28,325 INFO  [http-bio-7070-exec-5] 
common.KylinConfig:455 : Creating new manager instance of class 
org.apache.kylin.metadata.TableMetadataManager2019-01-28 22:52:28,326 DEBUG 
[http-bio-7070-exec-5] cachesync.CachedCrudAssist:118 : Reloading TableDesc 
from kylin_metadata(key='/table')@kylin_metadata@hbase2019-01-28 22:52:28,333 
INFO  [http-bio-7070-exec-1] common.KylinConfig:455 : Creating new manager 
instance of class org.apache.kylin.metadata.model.DataModelManager2019-01-28 
22:52:28,360 DEBUG [http-bio-7070-exec-5] cachesync.CachedCrudAssist:127 : 
Loaded 0 TableDesc(s) out of 0 resource2019-01-28 22:52:28,361 DEBUG 
[http-bio-7070-exec-5] cachesync.CachedCrudAssist:118 : Reloading TableExtDesc 
from kylin_metadata(key='/table_exd')@kylin_metadata@hbase2019-01-28 
22:52:28,391 DEBUG [http-bio-7070-exec-5] cachesync.CachedCrudAssist:127 : 
Loaded 0 TableExtDesc(s) out of 0 resource2019-01-28 22:52:28,392 DEBUG 
[http-bio-7070-exec-5] cachesync.CachedCrudAssist:118 : Reloading 
ExternalFilterDesc from 
kylin_metadata(key='/ext_filter')@kylin_metadata@hbase2019-01-28 22:52:28,421 
DEBUG [http-bio-7070-exec-5] cachesync.CachedCrudAssist:127 : Loaded 0 
ExternalFilterDesc(s) out of 0 resource2019-01-28 22:52:28,423 DEBUG 
[http-bio-7070-exec-1] cachesync.CachedCrudAssist:118 : Reloading DataModelDesc 
from kylin_metadata(key='/model_desc')@kylin_metadata@hbase2019-01-28 
22:52:28,428 DEBUG [http-bio-7070-exec-1] cachesync.CachedCrudAssist:127 : 
Loaded 0 DataModelDesc(s) out of 0 resource2019-01-28 22:52:28,434 INFO  
[http-bio-7070-exec-5] common.KylinConfig:455 : Creating new manager instance 
of class org.apache.kylin.metadata.realization.RealizationRegistry2019-01-28 
22:52:28,435 INFO  [http-bio-7070-exec-5] realization.RealizationRegistry:54 : 
Initializing RealizationRegistry with metadata url 
kylin_metadata@hbase2019-01-28 22:52:28,455 INFO  [http-bio-7070-exec-5] 
common.KylinConfig:455 : Creating new manager instance of class 
org.apache.kylin.cube.CubeManager2019-01-28 22:52:28,468 INFO  
[http-bio-7070-exec-5] cube.CubeManager:133 : Initializing CubeManager with 
config kylin_metadata@hbase2019-01-28 22:52:28,469 DEBUG [http-bio-7070-exec-5] 
cachesync.CachedCrudAssist:118 : Reloading CubeInstance from 
kylin_metadata(key='/cube')@kylin_metadata@hbase2019-01-28 22:52:28,475 DEBUG 
[http-bio-7070-exec-5] cachesync.CachedCrudAssist:127 : Loaded 0 
CubeInstance(s) out of 0 resource2019-01-28 22:52:28,479 INFO  
[http-bio-7070-exec-5] common.KylinConfig:455 : Creating new manager instance 
of class org.apache.kylin.storage.hybrid.HybridManager2019-01-28 22:52:28,480 
INFO  [http-bio-7070-exec-5] hybrid.HybridManager:71 : Initializing 
HybridManager with config kylin_metadata@hbase2019-01-28 22:52:28,480 DEBUG 
[http-bio-7070-exec-5] cachesync.CachedCrudAssist:118 : Reloading 
HybridInstance from 
kylin_metadata(key='/hybrid')@kylin_metadata@hbase2019-01-28 22:52:28,483 DEBUG 
[http-bio-7070-exec-5] cachesync.CachedCrudAssist:127 : Loaded 0 
HybridInstance(s) out of 0 resource2019-01-28 22:52:28,484 INFO  
[http-bio-7070-exec-5] realization.RealizationRegistry:81 : RealizationRegistry 
is 

[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
  Components: Spark Engine
Reporter: Shaofeng SHI


Livy is a rest service for Spark. Some users are using Livy as the interface 
for Spark. Kylin can have the capability to submit spark job via Livy.

https://livy.incubator.apache.org/



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[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
  Components: Others
Reporter: Shaofeng SHI






--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[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
 Project: Kylin
  Issue Type: Improvement
Reporter: Zhong Yanghong
Assignee: Zhong Yanghong


There are two cases that mergeToInClause() does not work properly:
{code}
select count(*)
from TEST_KYLIN_FACT
where LSTG_FORMAT_NAME in ('ABIN', 'Auction') or DEAL_YEAR not in (2012, 2013)
{code}
{code}
select count(*)
from TEST_KYLIN_FACT
where LSTG_FORMAT_NAME in ('ABIN', 'Auction') or LSTG_FORMAT_NAME not in 
('Auction', 'Others')
{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)