[CANCELLED][VOTE] Release apache-kylin-5.0.0-alpha (RC1)

2023-04-07 Thread Xiaoxiang Yu
This vote is cancelled due to apache rules.

Xiaoxiang Yu, Apache Kylin PMC
http://people.apache.org/~xxyu/


Re: [VOTE] Release apache-kylin-5.0.0-alpha (RC1)

2023-04-07 Thread Xiaoxiang Yu
Thanks, I will cancel this vote .

Xiaoxiang Yu, Apache Kylin PMC
http://people.apache.org/~xxyu/



On Fri, Apr 7, 2023 at 2:56 PM ShaoFeng Shi  wrote:

> Thanks Xiaoxiang for preparing this.
>
> While I have to give a -1, as I find several binary files included in the
> source package:
>
> - build/async-profiler-lib has several .so binary files;
> - jdbc/libs has several log4j jar files;
> - spark-project/examples has a zip file;
> - dev-support/local/images has several PNG files;
>
> Besides, the "kylin-it" and "examples" folders are beyond 100MB, which
> makes the source release package is > 100MB, which is not reasonable; Seems
> they include many sample data; If they are only for demo or test case
> purpose, try to exclude them from the source release.
>
>
> Best regards,
>
> Shaofeng Shi 史少锋
> Apache Kylin PMC,
> Apache Incubator PMC,
> Email: shaofeng...@apache.org
>
> Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html
> Join Kylin user mail group: user-subscr...@kylin.apache.org
> Join Kylin dev mail group: dev-subscr...@kylin.apache.org
>
>
>
>
> Xiaoxiang Yu  于2023年4月7日周五 14:25写道:
>
> > 1. UT has passed in my test env.
> > For some reasons, runing UT required some paramters, so I used scripts
> > dev-support/unit_testing.sh
> > (
> >
> https://github.com/apache/kylin/blob/kylin-5.0.0-alpha/dev-support/unit_testing.sh
> )
> > on
> > docker container(https://hub.docker.com/r/apachekylin/release-machine ).
> >
> >
> > 2. Happy path(including modeling and query etc) passed in my Hadoop
> > env(Hadoop 3.2.1, Hive 3.1.2).
> > Please note, before start Kylin by executing 'bin/kylin.sh start', please
> > execute 'sbin/download-spark-user.sh' first .
> > Current release candidate binary requires a specific Spark which
> > downloaded by sbin/download-spark-user.sh.
> >
> >
> >
> >
> > --
> >
> > Best wishes to you !
> > From :Xiaoxiang Yu
> >
> >
> >
> >
> >
> > At 2023-04-07 12:10:00, "Xiaoxiang Yu"  wrote:
> > >Hi all,
> > >
> > >I have created a build for Apache Kylin 5.0.0-alpha, release candidate
> 1.
> > >Changes highlights:
> > >
> > >[KYLIN-5216] - Upgrade metadata and engine : Kylin 5.0
> > >[KYLIN-5397] - Support sum_lc function
> > >[KYLIN-5387] - Index planner phase 1 for kylin 5
> > >[KYLIN-5443] - Optimize the ER diagram of the model list page
> > >[KYLIN-5459] - Partial Log Governance
> > >[KYLIN-5374] - Provides Spark DDL & DML execution capability in GUI
> > >[KYLIN-5309] - Propose more flexible runtime join scenarios for Kylin
> > >[KYLIN-5297] - Add Kylin5 Jdbc module
> > >[KYLIN-5390] - Build tasks support segment coverage
> > >[KYLIN-5417] - streaming custom data parser
> > >[KYLIN-5235] - Add doc for How to write document
> > >[KYLIN-5236] - Add doc for how to contribute
> > >[KYLIN-5249] - Add node status notification on web ui
> > >[KYLIN-5256] - Add a cache for the system property get by the optional
> > >config in KylinConfigBase
> > >[KYLIN-5274] - Improve performance of getSubstitutor
> > >[KYLIN-5361] - suggest set email content from hard code to configurable
> > >files
> > >
> > >
> > >
> > >Thanks to everyone who has contributed to this release.
> > >
> > >Here are the release notes:
> > >
> >
> https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12316121=12352155
> > >
> > >The commit to being voted upon:
> > >
> >
> https://github.com/apache/kylin/commit/efc9170e2f068dfe925007b11310efc32461b68e
> > >Its hash is efc9170e2f068dfe925007b11310efc32461b68e.
> > >
> > >The artifacts to be voted on, including the source package and one
> > >pre-compiled binary package are located here:
> > >
> >
> https://dist.apache.org/repos/dist/dev/kylin/apache-kylin-5.0.0-alpha-rc1/
> > >
> > >The hash of the artifacts are as follows:
> > >apache-kylin-5.0.0-alpha-source-release.zip.sha256
> > >1f5742861b487229355343815a0373da87e05f7203de1f729a50a0858f0c8204
> > >
> > >apache-kylin-5.0.0-alpha-bin.tar.gz.sha256
> > >5af01b182396533e7bccebb1b1aef7135228f2f64b2ba2017447e7335b5a40b4
> > >
> > >A staged Maven repository is available for review at:
> > >https://repository.apache.org/content/repositories/orgapachekylin-1106/
> > >
> > >Release artifacts are signed with the following key:
> > >https://people.apache.org/keys/committer/xxyu.asc
> > >
> > >
> > >
> > >Please vote on releasing this package as Apache Kylin 5.0.0-alpha.
> > >
> > >The vote is open for the next 72 hours and passes if a majority of
> > >at least three +1 PMC votes are cast.
> > >
> > >[ ] +1 Release this package as Apache Kylin 5.0.0-alpha
> > >[ ] 0 I don't feel strongly about it, but I'm okay with the release
> > >[ ] -1 Do not release this package because...
> > >
> > >Here is my vote:
> > >+1 (binding)
> > >
> > >Xiaoxiang Yu, Apache Kylin PMC
> > >http://people.apache.org/~xxyu/
> >
>


MS SQL server as a source for Kylin

2023-04-07 Thread Rajesh A
Hi All

 When I am trying to use SQL server as the source for Kylin via JDBC
instead of Hive, as per the steps listed in the official documentation,
getting an error. Error and config details are attached. I am using the
Kylin docker. Kylin is working fine if i use hive as the source.

Thanks and Regards
Rajesh Abraham
kylin.source.default=8
kylin.source.jdbc.connection-url=jdbc:sqlserver://10.236.221.117:1433;database=mm_usage
kylin.source.jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
kylin.source.jdbc.dialect=mssql
kylin.source.jdbc.user=mm_usage
kylin.source.jdbc.pass=CvidyaU123456
kylin.source.jdbc.sqoop-home=/usr/lib/sqoop/
kylin.source.jdbc.filed-delimiter=|
kylin.source.jdbc.sqoop-mapper-num=4


 Scoop results if i run it stand alone in the same docker
[root@b419c84c48dc admin]#  /usr/lib/sqoop/bin/sqoop-list-databases --username 
mm_usage --password CvidyaU123456 --connect 
jdbc:sqlserver://10.236.221.117:1433;database=mm_usage
Warning: /usr/lib/sqoop/../hbase does not exist! HBase imports will fail.
Please set $HBASE_HOME to the root of your HBase installation.
Warning: /usr/lib/sqoop/../hcatalog does not exist! HCatalog jobs will fail.
Please set $HCAT_HOME to the root of your HCatalog installation.
Warning: /usr/lib/sqoop/../accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
Warning: /usr/lib/sqoop/../zookeeper does not exist! Accumulo imports will fail.
Please set $ZOOKEEPER_HOME to the root of your Zookeeper installation.
23/04/05 13:24:21 INFO sqoop.Sqoop: Running Sqoop version: 1.4.5
23/04/05 13:24:21 WARN tool.BaseSqoopTool: Setting your password on the 
command-line is insecure. Consider using -P instead.
23/04/05 13:24:21 INFO manager.SqlManager: Using default fetchSize of 1000
master
tempdb
model
msdb
mm_demo
mm_usage

--Lib listing for sqoop-

[root@b419c84c48dc admin]# ls $KYLIN_HOME/ext
sqljdbc41.jar  sqljdbc_12.2.0.0_enu.tar.gz  sqljdbc_6.0  
sqljdbc_6.0.8112.200_enu.tar

[root@b419c84c48dc admin]# ls $SQOOP_HOME/lib
ant-contrib-1.0b3.jar  commons-compress-1.4.1.jar   
jackson-mapper-asl-1.9.13.jar  sqljdbc_12.2  xz-1.0.jar
ant-eclipse-1.0-jvm1.2.jar commons-io-1.4.jar   paranamer-2.3.jar   
   sqljdbc_12.2.0.0_enu.tar
avro-1.7.5.jar hsqldb-1.8.0.10.jar  
snappy-java-1.0.5.jar  sqljdbc_6.0
avro-mapred-1.7.5-hadoop2.jar  jackson-core-asl-1.9.13.jar  sqljdbc41.jar   
   sqljdbc_6.0.8112.200_enu.tar

---kylin exception is below-
2023-04-05 13:16:26,673 ERROR [http-bio-7070-exec-5] source.SourceManager:118 : 
Failed to create source: SourceType=8
java.lang.NullPointerException
at 
org.apache.kylin.common.util.ClassUtil.forRenamedClass(ClassUtil.java:79)
at org.apache.kylin.common.util.ClassUtil.forName(ClassUtil.java:74)
at 
org.apache.kylin.source.SourceManager.createSource(SourceManager.java:115)
at 
org.apache.kylin.source.SourceManager.getCachedSource(SourceManager.java:84)
at 
org.apache.kylin.source.SourceManager.getProjectSource(SourceManager.java:93)
at 
org.apache.kylin.rest.service.TableService.getSourceDbNames(TableService.java:272)
at 
org.apache.kylin.rest.controller.TableController.showHiveDatabases(TableController.java:212)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at 
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
at 
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
at 
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
at 
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:854)
at 
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:765)
at 
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
at 
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
at 
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
at 
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
at 
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
at 

