[jira] [Created] (KYLIN-3256) Filter of dates do not work
Jean-Luc BELLIER created KYLIN-3256: --- Summary: Filter of dates do not work Key: KYLIN-3256 URL: https://issues.apache.org/jira/browse/KYLIN-3256 Project: Kylin Issue Type: Bug Affects Versions: v2.2.0 Reporter: Jean-Luc BELLIER Hello, I am wondering how to filter date columns with Kylin. I am working with the sample cube of the learn_kylin project. I have slightly modified the cube to add a few more columns, but that is all. In the advanced section, I put KYLIN_SALES.PART_DT in the 'Rowkeys' section, defined as 'date' type. I would like to add a filter like 'WHERE KYLIN_SALES.DT_PART = '2012-06-24' but the Kylin interface gives me a mistake : 'error while compiling generated Java code' This works fine with hive console. I also tried with TO_DATE('2012-06-24'). Using "WHERE KYLIN_SALES.DT_PART BETWEEN '2012-06-24' AND '2012-06-25'", it works fine. Are there limitations or internal transformations on the 'date' type in Kylin ? Thank you for your help. Have a good day. Best regards; Jean-Luc. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (KYLIN-3255) Cannot save cube
Jean-Luc BELLIER created KYLIN-3255: --- Summary: Cannot save cube Key: KYLIN-3255 URL: https://issues.apache.org/jira/browse/KYLIN-3255 Project: Kylin Issue Type: Bug Components: Web Affects Versions: v2.2.0 Reporter: Jean-Luc BELLIER Hello, I am trying to create a cube from myself, based on kylin_sales_cubes, and I face a major problem that a really do not Understand. I get the message "Unknown dimension encoding name 'dict' (note ('dict' is not handled by factory). I checked the JSON file compared to the original JSON file for kylin_sales_cube for 'dict" type and I do not see what is wrong. I have also not found what is incorrect in kylin.log file. I send both files in attachment. Thank you in advance for your help. Have a good day. Best regards. Jean-Luc.[^kylin.log] -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (KYLIN-3254) Cannot use Kylin Cubes with Excel
Jean-Luc BELLIER created KYLIN-3254: --- Summary: Cannot use Kylin Cubes with Excel Key: KYLIN-3254 URL: https://issues.apache.org/jira/browse/KYLIN-3254 Project: Kylin Issue Type: Bug Components: Driver - ODBC Affects Versions: v2.2.0 Reporter: Jean-Luc BELLIER Hello I downloaded the ODBC driver to use Kylin with Excel. My OS is Windows 8.1 64-bits I first clicked on the KylinODBCDriver (x64).exe, but it says that the program could not be executed on my PC. So i ran the 32-bit version. I succeeded in configuring the Kylin ODBC connection. Now I would like to use my Kylin cubes with Excel. So I downloaded PowerBI as mentioned on Kylin site, but the installation program tells me that my version of Excel was not compatible, because the driver requires Excel2010 SP1 or Excel 2013. My version of Excel is 2013 Professional version. Are there any limitations ? How can I visualize my Kylin cubes with Excel in my case ? Thank you in advance for your help. Best regards, Jean-Luc. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (KYLIN-3218) KYLIN interface :cannot load models
Jean-Luc BELLIER created KYLIN-3218: --- Summary: KYLIN interface :cannot load models Key: KYLIN-3218 URL: https://issues.apache.org/jira/browse/KYLIN-3218 Project: Kylin Issue Type: Bug Components: Client - CLI Affects Versions: v2.2.0 Reporter: Jean-Luc BELLIER Assignee: hongbin ma Attachments: kylin.log, kylin.log, kylin.out, kylin.out Hello, I am trying to use the tutorial example 'sample_cube' on KYLIN interface. I installed the configuration without error. I launched the script sample.sh' then the command 'kylin.sh start' from the bin directory. I can see the tables in Hive and the files in HDFS. Unfortunately, when I select the project 'learn_kylin' in the list, the models cannot be refreshed. I tried to refresh the metadata from the 'System' tab without problem. But the 'server config' and 'Sever environment are still blank. When I click on 'reload config' button, I get the message : 'Oops ! Failed to take action'. There may be something wrong in my config, but I cannot see what. I send in attachment my 'kylin.log' and 'kylin.output' files. Thank you in advance for your help. Have a good day. Best regards, Jean-Luc.[^kylin.log] -- This message was sent by Atlassian JIRA (v7.6.3#76005)