kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alberto Ramón <a.ramonporto...@gmail.com>
Subject Re: Kylin ODBC
Date Wed, 14 Sep 2016 05:18:01 GMT
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.ramonportoles@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.OdbcDataReaderExtensions.GetNullableInt32(IDataReader
> reader, Int32 ordinal)
>
>
> Some idea?
> In true, I have also problems of connectivity using:Qlik and Sisense
> Software
>

Mime
View raw message