Fwd: Kylin cube partitioning strategy

[Norbert Burger <no...@gmail.com>]

Hi folks,

* Does Kylin support an hourly partitioning strategy (yyyy-MM-dd-hh)?  One
of our incoming datasets with which I want to create a cube is partitioned
at the hourly level.  If not, how do folks handle this grain difference?

* SQL Workbench seems not to play well with the Kylin JDBC driver (every
query throws an NPE at workbench.sql.SqlCommand.processResults).  Has
anyone had luck with this setup?

Norbert

Re: Kylin cube partitioning strategy

[Li Yang <li...@apache.org>]

> Does Kylin support an hourly partitioning strategy (yyyy-MM-dd-hh)?  One
of our incoming datasets with which I want to create a cube is partitioned
at the hourly level.  If not, how do folks handle this grain difference?

The "date format" of the partition date column can be set to include the
hour. The "date format" may not be editable in the GUI depending on the
Kylin version you are using. What's your version?

> SQL Workbench seems not to play well with the Kylin JDBC driver (every
query throws an NPE at workbench.sql.SqlCommand.processResults).  Has
anyone had luck with this setup?

This deserves a JIRA. https://issues.apache.org/jira/browse/KYLIN-1494

On Tue, Mar 15, 2016 at 5:12 AM, Norbert Burger <no...@gmail.com>
wrote:

> Hi folks,
>
> * Does Kylin support an hourly partitioning strategy (yyyy-MM-dd-hh)?  One
> of our incoming datasets with which I want to create a cube is partitioned
> at the hourly level.  If not, how do folks handle this grain difference?
>
> * SQL Workbench seems not to play well with the Kylin JDBC driver (every
> query throws an NPE at workbench.sql.SqlCommand.processResults).  Has
> anyone had luck with this setup?
>
> Norbert
>
>