[jira] [Updated] (KYLIN-2025) web UI can't build cube Measures,the web console 404 not found the cube add

[Kris (JIRA)]

 [ 
https://issues.apache.org/jira/browse/KYLIN-2025?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Kris updated KYLIN-2025:

Attachment: 截图 2016-09-18 23时26分37秒.jpg
 2016-09-18 23时23分27秒.jpg

Dear Jason:
I use hbase's version 1.2.2 and hive-1.2.1,and use 
apache-kylin-1.5.4-HBase1.x-bin.tar.gz version ,I dwon load the last version 
today but also like this










> web UI can't build cube Measures,the web console 404 not found the cube add
> ---
>
> Key: KYLIN-2025
> URL: https://issues.apache.org/jira/browse/KYLIN-2025
> Project: Kylin
>  Issue Type: Bug
>Affects Versions: v1.5.4
>Reporter: Kris
>  Labels: build
> Attachments:  2016-09-18 23时23分27秒.jpg, 截图 2016-09-18 23时26分37秒.jpg
>
>
> 1.5.4 when build cube the step3 ,can't click the list of all,console print 
> 404 not found the cube add



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (KYLIN-2025) web UI can't build cube Measures,the web console 404 not found the cube add

[Zhong,Jason (JIRA)]

[ 
https://issues.apache.org/jira/browse/KYLIN-2025?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15502165#comment-15502165
 ] 

Zhong,Jason commented on KYLIN-2025:


Are you using Hbase version or CDH version?

Suggest you download latest binary package from kylin download page and try 
again.

http://kylin.apache.org/download/


> web UI can't build cube Measures,the web console 404 not found the cube add
> ---
>
> Key: KYLIN-2025
> URL: https://issues.apache.org/jira/browse/KYLIN-2025
> Project: Kylin
>  Issue Type: Bug
>Affects Versions: v1.5.4
>Reporter: Kris
>  Labels: build
>
> 1.5.4 when build cube the step3 ,can't click the list of all,console print 
> 404 not found the cube add



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (KYLIN-2027) Error "connection timed out" occurs when zookeeper's port is set in hbase.zookeeper.quorum of hbase-site.xml

[Billy(Yiming) Liu (JIRA)]

[ 
https://issues.apache.org/jira/browse/KYLIN-2027?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15502086#comment-15502086
 ] 

Billy(Yiming) Liu commented on KYLIN-2027:
--

This is not a bug. According to hbase doc: 
http://hbase.apache.org/0.94/book/zookeeper.html


  hbase.zookeeper.property.clientPort
  
  Property from ZooKeeper's config zoo.cfg.
  The port at which the clients will connect.
  


  hbase.zookeeper.quorum
  
rs1.example.com,rs2.example.com,rs3.example.com,rs4.example.com,rs5.example.com
  Comma separated list of servers in the ZooKeeper Quorum.
  For example, "host1.mydomain.com,host2.mydomain.com,host3.mydomain.com".
  By default this is set to localhost for local and pseudo-distributed modes
  of operation. For a fully-distributed setup, this should be set to a full
  list of ZooKeeper quorum servers. If HBASE_MANAGES_ZK is set in 
hbase-env.sh
  this is the list of servers which we will start/stop ZooKeeper on.
  


port should be set in 'hbase.zookeeper.property.clientPort', not 
'hbase.zookeeper.quorum'

> Error "connection timed out" occurs when zookeeper's port is set in 
> hbase.zookeeper.quorum of hbase-site.xml
> 
>
> Key: KYLIN-2027
> URL: https://issues.apache.org/jira/browse/KYLIN-2027
> Project: Kylin
>  Issue Type: Bug
>  Components: Storage - HBase
>Affects Versions: v1.5.4
>Reporter: nichunen
>Assignee: nichunen
>Priority: Minor
>  Labels: patch
> Fix For: v1.6.0
>
> Attachments: KYLIN-2027.patch
>
>
> In our hadoop cluster, we specified ports of zk servers in 
> hbase.zookeeper.quorum of hbase-site.xml like 
>   
> hbase.zookeeper.quorum
> hadoop1:2181,hadoop2:2181,hadoop3:2181
>   
> And we get the error "ERROR [Thread-12] curator.ConnectionState:201 : 
> Connection timed out for connection string 
> (hadoop1:2181:2181,hadoop2:2181:2181,hadoop3:2181:2181) and timeout (15000) / 
> elapsed (15214)"
> I think 
> org.apache.kylin.storage.hbase.util.ZookeeperJobLock#getZKConnectString 
> should check whether it ends with a port before adding a port to the string.
> Attached is the patch.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (KYLIN-2027) Error "connection timed out" occurs when zookeeper's port is set in hbase.zookeeper.quorum of hbase-site.xml

[nichunen (JIRA)]

 [ 
https://issues.apache.org/jira/browse/KYLIN-2027?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

nichunen updated KYLIN-2027:

Attachment: KYLIN-2027.patch

> Error "connection timed out" occurs when zookeeper's port is set in 
> hbase.zookeeper.quorum of hbase-site.xml
> 
>
> Key: KYLIN-2027
> URL: https://issues.apache.org/jira/browse/KYLIN-2027
> Project: Kylin
>  Issue Type: Bug
>  Components: Storage - HBase
>Affects Versions: v1.5.4
>Reporter: nichunen
>Assignee: nichunen
>Priority: Minor
>  Labels: patch
> Fix For: v1.6.0
>
> Attachments: KYLIN-2027.patch
>
>
> In our hadoop cluster, we specified ports of zk servers in 
> hbase.zookeeper.quorum of hbase-site.xml like 
>   
> hbase.zookeeper.quorum
> hadoop1:2181,hadoop2:2181,hadoop3:2181
>   
> And we get the error "ERROR [Thread-12] curator.ConnectionState:201 : 
> Connection timed out for connection string 
> (hadoop1:2181:2181,hadoop2:2181:2181,hadoop3:2181:2181) and timeout (15000) / 
> elapsed (15214)"
> I think 
> org.apache.kylin.storage.hbase.util.ZookeeperJobLock#getZKConnectString 
> should check whether it ends with a port before adding a port to the string.
> Attached is the patch.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (KYLIN-1698) Allow bigint(long) as a partition date column

[liyang (JIRA)]

[ 
https://issues.apache.org/jira/browse/KYLIN-1698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15501933#comment-15501933
 ] 

liyang commented on KYLIN-1698:
---

The backend changes are

commit 111e984f9c3a47a8a90cc622ef368cf68b0f84fe
Author: Li Yang 
Date:   Fri Sep 2 16:11:14 2016 +0800

KYLIN-1698 fix UT

commit a20d709d27da9060d63ccb1c14902235a3aedec2
Author: Li Yang 
Date:   Fri Sep 2 15:49:34 2016 +0800

KYLIN-1698 backend done, pending GUI


> Allow bigint(long) as a partition date column
> -
>
> Key: KYLIN-1698
> URL: https://issues.apache.org/jira/browse/KYLIN-1698
> Project: Kylin
>  Issue Type: Improvement
>Affects Versions: v1.5.1
>Reporter: Guohui LI
>Assignee: liyang
> Fix For: v1.6.0
>
> Attachments: 0001-KYLIN-1698-BIGINT.patch, 0001-KYLIN-1698-INT.patch
>
>
> In many cases, hive tables may use long / bigint as date column. Currently 
> Kylin only support '-MM-dd' or 'MMdd' as date format. This jira is to 
> support long / bigint format.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Created] (KYLIN-2027) Error "connection timed out" occurs when zookeeper's port is set in hbase.zookeeper.quorum of hbase-site.xml

[nichunen (JIRA)]

nichunen created KYLIN-2027:
---

 Summary: Error "connection timed out" occurs when zookeeper's port 
is set in hbase.zookeeper.quorum of hbase-site.xml
 Key: KYLIN-2027
 URL: https://issues.apache.org/jira/browse/KYLIN-2027
 Project: Kylin
  Issue Type: Bug
  Components: Storage - HBase
Affects Versions: v1.5.4
Reporter: nichunen
Assignee: liyang
Priority: Minor
 Fix For: v1.6.0






--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (KYLIN-2026) NPE occurs when build a cube without partition column.

[nichunen (JIRA)]

 [ 
https://issues.apache.org/jira/browse/KYLIN-2026?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

nichunen updated KYLIN-2026:

Attachment: KYLIN-2026.patch

> NPE occurs when build a cube without partition column.
> --
>
> Key: KYLIN-2026
> URL: https://issues.apache.org/jira/browse/KYLIN-2026
> Project: Kylin
>  Issue Type: Bug
>  Components: General
>Affects Versions: v1.5.4
>Reporter: nichunen
>Assignee: nichunen
>  Labels: patch
> Fix For: v1.5.4
>
> Attachments: KYLIN-2026.patch
>
>
> I created a model with no partition column specified, step "Extract Fact 
> Table Distinct Columns" failed with MR log 
> "org.apache.hadoop.mapred.YarnChild: Exception running child : 
> java.lang.NullPointerException at 
> org.apache.kylin.cube.model.CubeJoinedFlatTableDesc.getColumnIndex(CubeJoinedFlatTableDesc.java:145)".
> I doubt the root cause is in 
> org.apache.kylin.cube.CubeManager#getAllDictColumnsOnFact, a null value is 
> added to the return list due to 
> cubeDesc.getModel().getPartitionDesc().getPartitionDateColumnRef() gets null.
> Attached is the patch to fix, only add a null check.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (KYLIN-2026) NPE occurs when build a cube without partition column.

[nichunen (JIRA)]

 [ 
https://issues.apache.org/jira/browse/KYLIN-2026?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

nichunen updated KYLIN-2026:

Description: 
I created a model with no partition column specified, step "Extract Fact Table 
Distinct Columns" failed with MR log "org.apache.hadoop.mapred.YarnChild: 
Exception running child : java.lang.NullPointerException at 
org.apache.kylin.cube.model.CubeJoinedFlatTableDesc.getColumnIndex(CubeJoinedFlatTableDesc.java:145)".

I doubt the root cause is in 
org.apache.kylin.cube.CubeManager#getAllDictColumnsOnFact, a null value is 
added to the return list due to 
cubeDesc.getModel().getPartitionDesc().getPartitionDateColumnRef() gets null.

Attached is the patch to fix, only add a null check.

> NPE occurs when build a cube without partition column.
> --
>
> Key: KYLIN-2026
> URL: https://issues.apache.org/jira/browse/KYLIN-2026
> Project: Kylin
>  Issue Type: Bug
>  Components: General
>Affects Versions: v1.5.4
>Reporter: nichunen
>Assignee: nichunen
>  Labels: patch
> Fix For: v1.5.4
>
>
> I created a model with no partition column specified, step "Extract Fact 
> Table Distinct Columns" failed with MR log 
> "org.apache.hadoop.mapred.YarnChild: Exception running child : 
> java.lang.NullPointerException at 
> org.apache.kylin.cube.model.CubeJoinedFlatTableDesc.getColumnIndex(CubeJoinedFlatTableDesc.java:145)".
> I doubt the root cause is in 
> org.apache.kylin.cube.CubeManager#getAllDictColumnsOnFact, a null value is 
> added to the return list due to 
> cubeDesc.getModel().getPartitionDesc().getPartitionDateColumnRef() gets null.
> Attached is the patch to fix, only add a null check.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Created] (KYLIN-2026) NPE occurs when build a cube without partition column.

[nichunen (JIRA)]

nichunen created KYLIN-2026:
---

 Summary: NPE occurs when build a cube without partition column.
 Key: KYLIN-2026
 URL: https://issues.apache.org/jira/browse/KYLIN-2026
 Project: Kylin
  Issue Type: Bug
  Components: General
Affects Versions: v1.5.4
Reporter: nichunen
Assignee: nichunen
 Fix For: v1.5.4






--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (KYLIN-1902) 404 error on get /kylin/models

[Shaofeng SHI (JIRA)]

[ 
https://issues.apache.org/jira/browse/KYLIN-1902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15501038#comment-15501038
 ] 

Shaofeng SHI commented on KYLIN-1902:
-

Please re-download the binary package (there was a js/html error in the first 
build, now we uploaded a new one).

> 404 error on get /kylin/models
> --
>
> Key: KYLIN-1902
> URL: https://issues.apache.org/jira/browse/KYLIN-1902
> Project: Kylin
>  Issue Type: Bug
>  Components: Web 
>Affects Versions: v1.5.2
>Reporter: Shaofeng SHI
>Assignee: Zhong,Jason
>
> Request URL:http://localhost:7070/kylin/models
> Request Method:GET
> Status Code:404 Not Found
> Remote Address:[::1]:7070
> I think this issue has existed for some time; Although it doesn't impact on 
> user experience, an 404 error in web console is confusing. @Jason Can we fix 
> it in v1.5.3?



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Created] (KYLIN-2025) web UI can't build cube Measures,the web console 404 not found the cube add

[Kris (JIRA)]

Kris created KYLIN-2025:
---

 Summary: web UI can't build cube Measures,the web console 404 not 
found the cube add
 Key: KYLIN-2025
 URL: https://issues.apache.org/jira/browse/KYLIN-2025
 Project: Kylin
  Issue Type: Bug
Affects Versions: v1.5.4
Reporter: Kris


1.5.4 when build cube the step3 ,can't click the list of all,console print 404 
not found the cube add



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (KYLIN-1902) 404 error on get /kylin/models

[Kris (JIRA)]

[ 
https://issues.apache.org/jira/browse/KYLIN-1902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15500867#comment-15500867
 ] 

Kris commented on KYLIN-1902:
-

kylin 1.5.4 also has this bug ,it can't build messure value

> 404 error on get /kylin/models
> --
>
> Key: KYLIN-1902
> URL: https://issues.apache.org/jira/browse/KYLIN-1902
> Project: Kylin
>  Issue Type: Bug
>  Components: Web 
>Affects Versions: v1.5.2
>Reporter: Shaofeng SHI
>Assignee: Zhong,Jason
>
> Request URL:http://localhost:7070/kylin/models
> Request Method:GET
> Status Code:404 Not Found
> Remote Address:[::1]:7070
> I think this issue has existed for some time; Although it doesn't impact on 
> user experience, an 404 error in web console is confusing. @Jason Can we fix 
> it in v1.5.3?



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Closed] (KYLIN-2023) import source error

