Re: Why does the log always say “No Data Available” when the cube is built?

2019-04-28 Thread yuzhang
Hi shiqi:
"No Data available" mean the step of the job hasn't been completed. There 
will be some log message if the step has been completed, whether successful or 
not.


For you problem, could you provide more detail about you build job? Such 
as, log on server, which step is running, your deploy environment, etc will be 
helpful.




Best regards


yuzhang


| |
yuzhang
|
|
shifengdefan...@163.com
|
签名由网易邮箱大师定制
On 4/28/2019 21:05,shiqi wrote:
In the sample case on the Kylin official website, when I was building cube,
in the first step of the Create Intermediate Flat Hive Table, the log is
always No Data Available, the status is always running.

The cube build has been executed for more than three hours.

I checked the hive database table kylin_sales and there is data in the
table.

And I fount that the intermediate flat hive table
kylin_intermediate_kylin_sales_cube_402e3eaa_dfb2_7e3e_04f3_07248c04c10c
has been created successfully in the hive, but there is no data in its.

```
hive> show tables;
OK
...
kylin_intermediate_kylin_sales_cube_402e3eaa_dfb2_7e3e_04f3_07248c04c10c
kylin_sales
...
Time taken: 9.816 seconds, Fetched: 1 row(s)

hive> select * from kylin_sales;
OK
...
89922012-04-17  ABIN15687   0   13  95.5336 17  19751507   
ADMIN   Shanghai
89932013-02-02  FP-non GTC  67698   0   13  85.7528 6   1856   
10004882MODELER Hongkong
...
Time taken: 3.759 seconds, Fetched: 1 row(s)
```

--
Sent from: http://apache-kylin.74782.x6.nabble.com/


Why does the log always say “No Data Available” when the cube is built?

2019-04-28 Thread shiqi
In the sample case on the Kylin official website, when I was building cube,
in the first step of the Create Intermediate Flat Hive Table, the log is
always No Data Available, the status is always running.

The cube build has been executed for more than three hours.

I checked the hive database table kylin_sales and there is data in the
table.

And I fount that the intermediate flat hive table
kylin_intermediate_kylin_sales_cube_402e3eaa_dfb2_7e3e_04f3_07248c04c10c
has been created successfully in the hive, but there is no data in its.

```
hive> show tables;
OK
...
kylin_intermediate_kylin_sales_cube_402e3eaa_dfb2_7e3e_04f3_07248c04c10c
kylin_sales
...
Time taken: 9.816 seconds, Fetched: 1 row(s)

hive> select * from kylin_sales;
OK
...
89922012-04-17  ABIN15687   0   13  95.5336 17  19751507   
ADMIN   Shanghai
89932013-02-02  FP-non GTC  67698   0   13  85.7528 6   1856   
10004882MODELER Hongkong
...
Time taken: 3.759 seconds, Fetched: 1 row(s)
```

--
Sent from: http://apache-kylin.74782.x6.nabble.com/