Re: [VOTE] Release apache-kylin-5.0.0-alpha (RC1)

2023-04-07 Thread ShaoFeng Shi
Thanks Xiaoxiang for preparing this.

While I have to give a -1, as I find several binary files included in the
source package:

- build/async-profiler-lib has several .so binary files;
- jdbc/libs has several log4j jar files;
- spark-project/examples has a zip file;
- dev-support/local/images has several PNG files;

Besides, the "kylin-it" and "examples" folders are beyond 100MB, which
makes the source release package is > 100MB, which is not reasonable; Seems
they include many sample data; If they are only for demo or test case
purpose, try to exclude them from the source release.


Best regards,

Shaofeng Shi 史少锋
Apache Kylin PMC,
Apache Incubator PMC,
Email: shaofeng...@apache.org

Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html
Join Kylin user mail group: user-subscr...@kylin.apache.org
Join Kylin dev mail group: dev-subscr...@kylin.apache.org




Xiaoxiang Yu  于2023年4月7日周五 14:25写道:

> 1. UT has passed in my test env.
> For some reasons, runing UT required some paramters, so I used scripts
> dev-support/unit_testing.sh
> (
> https://github.com/apache/kylin/blob/kylin-5.0.0-alpha/dev-support/unit_testing.sh)
> on
> docker container(https://hub.docker.com/r/apachekylin/release-machine ).
>
>
> 2. Happy path(including modeling and query etc) passed in my Hadoop
> env(Hadoop 3.2.1, Hive 3.1.2).
> Please note, before start Kylin by executing 'bin/kylin.sh start', please
> execute 'sbin/download-spark-user.sh' first .
> Current release candidate binary requires a specific Spark which
> downloaded by sbin/download-spark-user.sh.
>
>
>
>
> --
>
> Best wishes to you !
> From :Xiaoxiang Yu
>
>
>
>
>
> At 2023-04-07 12:10:00, "Xiaoxiang Yu"  wrote:
> >Hi all,
> >
> >I have created a build for Apache Kylin 5.0.0-alpha, release candidate 1.
> >Changes highlights:
> >
> >[KYLIN-5216] - Upgrade metadata and engine : Kylin 5.0
> >[KYLIN-5397] - Support sum_lc function
> >[KYLIN-5387] - Index planner phase 1 for kylin 5
> >[KYLIN-5443] - Optimize the ER diagram of the model list page
> >[KYLIN-5459] - Partial Log Governance
> >[KYLIN-5374] - Provides Spark DDL & DML execution capability in GUI
> >[KYLIN-5309] - Propose more flexible runtime join scenarios for Kylin
> >[KYLIN-5297] - Add Kylin5 Jdbc module
> >[KYLIN-5390] - Build tasks support segment coverage
> >[KYLIN-5417] - streaming custom data parser
> >[KYLIN-5235] - Add doc for How to write document
> >[KYLIN-5236] - Add doc for how to contribute
> >[KYLIN-5249] - Add node status notification on web ui
> >[KYLIN-5256] - Add a cache for the system property get by the optional
> >config in KylinConfigBase
> >[KYLIN-5274] - Improve performance of getSubstitutor
> >[KYLIN-5361] - suggest set email content from hard code to configurable
> >files
> >
> >
> >
> >Thanks to everyone who has contributed to this release.
> >
> >Here are the release notes:
> >
> https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12316121=12352155
> >
> >The commit to being voted upon:
> >
> https://github.com/apache/kylin/commit/efc9170e2f068dfe925007b11310efc32461b68e
> >Its hash is efc9170e2f068dfe925007b11310efc32461b68e.
> >
> >The artifacts to be voted on, including the source package and one
> >pre-compiled binary package are located here:
> >
> https://dist.apache.org/repos/dist/dev/kylin/apache-kylin-5.0.0-alpha-rc1/
> >
> >The hash of the artifacts are as follows:
> >apache-kylin-5.0.0-alpha-source-release.zip.sha256
> >1f5742861b487229355343815a0373da87e05f7203de1f729a50a0858f0c8204
> >
> >apache-kylin-5.0.0-alpha-bin.tar.gz.sha256
> >5af01b182396533e7bccebb1b1aef7135228f2f64b2ba2017447e7335b5a40b4
> >
> >A staged Maven repository is available for review at:
> >https://repository.apache.org/content/repositories/orgapachekylin-1106/
> >
> >Release artifacts are signed with the following key:
> >https://people.apache.org/keys/committer/xxyu.asc
> >
> >
> >
> >Please vote on releasing this package as Apache Kylin 5.0.0-alpha.
> >
> >The vote is open for the next 72 hours and passes if a majority of
> >at least three +1 PMC votes are cast.
> >
> >[ ] +1 Release this package as Apache Kylin 5.0.0-alpha
> >[ ] 0 I don't feel strongly about it, but I'm okay with the release
> >[ ] -1 Do not release this package because...
> >
> >Here is my vote:
> >+1 (binding)
> >
> >Xiaoxiang Yu, Apache Kylin PMC
> >http://people.apache.org/~xxyu/
>


Re:[VOTE] Release apache-kylin-5.0.0-alpha (RC1)

2023-04-07 Thread Xiaoxiang Yu
1. UT has passed in my test env. 
For some reasons, runing UT required some paramters, so I used scripts 
dev-support/unit_testing.sh
(https://github.com/apache/kylin/blob/kylin-5.0.0-alpha/dev-support/unit_testing.sh)
 on 
docker container(https://hub.docker.com/r/apachekylin/release-machine ).


2. Happy path(including modeling and query etc) passed in my Hadoop env(Hadoop 
3.2.1, Hive 3.1.2). 
Please note, before start Kylin by executing 'bin/kylin.sh start', please 
execute 'sbin/download-spark-user.sh' first . 
Current release candidate binary requires a specific Spark which downloaded by 
sbin/download-spark-user.sh.




--

Best wishes to you ! 
From :Xiaoxiang Yu





At 2023-04-07 12:10:00, "Xiaoxiang Yu"  wrote:
>Hi all,
>
>I have created a build for Apache Kylin 5.0.0-alpha, release candidate 1.
>Changes highlights:
>
>[KYLIN-5216] - Upgrade metadata and engine : Kylin 5.0
>[KYLIN-5397] - Support sum_lc function
>[KYLIN-5387] - Index planner phase 1 for kylin 5
>[KYLIN-5443] - Optimize the ER diagram of the model list page
>[KYLIN-5459] - Partial Log Governance
>[KYLIN-5374] - Provides Spark DDL & DML execution capability in GUI
>[KYLIN-5309] - Propose more flexible runtime join scenarios for Kylin
>[KYLIN-5297] - Add Kylin5 Jdbc module
>[KYLIN-5390] - Build tasks support segment coverage
>[KYLIN-5417] - streaming custom data parser
>[KYLIN-5235] - Add doc for How to write document
>[KYLIN-5236] - Add doc for how to contribute
>[KYLIN-5249] - Add node status notification on web ui
>[KYLIN-5256] - Add a cache for the system property get by the optional
>config in KylinConfigBase
>[KYLIN-5274] - Improve performance of getSubstitutor
>[KYLIN-5361] - suggest set email content from hard code to configurable
>files
>
>
>
>Thanks to everyone who has contributed to this release.
>
>Here are the release notes:
>https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12316121=12352155
>
>The commit to being voted upon:
>https://github.com/apache/kylin/commit/efc9170e2f068dfe925007b11310efc32461b68e
>Its hash is efc9170e2f068dfe925007b11310efc32461b68e.
>
>The artifacts to be voted on, including the source package and one
>pre-compiled binary package are located here:
>https://dist.apache.org/repos/dist/dev/kylin/apache-kylin-5.0.0-alpha-rc1/
>
>The hash of the artifacts are as follows:
>apache-kylin-5.0.0-alpha-source-release.zip.sha256
>1f5742861b487229355343815a0373da87e05f7203de1f729a50a0858f0c8204
>
>apache-kylin-5.0.0-alpha-bin.tar.gz.sha256
>5af01b182396533e7bccebb1b1aef7135228f2f64b2ba2017447e7335b5a40b4
>
>A staged Maven repository is available for review at:
>https://repository.apache.org/content/repositories/orgapachekylin-1106/
>
>Release artifacts are signed with the following key:
>https://people.apache.org/keys/committer/xxyu.asc
>
>
>
>Please vote on releasing this package as Apache Kylin 5.0.0-alpha.
>
>The vote is open for the next 72 hours and passes if a majority of
>at least three +1 PMC votes are cast.
>
>[ ] +1 Release this package as Apache Kylin 5.0.0-alpha
>[ ] 0 I don't feel strongly about it, but I'm okay with the release
>[ ] -1 Do not release this package because...
>
>Here is my vote:
>+1 (binding)
>
>Xiaoxiang Yu, Apache Kylin PMC
>http://people.apache.org/~xxyu/