yes, this is de idea 1º Sisense recognize the ODBC: yes
2º By defatul uses queries like this: select * from [default].[KYLIN_CAL_DT] this retieve a error in Kylin Web UI (you can copy and paste to check) And now, try with this: "select * from KYLIN_CAL_DT", will work in Kylin UI But other combinations Won't work: select * from [default].[KYLIN_CAL_DT] select * from [KYLIN_CAL_DT] select * from default.KYLIN_CAL_DT BR 2016-09-05 3:24 GMT+02:00 hongbin ma <[email protected]>: > is sisense using ODBC to connect with Kylin? > will the query work in kylin's web GUI? > > On Mon, Sep 5, 2016 at 12:45 AM, Alberto Ramón <[email protected]> > wrote: > >> Hello >> >> I'm testing Sisense Software <https://www.sisense.com/>, and saw similar >> integration-problem like with other vendors with "get Metadata" >> >> This don't work: (Picture optional) >> [image: Imágenes integradas 1] >> >> >> select * from KYLIN_CAL_DT ==> OK >> select * from [KYLIN_CAL_DT] ==> Error: Encountered "[" at line 1, >> column 15. Was expecting one of >> select * from learn_kylin.KYLIN_CAL_DT ==> Error: >> select * from default.KYLIN_CAL_DT ==> Error >> >> >> Also this >> <http://mail-archives.apache.org/mod_mbox/kylin-dev/201608.mbox/%3CCAEcyM16z2fURyB-VWXXG8dxkX9THAE55meS_%2B3FA%3DMxoc-5a6g%40mail.gmail.com%3E>, >> can be interesting >> >> BR, Alberto >> >> >> >> >> >> > > > -- > Regards, > > *Bin Mahone | 马洪宾* >
