You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by wangfeng <wa...@gmail.com> on 2016/07/07 08:07:12 UTC
How to create a model and a cube only with one table
我目前只有一张表,表结构如下:
CREATE EXTERNAL TABLE IF NOT EXISTS jsl_log
(
start_time date,
mandate string,
req_time string,
attack_type string,
ban_type string,
client_ip string,
x_forwarded_for string,
via string,
host string,
req_uri string,
req_method string,
referer string,
hit_status string,
server_type string,
resp_code string,
send_size bigint,
clocation string,
user_agent string,
lang_charset string,
ua_cpu string,
cookie string,
post string
)
其中没有设置key,请问我应该如何一步一步构建一个model
和cube,我学习了维度和度量,了解它们的含义,我也学习了sample里面的设置,但是就一张表而言,我这里就行不通了,一直出错,报错后我运行了sample的那cube,build成功了,说明不是环境的问题,而是配置model
和cube的问题。还请大家给我帮助,谢谢大家,最好能详细说明下每一步怎么选;
ps 这表里面我想度量的大家可以自己根据举例来设定,我到时候参照修改即可。跪谢大家。
--
View this message in context: http://apache-kylin.74782.x6.nabble.com/How-to-create-a-model-and-a-cube-only-with-one-table-tp5239.html
Sent from the Apache Kylin mailing list archive at Nabble.com.
Re: How to create a model and a cube only with one table
Posted by Yiming Liu <li...@gmail.com>.
You'd better tell send out your design and the error you met with detail
logs.
在 2016年7月7日 下午4:07,wangfeng <wa...@gmail.com>写道:
> 我目前只有一张表,表结构如下:
> CREATE EXTERNAL TABLE IF NOT EXISTS jsl_log
> (
> start_time date,
> mandate string,
> req_time string,
> attack_type string,
> ban_type string,
> client_ip string,
> x_forwarded_for string,
> via string,
> host string,
> req_uri string,
> req_method string,
> referer string,
> hit_status string,
> server_type string,
> resp_code string,
> send_size bigint,
> clocation string,
> user_agent string,
> lang_charset string,
> ua_cpu string,
> cookie string,
> post string
> )
>
> 其中没有设置key,请问我应该如何一步一步构建一个model
>
> 和cube,我学习了维度和度量,了解它们的含义,我也学习了sample里面的设置,但是就一张表而言,我这里就行不通了,一直出错,报错后我运行了sample的那cube,build成功了,说明不是环境的问题,而是配置model
> 和cube的问题。还请大家给我帮助,谢谢大家,最好能详细说明下每一步怎么选;
>
> ps 这表里面我想度量的大家可以自己根据举例来设定,我到时候参照修改即可。跪谢大家。
>
> --
> View this message in context:
> http://apache-kylin.74782.x6.nabble.com/How-to-create-a-model-and-a-cube-only-with-one-table-tp5239.html
> Sent from the Apache Kylin mailing list archive at Nabble.com.
>
--
With Warm regards
Yiming Liu (刘一鸣)