[panzhiwei (JIRA)]

 [ 
https://issues.apache.org/jira/browse/KYLIN-2023?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

panzhiwei closed KYLIN-2023.

Resolution: Fixed

> import source error
> ---
>
> Key: KYLIN-2023
> URL: https://issues.apache.org/jira/browse/KYLIN-2023
> Project: Kylin
>  Issue Type: Bug
>  Components: Web 
>Reporter: panzhiwei
>Assignee: Zhong,Jason
> Attachments: error.jpg
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (KYLIN-2023) import source error

[panzhiwei (JIRA)]

[ 
https://issues.apache.org/jira/browse/KYLIN-2023?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15500476#comment-15500476
 ] 

panzhiwei commented on KYLIN-2023:
--

thank you ,i check out kylin-1.5.x-HBase1.x,than change hbase version,build ok .

> import source error
> ---
>
> Key: KYLIN-2023
> URL: https://issues.apache.org/jira/browse/KYLIN-2023
> Project: Kylin
>  Issue Type: Bug
>  Components: Web 
>Reporter: panzhiwei
>Assignee: Zhong,Jason
> Attachments: error.jpg
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (KYLIN-2024) kylin TopN only support the first measure

[Kris (JIRA)]

 [ 
https://issues.apache.org/jira/browse/KYLIN-2024?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Kris updated KYLIN-2024:

Description: 
when I build cube chose top-N and select the group by column ,like this 

TOP_N   SUM|ORDER BY:CLICK
GROUP BY:MEDIA_SLOT

TOP_N   
SUM|ORDER BY:EREQ
GROUP BY:MEDIA_SLOT

TOP_N   
SUM|ORDER BY:ECLICK
GROUP BY:MEDIA_DOMAIN

TOP_N   
SUM|ORDER BY:REQUEST
GROUP BY:MEDIA_DOMAIN

if I use SQL likes "select MEDIA_SLOT ,sum(EREQ) ... ...group by (MEDIA_SLOT) 
order by sum(EREQ) desc /asc limit 100"  or group by(MEDIA_DOMAIN),sum(REQUEST) 
the result gets none.But if sum(CLICK) group by (MEDIA_SLOT) or sum(ECLICK) 
group by (MEDIA_DOMAIN) the result return true;
Best whishes.


  was:
when I build cube chose top-N and select the group by column ,like this 

TOP_N   SUM|ORDER BY:CLICK
GROUP BY:MEDIA_SLOT

TOP_N   
SUM|ORDER BY:EREQ
GROUP BY:MEDIA_SLOT

TOP_N   
SUM|ORDER BY:ECLICK
GROUP BY:MEDIA_DOMAIN

TOP_N   
SUM|ORDER BY:REQUEST
GROUP BY:MEDIA_DOMAIN

if I use SQL likes "select MEDIA_SLOT ,sum(EREQ) ... ...group by (MEDIA_SLOT) 
order by sum(EREQ) desc /asc limit 100"  or group by(MEDIA_DOMAIN),sum(REQUEST) 
the result gets none.But if sum(CLICK) group by (MEDIA_SLOT) or sum(ECLICK) 
group by (MEDIA_DOMAIN) the result retrun true;
Best whishes.



> kylin TopN only support the first measure 
> --
>
> Key: KYLIN-2024
> URL: https://issues.apache.org/jira/browse/KYLIN-2024
> Project: Kylin
>  Issue Type: Bug
>  Components: Job Engine
>Affects Versions: v1.5.3
>Reporter: Kris
>Assignee: Dong Li
>  Labels: newbie
>
> when I build cube chose top-N and select the group by column ,like this 
> TOP_N SUM|ORDER BY:CLICK
> GROUP BY:MEDIA_SLOT
> TOP_N 
> SUM|ORDER BY:EREQ
> GROUP BY:MEDIA_SLOT
> TOP_N 
> SUM|ORDER BY:ECLICK
> GROUP BY:MEDIA_DOMAIN
> TOP_N 
> SUM|ORDER BY:REQUEST
> GROUP BY:MEDIA_DOMAIN
> if I use SQL likes "select MEDIA_SLOT ,sum(EREQ) ... ...group by (MEDIA_SLOT) 
> order by sum(EREQ) desc /asc limit 100"  or group 
> by(MEDIA_DOMAIN),sum(REQUEST) the result gets none.But if sum(CLICK) group by 
> (MEDIA_SLOT) or sum(ECLICK) group by (MEDIA_DOMAIN) the result return true;
> Best whishes.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (KYLIN-2023) import source error

[nichunen (JIRA)]

[ 
https://issues.apache.org/jira/browse/KYLIN-2023?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15500446#comment-15500446
 ] 

nichunen commented on KYLIN-2023:
-

That's because the code is based on hbase 0.98.x, please checkout the hbase 1.x 
branch and import again.

> import source error
> ---
>
> Key: KYLIN-2023
> URL: https://issues.apache.org/jira/browse/KYLIN-2023
> Project: Kylin
>  Issue Type: Bug
>  Components: Web 
>Reporter: panzhiwei
>Assignee: Zhong,Jason
> Attachments: error.jpg
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Created] (KYLIN-2024) kylin TopN only support the first measure

[Kris (JIRA)]

Kris created KYLIN-2024:
---

 Summary: kylin TopN only support the first measure 
 Key: KYLIN-2024
 URL: https://issues.apache.org/jira/browse/KYLIN-2024
 Project: Kylin
  Issue Type: Bug
  Components: Job Engine
Affects Versions: v1.5.3
Reporter: Kris
Assignee: Dong Li


when I build cube chose top-N and select the group by column ,like this 

TOP_N   SUM|ORDER BY:CLICK
GROUP BY:MEDIA_SLOT

TOP_N   
SUM|ORDER BY:EREQ
GROUP BY:MEDIA_SLOT

TOP_N   
SUM|ORDER BY:ECLICK
GROUP BY:MEDIA_DOMAIN

TOP_N   
SUM|ORDER BY:REQUEST
GROUP BY:MEDIA_DOMAIN

if I use SQL likes "select MEDIA_SLOT ,sum(EREQ) ... ...group by (MEDIA_SLOT) 
order by sum(EREQ) desc /asc limit 100"  or group by(MEDIA_DOMAIN),sum(REQUEST) 
the result gets none.But if sum(CLICK) group by (MEDIA_SLOT) or sum(ECLICK) 
group by (MEDIA_DOMAIN) the result retrun true;
Best whishes.




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (KYLIN-2023) import source error

[panzhiwei (JIRA)]

[ 
https://issues.apache.org/jira/browse/KYLIN-2023?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15500350#comment-15500350
 ] 

panzhiwei commented on KYLIN-2023:
--

I am import keylin1.5.4.src to eclipse, than set 
1.1.6.but the class 
AggregateRegionObserver.java in  module kylin-storage-hbase has a error at line 
102 ,the error like this "Type mismatch: cannot convert from Region to 
HRegion"。 

!error.jpg|thumbnail!

> import source error
> ---
>
> Key: KYLIN-2023
> URL: https://issues.apache.org/jira/browse/KYLIN-2023
> Project: Kylin
>  Issue Type: Bug
>  Components: Web 
>Reporter: panzhiwei
>Assignee: Zhong,Jason
> Attachments: error.jpg
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)