> q1: When building cube, run mapred task, how can i specify a user, and assign cluster resources? What I need to modify the configuration files?
Kylin use the same user who runs Kylin to launch MR jobs. You can modify conf/kylin_job_conf.xml to adjust any job parameters. > q2: Query support fuzzy queries just like this "where col like 'ABC%'" Yes > q3: I have a string column,value like this "2016-02-01 21:56:08", how to get date value '2016-02-01', I've tried substr(requestdate,1,10) is not supported,or I need to modify the column type to date? If the analysis only cares about date, it's highly recommended that the datetime is truncated to date before OLAP. The substring() syntax in Kylin is slightly different, see https://calcite.apache.org/docs/reference.html > q4: All fields can query, except Partition field,Whether does not support partition field queries? Don't understand. You can query partition column, that's for sure. Any example of something cannot query? On Thu, Mar 31, 2016 at 10:43 AM, [email protected] <[email protected] > wrote: > > Hi, > i have some questions when using kylin, > q1: > when building cube, run mapred task, how can i specify a user, and assign > cluster resources? What I need to modify the configuration files? > q2: > Query support fuzzy queries just like this "where col like 'ABC%'" > q3: > I have a string column,value like this "2016-02-01 21:56:08", how to get > date value '2016-02-01', I've tried substr(requestdate,1,10) is not > supported,or I need to modify the column type to date? > q4: > All fields can query, except Partition field,Whether does not support > partition field queries? >
