Re: Kylin ODBC driver is removed from download page
Hello Kylin users, The Kylin PMC has discussed this issue, and here is the conclusion: - Apache Kylin will releases the ODBC driver in source code format, under Apache License v2; - If you need the binary, you can compile and build it from source code by your own, or seek third-party. Best regards, Shaofeng Shi 史少锋 Apache Kylin 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 ShaoFeng Shi 于2019年3月12日周二 上午9:39写道: > Hello Kylin users, > > The Kylin ODBC driver was removed from Apache Kylin download web page at > yesterday. The reason is that the ODBC driver binary package (.exe files) > wasn't formally voted by the PMC (although it has been there for some > time). To be compliant with asf policy, we removed that. The PMC will > discuss the follow-up actions, but there is no ETA for when it can be > recovered. > > If you still need the ODBC driver, you can try to compile it from the > source code ("odbc" folder in Kylin source release). > > On behalf of Apache Kylin PMC > > Best regards, > > Shaofeng Shi 史少锋 > Apache Kylin 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 > > >
Kylin ODBC driver is removed from download page
Hello Kylin users, The Kylin ODBC driver was removed from Apache Kylin download web page at yesterday. The reason is that the ODBC driver binary package (.exe files) wasn't formally voted by the PMC (although it has been there for some time). To be compliant with asf policy, we removed that. The PMC will discuss the follow-up actions, but there is no ETA for when it can be recovered. If you still need the ODBC driver, you can try to compile it from the source code ("odbc" folder in Kylin source release). On behalf of Apache Kylin PMC Best regards, Shaofeng Shi 史少锋 Apache Kylin 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
Apache Kylin ODBC Driver 2.1.0 rolled out!
Hello, With Apache Kylin 2.1.0 released in last week, we also built and rolled out new ODBC Driver (v2.1.0) binary packages Here're some hightlight updates: [KYLIN-2558] - ODBC: SQLPrepare(SQLPrepareW) should prepare query metadata [KYLIN-2793] - ODBC Driver - Bypass cert validation when connect to SSL service You can download latest driver installers from download page: http://kylin.apache.org/download/ Any help or feedback are welcomed. For more information on how to report problems, and to get involved, visit the Apache Kylin website at https://kylin.apache.org/ Thanks, Dong Li
Re: Kylin ODBC
Hi Alberto the observed error: *[INFO ][2016-09-14.06:48:47]select "PART_DT", * *"LEAF_CATEG_ID", * *"LSTG_SITE_ID", * *"LSTG_FORMAT_NAME", * *"PRICE", * *"SELLER_ID" * *from "DEFAULT"."KYLIN_SALES"* *[ERROR][2016-09-14.06:49:53]The REST query request failed, the error message is: Error while executing SQL "select "PART_DT", "LEAF_CATEG_ID", "LSTG_SITE_ID", "LSTG_FORMAT_NAME", "PRICE", "SELLER_ID" from "DEFAULT"."KYLIN_SALES"": Timeout visiting cube!* looks very suspicious. I suggest to debug from here. You can use query API instead of Kylin GUI to exclude side effects ( http://kylin.apache.org/docs15/howto/howto_use_restapi.html#query). Also please consider using 1.5.4, it takes better case of "cube visit timeout" error messages. AFAIK power BI will try to pull the whole dataset from DB to local, so it's always a potential issue to adopt Power BI for kylin ( when the data size grows huge) On Thu, Sep 15, 2016 at 2:36 AM, Alberto Ramón <a.ramonporto...@gmail.com> wrote: > hello > > See this Video: <https://youtu.be/v9of5N3TcTw> > > Query with *limit 5*, the preview data run OK, but load data ... never > finished > > Somebody has tested Kylin with New Microsoft Power Bi Desktop ? > > 2016-09-14 11:54 GMT+02:00 Alberto Ramón <a.ramonporto...@gmail.com>: > >> The cube is the Kylin Example, the fact table have 9.800 Row, and return >> time to Kylin UI are 0.3 Seconds >> and CATEGORY_GROUPINGS has 144 rows >> >> ==> I think isnt't a performance problem >> >> *sound like , cast problem, overflow of int, or Nulls* >> But I don't Know the which Row / Column have a problematic Value in any >> log :( >> >> 2016-09-14 8:08 GMT+02:00 Abhilash L L <abhil...@infoworks.io>: >> >>> Hello Alberto, >>> >>> When the request is made via the Kylin UI, it adds an 'accept >>> partial' flag, which is similar to a 'limit' in sql world. >>> >>> When the query is being sent over odbc, kylin server is expected to >>> send all the records as the output >>> >>> Please check the thread titled 'kylin cube performance' for more >>> information. >>> >>> Regards, >>> Abhilash >>> >>> On Wed, Sep 14, 2016 at 10:48 AM, Alberto Ramón < >>> a.ramonporto...@gmail.com> wrote: >>> >>>> I found this >>>> From Kylin ODBC LOG: >>>> >>>> *[INFO ][2016-09-14.06:48:47]select "PART_DT", * >>>> *"LEAF_CATEG_ID", * >>>> *"LSTG_SITE_ID", * >>>> *"LSTG_FORMAT_NAME", * >>>> *"PRICE", * >>>> *"SELLER_ID" * >>>> *from "DEFAULT"."KYLIN_SALES"* >>>> *[ERROR][2016-09-14.06:49:53]The REST query request failed, the error >>>> message is: Error while executing SQL "select "PART_DT", >>>> "LEAF_CATEG_ID", "LSTG_SITE_ID", "LSTG_FORMAT_NAME", >>>> "PRICE", "SELLER_ID" from "DEFAULT"."KYLIN_SALES"": Timeout visiting >>>> cube!* >>>> >>>> This querie *from Microsoft, never finish* or kill my HBase, but from >>>> Kylin UI works fine < 0.5 sec >>>> >>>> 2016-09-14 6:49 GMT+02:00 Alberto Ramón <a.ramonporto...@gmail.com>: >>>> >>>>> Hello >>>>> I tested New Microsoft Power BI with Kylin >>>>> [image: Imágenes integradas 1] >>>>> With KYLIN_CAL_DT connector can read data: >>>>> [image: Imágenes integradas 2] >>>>> >>>>> >>>>> But with KYLIN GROUPING AND SALES: >>>>> And I have this error >>>>> >>>>> Unexpected error: *Value was either too large or too small for an >>>>> Int32.* >>>>> Details: >>>>> Microsoft.Mashup.Evaluator.Interface.ErrorException: Value was >>>>> either too large or too small for an Int32. ---> >>>>> Microsoft.Mashup.Evaluator.Interface.ErrorException: Value was either >>>>> too large or too small for an Int32. ---> >>>>> Microsoft.Mashup.Evaluator.Interface.ErrorException: Value was either >>>>> too large or too small for an Int32. ---> >>>>> Microsoft.Mashup.Evaluator.Interface.ErrorException: Value was either >>>>> too large or too small for an Int32. ---> >>>>> Microsoft.Mashup.Evaluator.Interface.ErrorException: Value was either >>>>> too large or too small for an Int32. ---> System.OverflowException: Value >>>>> was either too large or too small for an Int32. ---> >>>>> System.OverflowException: Value was either too large or too small for an >>>>> Int32. >>>>>at System.Convert.ToInt32(Int64 value) >>>>>at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataReaderExtensio >>>>> ns.GetNullableInt32(IDataReader reader, Int32 ordinal) >>>>> >>>>> >>>>> Some idea? >>>>> In true, I have also problems of connectivity using:Qlik and Sisense >>>>> Software >>>>> >>>> >>>> >>> >> > -- Regards, *Bin Mahone | 马洪宾*
Re: Kylin ODBC
The cube is the Kylin Example, the fact table have 9.800 Row, and return time to Kylin UI are 0.3 Seconds and CATEGORY_GROUPINGS has 144 rows ==> I think isnt't a performance problem *sound like , cast problem, overflow of int, or Nulls* But I don't Know the which Row / Column have a problematic Value in any log :( 2016-09-14 8:08 GMT+02:00 Abhilash L L <abhil...@infoworks.io>: > Hello Alberto, > > When the request is made via the Kylin UI, it adds an 'accept partial' > flag, which is similar to a 'limit' in sql world. > > When the query is being sent over odbc, kylin server is expected to > send all the records as the output > > Please check the thread titled 'kylin cube performance' for more > information. > > Regards, > Abhilash > > On Wed, Sep 14, 2016 at 10:48 AM, Alberto Ramón <a.ramonporto...@gmail.com > > wrote: > >> I found this >> From Kylin ODBC LOG: >> >> *[INFO ][2016-09-14.06:48:47]select "PART_DT", * >> *"LEAF_CATEG_ID", * >> *"LSTG_SITE_ID", * >> *"LSTG_FORMAT_NAME", * >> *"PRICE", * >> *"SELLER_ID" * >> *from "DEFAULT"."KYLIN_SALES"* >> *[ERROR][2016-09-14.06:49:53]The REST query request failed, the error >> message is: Error while executing SQL "select "PART_DT", >> "LEAF_CATEG_ID", "LSTG_SITE_ID", "LSTG_FORMAT_NAME", >> "PRICE", "SELLER_ID" from "DEFAULT"."KYLIN_SALES"": Timeout visiting >> cube!* >> >> This querie *from Microsoft, never finish* or kill my HBase, but from >> Kylin UI works fine < 0.5 sec >> >> 2016-09-14 6:49 GMT+02:00 Alberto Ramón <a.ramonporto...@gmail.com>: >> >>> Hello >>> I tested New Microsoft Power BI with Kylin >>> [image: Imágenes integradas 1] >>> With KYLIN_CAL_DT connector can read data: >>> [image: Imágenes integradas 2] >>> >>> >>> But with KYLIN GROUPING AND SALES: >>> And I have this error >>> >>> Unexpected error: *Value was either too large or too small for an >>> Int32.* >>> Details: >>> Microsoft.Mashup.Evaluator.Interface.ErrorException: Value was >>> either too large or too small for an Int32. ---> >>> Microsoft.Mashup.Evaluator.Interface.ErrorException: Value was either >>> too large or too small for an Int32. ---> >>> Microsoft.Mashup.Evaluator.Interface.ErrorException: >>> Value was either too large or too small for an Int32. ---> >>> Microsoft.Mashup.Evaluator.Interface.ErrorException: Value was either >>> too large or too small for an Int32. ---> >>> Microsoft.Mashup.Evaluator.Interface.ErrorException: >>> Value was either too large or too small for an Int32. ---> >>> System.OverflowException: Value was either too large or too small for an >>> Int32. ---> System.OverflowException: Value was either too large or too >>> small for an Int32. >>>at System.Convert.ToInt32(Int64 value) >>>at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataReaderExtensio >>> ns.GetNullableInt32(IDataReader reader, Int32 ordinal) >>> >>> >>> Some idea? >>> In true, I have also problems of connectivity using:Qlik and Sisense >>> Software >>> >> >> >
Re: Kylin ODBC
Hello Alberto, When the request is made via the Kylin UI, it adds an 'accept partial' flag, which is similar to a 'limit' in sql world. When the query is being sent over odbc, kylin server is expected to send all the records as the output Please check the thread titled 'kylin cube performance' for more information. Regards, Abhilash On Wed, Sep 14, 2016 at 10:48 AM, Alberto Ramón <a.ramonporto...@gmail.com> wrote: > I found this > From Kylin ODBC LOG: > > *[INFO ][2016-09-14.06:48:47]select "PART_DT", * > *"LEAF_CATEG_ID", * > *"LSTG_SITE_ID", * > *"LSTG_FORMAT_NAME", * > *"PRICE", * > *"SELLER_ID" * > *from "DEFAULT"."KYLIN_SALES"* > *[ERROR][2016-09-14.06:49:53]The REST query request failed, the error > message is: Error while executing SQL "select "PART_DT", > "LEAF_CATEG_ID", "LSTG_SITE_ID", "LSTG_FORMAT_NAME", > "PRICE", "SELLER_ID" from "DEFAULT"."KYLIN_SALES"": Timeout visiting > cube!* > > This querie *from Microsoft, never finish* or kill my HBase, but from > Kylin UI works fine < 0.5 sec > > 2016-09-14 6:49 GMT+02:00 Alberto Ramón <a.ramonporto...@gmail.com>: > >> Hello >> I tested New Microsoft Power BI with Kylin >> [image: Imágenes integradas 1] >> With KYLIN_CAL_DT connector can read data: >> [image: Imágenes integradas 2] >> >> >> But with KYLIN GROUPING AND SALES: >> And I have this error >> >> Unexpected error: *Value was either too large or too small for an Int32.* >> Details: >> Microsoft.Mashup.Evaluator.Interface.ErrorException: Value was >> either too large or too small for an Int32. ---> >> Microsoft.Mashup.Evaluator.Interface.ErrorException: Value was either >> too large or too small for an Int32. ---> >> Microsoft.Mashup.Evaluator.Interface.ErrorException: >> Value was either too large or too small for an Int32. ---> >> Microsoft.Mashup.Evaluator.Interface.ErrorException: Value was either >> too large or too small for an Int32. ---> >> Microsoft.Mashup.Evaluator.Interface.ErrorException: >> Value was either too large or too small for an Int32. ---> >> System.OverflowException: Value was either too large or too small for an >> Int32. ---> System.OverflowException: Value was either too large or too >> small for an Int32. >>at System.Convert.ToInt32(Int64 value) >>at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataReaderExtensio >> ns.GetNullableInt32(IDataReader reader, Int32 ordinal) >> >> >> Some idea? >> In true, I have also problems of connectivity using:Qlik and Sisense >> Software >> > >
Kylin ODBC
Hello I tested New Microsoft Power BI with Kylin [image: Imágenes integradas 1] With KYLIN_CAL_DT connector can read data: [image: Imágenes integradas 2] But with KYLIN GROUPING AND SALES: And I have this error Unexpected error: *Value was either too large or too small for an Int32.* Details: Microsoft.Mashup.Evaluator.Interface.ErrorException: Value was either too large or too small for an Int32. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Value was either too large or too small for an Int32. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Value was either too large or too small for an Int32. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Value was either too large or too small for an Int32. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Value was either too large or too small for an Int32. ---> System.OverflowException: Value was either too large or too small for an Int32. ---> System.OverflowException: Value was either too large or too small for an Int32. at System.Convert.ToInt32(Int64 value) at Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataReaderExtensions.GetNullableInt32(IDataReader reader, Int32 ordinal) Some idea? In true, I have also problems of connectivity using:Qlik and Sisense Software