2. If I ignore and continue and try to save the cube I get an exception in
Kylin.log , I have checked the path is set correctly and HCatInputFormat this
file is present in hive-hcatalog-core-0.14.0.jar . Please let me know what can
I do to resolve this ?
-- This was path issue , now no more exception in kylin.log
But saveing cube still fails with error. And still can't add measures.
Error Message
Failed to take action.
In log I can find no exception. Following is the last log in kylin.log
[pool-3-thread-1]:[2015-02-24
20:47:15,613][INFO][org.apache.kylin.job.impl.threadpool.DefaultScheduler$FetcherRunner.run(DefaultScheduler.java:117)]
- Job Fetcher: 0 running, 0 actual running, 0 ready, 6 others
[http-bio-7070-exec-2]:[2015-02-24
20:47:51,610][DEBUG][org.apache.kylin.rest.controller.CubeController.deserializeDataModelDesc(CubeController.java:459)]
- Saving cube {
"name": "",
"fact_table": "RETAIL.FACT_SALES",
"lookups": [],
"filter_condition": "",
"capacity": "SMALL",
"partition_desc": {
"partition_date_column": "",
"partition_date_start": 0,
"partition_type": "APPEND"
},
"last_modified": 0
}
local access logs all with 200 , so seems ok.
10.18.146.105 - - [24/Feb/2015:20:46:56 +0800] "GET
/kylin/api/user/authentication HTTP/1.1" 200 246
10.18.146.105 - - [24/Feb/2015:20:47:07 +0800] "GET
/kylin/api/user/authentication HTTP/1.1" 200 246
10.18.146.105 - - [24/Feb/2015:20:47:27 +0800] "GET
/kylin/api/user/authentication HTTP/1.1" 200 246
10.18.146.105 - - [24/Feb/2015:20:47:28 +0800] "GET
/kylin/api/user/authentication HTTP/1.1" 200 246
10.18.146.105 - - [24/Feb/2015:20:47:34 +0800] "GET
/kylin/api/user/authentication HTTP/1.1" 200 246
10.18.146.105 - - [24/Feb/2015:20:47:48 +0800] "GET
/kylin/api/user/authentication HTTP/1.1" 200 246
10.18.146.105 - - [24/Feb/2015:20:47:51 +0800] "POST /kylin/api/cubes HTTP/1.1"
200 701
Regards,
Santosh Akhilesh
Bangalore R&D
HUAWEI TECHNOLOGIES CO.,LTD.
www.huawei.com
-------------------------------------------------------------------------------------------------------------------------------------
This e-mail and its attachments contain confidential information from HUAWEI,
which
is intended only for the person or entity whose address is listed above. Any
use of the
information contained herein in any way (including, but not limited to, total
or partial
disclosure, reproduction, or dissemination) by persons other than the intended
recipient(s) is prohibited. If you receive this e-mail in error, please notify
the sender by
phone or email immediately and delete it!
________________________________________
From: Santoshakhilesh [[email protected]]
Sent: Tuesday, February 24, 2015 12:09 PM
To: [email protected]
Cc: Kulbhushan Rana
Subject: Error while making cube & Measure option is not responding on GUI
Hi All ,
I am building a simple cube for test and using the binary build 0.7.1 . I
have following hive tables with columns.
fact_sales:
storeid int
itemid int
custid int
qty int
price double
dim_customer
custid int
name string
dim_item
itemid int
category string
brand string
color string
dim_store
storeid int
city string
state string
Please help me to answer following issues;
1. When I go to measure section and click on measure option , there is no
response , I want add measure on qty and price with sum
2. If I ignore and continue and try to save the cube I get an exception in
Kylin.log , I have checked the path is set correctly and HCatInputFormat this
file is present in hive-hcatalog-core-0.14.0.jar . Please let me know what can
I do to resolve this ?
3. Also I have another question since this is a test and data is small I have
not partitioned the fact table , is it ok to skip partition stage while cube
build ?
Exception
pool-4-thread-4]:[2015-02-24
19:26:32,577][ERROR][org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:134)]
- ExecuteException job:c3532a6f-97ea-474a-b36a-218dd517cedb
org.apache.kylin.job.exception.ExecuteException:
org.apache.kylin.job.exception.ExecuteException:
java.lang.NoClassDefFoundError:
org/apache/hive/hcatalog/mapreduce/HCatInputFormat
at
org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:102)
at
org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:132)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.kylin.job.exception.ExecuteException:
java.lang.NoClassDefFoundError:
org/apache/hive/hcatalog/mapreduce/HCatInputFormat
The JSON is as below.
{
"name": "Retail_Cube",
"description": "",
"dimensions": [
{
"name": "RETAIL.FACT_SALES.STOREID",
"table": "RETAIL.FACT_SALES",
"hierarchy": false,
"derived": null,
"column": [
"STOREID"
],
"id": 1
},
{
"name": "RETAIL.FACT_SALES.ITEMID",
"table": "RETAIL.FACT_SALES",
"hierarchy": false,
"derived": null,
"column": [
"ITEMID"
],
"id": 2
},
{
"name": "RETAIL.FACT_SALES.CUSTID",
"table": "RETAIL.FACT_SALES",
"hierarchy": false,
"derived": null,
"column": [
"CUSTID"
],
"id": 3
}
],
"measures": [
{
"id": 1,
"name": "_COUNT_",
"function": {
"expression": "COUNT",
"returntype": "bigint",
"parameter": {
"type": "constant",
"value": 1
}
}
}
],
"rowkey": {
"rowkey_columns": [
{
"column": "STOREID",
"length": 0,
"dictionary": "true",
"mandatory": false
},
{
"column": "ITEMID",
"length": 0,
"dictionary": "true",
"mandatory": false
},
{
"column": "CUSTID",
"length": 0,
"dictionary": "true",
"mandatory": false
}
],
"aggregation_groups": [
[
"STOREID",
"ITEMID",
"CUSTID"
]
]
},
"notify_list": [],
"capacity": "",
"hbase_mapping": {
"column_family": [
{
"name": "f1",
"columns": [
{
"qualifier": "m",
"measure_refs": [
"_COUNT_"
]
}
]
}
]
},
"project": "RetailProject",
"model_name": "Retail_Cube"
}
Regards,
Santosh Akhilesh
Bangalore R&D
HUAWEI TECHNOLOGIES CO.,LTD.
www.huawei.com
-------------------------------------------------------------------------------------------------------------------------------------
This e-mail and its attachments contain confidential information from HUAWEI,
which
is intended only for the person or entity whose address is listed above. Any
use of the
information contained herein in any way (including, but not limited to, total
or partial
disclosure, reproduction, or dissemination) by persons other than the intended
recipient(s) is prohibited. If you receive this e-mail in error, please notify
the sender by
phone or email immediately and delete it!
