hi,

when we search with same sql, different results are returned as below.
25 in kylin and 24 in hive.

We guess there maybe some problem within #2 Step(Extract Fact Table Distinct
Columns) when building cube.





1 search in kylin 
 select distinct visit_hour from
KYLIN_REPORT_DB.session_behavior_channel_oms where  visit_date >=
'2016-10-19' and visit_date <= '2016-10-19' 
 Results (25)
19
17
18
15
16
13
14
11
12
21
神马搜索
20
08
09
04
22
05
23
06
07
00
01
02
03
10

2. #2 Step Name: Extract Fact Table Distinct Columns output

hadoop fs -cat
/kylin/kylin_metadata/kylin-e8bb517d-6c29-4f89-a83e-871e142e3d48/channel_first_stage_flow_cube/fact_distinct_columns/VISIT_HOUR
00
01
02
03
04
05
06
07
08
09
10
11
12
13
14
15
16
17
18
19
20
21
22
23
神马搜索


3. hive table 

hive -e " select distinct visit_hour from
KYLIN_REPORT_DB.session_behavior_channel_oms where  visit_date >=
'2016-10-19' and visit_date <= '2016-10-19' "
WARNING: Use "yarn jar" to launch YARN applications.

Logging initialized using configuration in
file:/etc/hive/2.3.4.0-3485/0/hive-log4j.properties
Query ID = hdfs_20161020164441_dcea3e55-1a8b-4f3a-9378-7dcda008001b
Total jobs = 1
Launching Job 1 out of 1


Status: Running (Executing on YARN cluster with App id
application_1476342479107_13013)

--------------------------------------------------------------------------------
        VERTICES      STATUS  TOTAL  COMPLETED  RUNNING  PENDING  FAILED 
KILLED
--------------------------------------------------------------------------------
Map 1 ..........   SUCCEEDED    564        564        0        0       0      
0
Reducer 2 ......   SUCCEEDED     15         15        0        0       0      
0
--------------------------------------------------------------------------------
VERTICES: 02/02  [==========================>>] 100%  ELAPSED TIME: 168.70 s   
--------------------------------------------------------------------------------
OK
03
12
13
22
05
14
08
17
00
02
18
06
23
01
19
07
10
15
20
16
11
04
09
21
Time taken: 172.907 seconds, Fetched: 24 row(s)

--
View this message in context: 
http://apache-kylin.74782.x6.nabble.com/2-Step-Name-Extract-Fact-Table-Distinct-Columns-output-error-tp6044.html
Sent from the Apache Kylin mailing list archive at Nabble.com.

Reply via email to