[jira] [Created] (KYLIN-1928) Query elapsed time not shown when query returns 0 result

hongbin ma created KYLIN-1928: - Summary: Query elapsed time not shown when query returns 0 result Key: KYLIN-1928 URL: https://issues.apache.org/jira/browse/KYLIN-1928 Project: Kylin Issue Type

[jira] [Created] (KYLIN-1924) Region server metrics: replace int type for long type for scanned row count

hongbin ma created KYLIN-1924: - Summary: Region server metrics: replace int type for long type for scanned row count Key: KYLIN-1924 URL: https://issues.apache.org/jira/browse/KYLIN-1924 Project: Kylin

[jira] [Created] (KYLIN-1922) Improve the logic to decide whether to pre aggregate on Region server

hongbin ma created KYLIN-1922: - Summary: Improve the logic to decide whether to pre aggregate on Region server Key: KYLIN-1922 URL: https://issues.apache.org/jira/browse/KYLIN-1922 Project: Kylin

Re: Can Kylin support Sub-query or Case when with SQL

​calculation on measures ​is something Kylin does not support well now. I've seen many people asking about it. A simple scenario is to find the sum of all transaction amounts where the transaction's amount is large than 5 dollars. Although we cannot allow flexible calculation on measures at

Re: [VOTE] Release apache-kylin-1.5.3 (release candidate 3)

+1 (binding), mvn test passed On Tue, Jul 26, 2016 at 7:09 AM, Li Yang wrote: > +1 (binding) > > mvn test pass > > java version "1.7.0_71" > OpenJDK Runtime Environment (rhel-2.5.3.1.el6-x86_64 u71-b14) > OpenJDK 64-Bit Server VM (build 24.65-b04, mixed mode) > > > On Mon,

Re: kylin intermediate tables in Hive

it might have something to do with the bug described in https://issues.apache.org/jira/browse/KYLIN-1828, I'll cross check On Tue, Jun 21, 2016 at 10:36 PM, ShaoFeng Shi wrote: > Hi Jie, would you mind to report a JIRA with this problem you found? If you > can attache

[jira] [Created] (KYLIN-1914) Insight page result grid view will eat whitechars

hongbin ma created KYLIN-1914: - Summary: Insight page result grid view will eat whitechars Key: KYLIN-1914 URL: https://issues.apache.org/jira/browse/KYLIN-1914 Project: Kylin Issue Type: Bug

[jira] [Created] (KYLIN-1913) query log printed abnormally if the query contains "\r" (not "\r\n")

hongbin ma created KYLIN-1913: - Summary: query log printed abnormally if the query contains "\r" (not "\r\n") Key: KYLIN-1913 URL: https://issues.apache.org/jira/browse/KYLIN-1913

Re: NPE when metastore cleanup

is there a way to reproduce the issue? On Thu, Jul 21, 2016 at 9:55 AM, Yiming Liu wrote: > It seems need NULL check when doing cleanup dictionary tables. > > > 2016-07-21 01:51:51,893 INFO [main CubeDescManager:197]: Reloading Cube > Metadata from folder

Re: Question regarding Sandbox mode

​afaik there's no other significant difference. sandbox is a ideal env to mimic a big cluster​ On Tue, Jul 19, 2016 at 3:05 AM, Abhilash L L wrote: > Hello, > >When Kylin runs in sandbox mode, is the only difference around > authentication ? Just that its a different

Re: Kylin start errors , Web ui not visible

​does the account have access to create hbase tables write things to hbase in shell?​ -- Regards, *Bin Mahone | 马洪宾*

Re: [Discuss] Prepare releasing v1.5.3

​+1 We should release on regular basis.​ Some known bugs could easily become show stoppers for new comers. On Mon, Jul 4, 2016 at 5:24 PM, ShaoFeng Shi wrote: > Hi Kylin developers, > > It has been more than 1 month since v1.5.2 release; There are a couple of > major

Re: kylin刷cube报NaN错误

No attachment is found you can use https://gist.github.com/ 2016-07-01 14:45 GMT+08:00 Tang : > 大家好 > 在刷kylin的时候报NaN错误。 > 相关错误和日志请见附件。 > > 我们用的hdp版本是2.4.0.0-169，hbase是1.1的。kylin1.5 > > 根据提示我在kylin_job_conf.xml和kylin_hive_conf.xml都配置了相关信息。重启后继续刷还是报同样的错误。 > > 请大家帮忙看看有什么好建议吗？

Re: EXTENDED_COLUMN-build error

besides the measure part, you need SITE_EXTENDED_1 and SITE_EXTENDED_2 added in "hbase_mapping" as well On Fri, Jul 1, 2016 at 1:59 PM, hongbin ma <mahong...@apache.org> wrote: > Unfortunately, there's no webUI for extended column yet. we're still > working on it. > >

Re: EXTENDED_COLUMN-build error

Unfortunately, there's no webUI for extended column yet. we're still working on it. You can edit the cube desc json directly, refer to KYLIN_HOME/examples/test_case_data/localmeta/cube_desc/test_kylin_cube_without_slr_desc.json as an example, we have two extended column measure there:

[jira] [Created] (KYLIN-1792) behaviours for non-aggregated queries

hongbin ma created KYLIN-1792: - Summary: behaviours for non-aggregated queries Key: KYLIN-1792 URL: https://issues.apache.org/jira/browse/KYLIN-1792 Project: Kylin Issue Type: Improvement

Re: some question about setMaxResultSize for scanner (CubeHBaseScanRPC /CubeHBaseEndpointRPC)

replied in the JIRA no need to duplicate the message to mail list as long as you've subscribed @dev list On Thu, Jun 16, 2016 at 10:16 AM, alaleiwang wrote: > do you mean that: >we should not write query like "select * from "，instead,we should > have query like

Re: properties in kylin configuration files

​Since you intermediate table is merely 200M, each mapper deals with 100M fact table. This is not very heavy for a mapper. Have you checked the log for the mapper to know what is it doing in the 3600s? On Thu, Jun 16, 2016 at 10:35 AM, hongbin ma <mahong...@apache.org> wrote: > 3.7 GB

Re: properties in kylin configuration files

3.7 GB of 8.4 GB virtual memory used ​do you have any idea why the container is using lots of virtual memory? is there any heavy contention ​on the memory resource? Not sure if it's the root cause for slow mappers ​ -- Regards, *Bin Mahone | 马洪宾* Apache Kylin: http://kylin.io Github:

Re: some doubt about hierarchy dimension in kylin 1.5+

year,month,day​ > > how can you get "date" in the json when you didn't input "date" while > creating cube? > > On Thu, Jun 16, 2016 at 8:44 AM, 251469031 <251469...@qq.com> wrote: > > > @Hongbin Ma > > > > sorry about that.

Re: some doubt about hierarchy dimension in kylin 1.5+

​date dimension does not exist at all, it's just a logical "dimension" consists of three related dimensions: year,month,day​ how can you get "date" in the json when you didn't input "date" while creating cube? On Thu, Jun 16, 2016 at 8:44 AM, 251469031 <251469

Re: properties in kylin configuration files

ShardBy": false > } > ] > }, > "signature": "jM6BX7iZE3oHEN+aw0tXaw==", > "last_modified": 1465892097992, > "model_name": "logout_full", > "null_string": null, > "hbase_mapping": { >

Re: build error in step Build N-Dimension Cuboid Data : 20-Dimension

hi I'm taking care of that JIRA, it might be a bug, thanks for reporting. On Tue, Jun 14, 2016 at 10:53 PM, 耳东 <775620...@qq.com> wrote: > yes it is the same issue, and it is just submitted 2 hours ago. > > > > > -- 原始邮件 -- > 发件人: "Dong Li";; >

Re: some doubt about hierarchy dimension in kylin 1.5+

1. use normal dimension here. the hierachy relationship is later defined in "aggregation group" 2. actually I don't quite understand your question. if you're asking how to get the ​hierachy relationship from the json, take a look at aggregation_groups => select_rule => hierarchy_dims --

Re: Timeout visiting cube

​actually, can you please attach latest 2 minutes' log before 2016-06-15 02:18:22,741? it's still incomplete for our analysis -- Regards, *Bin Mahone | 马洪宾* Apache Kylin: http://kylin.io Github: https://github.com/binmahone

Re: id-name

to be clear, it's "joint dimensions" in "aggregation group", you can find it in webUI cube creation wizard. http://kylin.apache.org/blog/2016/02/18/new-aggregation-group/ gives a detailed intro On Wed, Jun 15, 2016 at 11:57 AM, Dong Li wrote: > Are these dimensions on Lookup

Re: kylin 1.5版本，最大支持多少个Mandatory维度的cube

hi, I've described the problem and solution in https://issues.apache.org/jira/browse/KYLIN-1788, it's open for discussion now, please expect it fixed in next 1.5.x release. As a workaround now you can create multiple aggregation groups. and divide your mandatory dimension into them. The

Re: properties in kylin configuration files

kylin_job_conf.xm ​l will be ​ ​ ​used for overwriting confs for kylin job. ​Instead of seeking to disable container timeout I suggest to figure out why it's taking so long. a fact table with 3G in size is not that large, the mapper should not take that long. how many dimensions do you have? can

Re: some question about setMaxResultSize for scanner (CubeHBaseScanRPC /CubeHBaseEndpointRPC)

Even though Kylin is not designed for non-agg queries (with no group by), your query should still work because it has "limit" clause. Seems "limit 10" is not pushed down to endpoint storage visit correctly. I'm openning https://issues.apache.org/jira/browse/KYLIN-1787 to track this. Please expect

Re: 答复: kylin.properties中文配置乱码

Hi tianshuo You're more than welcome to contribute to the community! Like most projects in apache community, one should prove his consistent devotion and contribution to Kylin before he become a committer. I'd suggest you to keep active in the mail thread and start reporting/working on JIRA

Re: [jira] [Created] (KYLIN-1783) Can't add override property at cube design 'Configuration Overwrites' step.

I guess it is solved in https://issues.apache.org/jira/browse/KYLIN-1769? On Sun, Jun 12, 2016 at 4:22 PM, Ma Gang (JIRA) wrote: > Ma Gang created KYLIN-1783: > -- > > Summary: Can't add override property at cube design > 'Configuration

Re: Blog to introduce the Diagnosis Tool

cool! hope it could help people more from the community :) On Sun, Jun 12, 2016 at 11:37 AM, Dong Li wrote: > Hello community, > > > I wrote a blog about the Diagnosis functionality introduced since 1.5.2. > > http://kylin.apache.org/blog/2016/06/10/diagnosis-tool/ > > >

[jira] [Created] (KYLIN-1743) Preview all the valid cuboids at web wizard

hongbin ma created KYLIN-1743: - Summary: Preview all the valid cuboids at web wizard Key: KYLIN-1743 URL: https://issues.apache.org/jira/browse/KYLIN-1743 Project: Kylin Issue Type: Improvement

Re: Timeout visiting cube!

kylin query server can't wait for hbase coprosessors to return forever. By default kylin uses hbase's "hbase.rpc.timeout" as the rpc call's timeout. You can increase the kylin side timeout by increasing the kylin.query.cube.visit.timeout.times to larger multiplier than one(default). However it may

Re: SQL Statements supported by Kylin 1.5

yes for now On Wed, May 18, 2016 at 2:08 PM, Mars J <xujiao.myc...@gmail.com> wrote: > does it just support select statements ? > > 2016-05-18 11:53 GMT+08:00 hongbin ma <mahong...@apache.org>: > > > kylin uses Apache Calcite for sql parsing, so the supported sql

Re: expansion rate so high

I guess there is one or more dimensions with very high cardinality? have you read http://kylin.apache.org/blog/2016/02/18/new-aggregation-group/? there might be some inspirations there. also, are the four fixed length dimensions all text? are there any relationships between the dimensions? Why

Re: CubeInstance desc not found

Seems you metadata store is corrupted, did you perform any direct access to hbase metadata store? Dump you metadata store with `$KYLIN_HOME/bin/metastore.sh backup`, is there a json named TERMINAL_MME_CUBE in cube_desc/ ? You can also upload the dumped store so that the community can help to

Re: SQL Statements supported by Kylin 1.5

kylin uses Apache Calcite for sql parsing, so the supported sql will be a subset of https://calcite.apache.org/docs/reference.html. However always keep in mind metrics in kylin need pre-calculating, currently we still have many unsupported metrics like standard deviation, percentile,etc. On Wed,

Re: why can't I see the project which is created by other kylin server when I visit a kylin server ?

The update should be automatic. There might be some bug. What is your kylin version? Another question: does the auto update only fails at project creating? have you also tried cube creating, create build,etc.?​ On Wed, May 18, 2016 at 10:45 AM, 杨海乐 wrote: > The two kylin

Re: About Cube List

​will you consider using projects to manage your models?​ On Tue, May 17, 2016 at 11:27 AM, Mars J wrote: > Hi, >It's inconvenience to show more than 15 or 30 cubes in the list in > 'Model' tab.Even though there is a 'More' button, but it's still not quick > to find

[jira] [Created] (KYLIN-1690) always returning 0 or 1 for sum(a)/sum(b) for integer type a and b

hongbin ma created KYLIN-1690: - Summary: always returning 0 or 1 for sum(a)/sum(b) for integer type a and b Key: KYLIN-1690 URL: https://issues.apache.org/jira/browse/KYLIN-1690 Project: Kylin

Re: how to get the rate value

​I think it's still worth a JIRA: https://issues.apache.org/jira/browse/KYLIN-1690 On Sun, May 15, 2016 at 11:43 PM, hongbin ma <mahong...@apache.org> wrote: > for integer metrics, a quick workaround is to modify sum(b)/sum(a) to > 1.0*sum(b)/sum(a) > > On Sun, May 8, 2016 a

Re: how to get the rate value

for integer metrics, a quick workaround is to modify sum(b)/sum(a) to 1.0* sum(b)/sum(a) On Sun, May 8, 2016 at 8:26 PM, Li Yang wrote: > Thanks for the update. > > On Thu, May 5, 2016 at 2:57 PM, 耳东 <775620...@qq.com> wrote: > > > The datatype is bigint. This problem is

Re: some doubt about query result from in insight

looks like a bug in kylin. opened a jira in https://issues.apache.org/jira/browse/KYLIN-1689 since it's not typical for a numerical column to be dimension as well as sum metric, the bug fix may come late On Mon, May 9, 2016 at 10:44 AM, 胡志华(万里通科技及数据中心商务智能团队数据分析组) < huzhihua...@pingan.com.cn>

[jira] [Created] (KYLIN-1689) bug when a column being dimension as well as in a sum metric

hongbin ma created KYLIN-1689: - Summary: bug when a column being dimension as well as in a sum metric Key: KYLIN-1689 URL: https://issues.apache.org/jira/browse/KYLIN-1689 Project: Kylin Issue

Re: The monitor web page cannot load jobs

suggest to update to 1.5.1 1.5.1 metadata is compatible with 1.5.1 On Sun, May 15, 2016 at 8:55 PM, Li Yang wrote: > Try refresh kylin metadata from "Admin" tab, or restart Kylin. If the > problem persists and you can reproduce stably, open a JIRA. > > On Sat, May 14, 2016 at

Re: 答复: 答复: Can't create EnumerableAggregate

Hi Tao Did you ever change the definition of the sample cube? On Fri, May 6, 2016 at 12:01 PM, Tao Li(Internship) wrote: > My configuration environment as follows: > Hadoop: 2.5.2 > Hive: 1.2.1 > Hbase: 1.1.3 > Kylin: 1.5.1 > > -邮件原件- > 发件人: ShaoFeng Shi

Re: My kylin cube build successfully,but when query I meetthisexception:

​please go to https://github.com/apache/hbase, checkout the version corresponding to your deployed hbase version, and check if the method org.apache.hadoop.hbase.coprocessor.RegionCoprocessorEnvironment.getRegion() exist. if the method does exist. Then you might need to check if your hbase is

Re: CubeHFileJob fail with mr job configuration

are you using a local mode hadoop? if that's the case I'd suggest to use a hortonworks/cloudera sandbox to avoid env issues. On Tue, May 3, 2016 at 12:52 PM, alaleiwang wrote: > any reply for this? > > -- > View this message in context: >

Re: java.lang.IllegalArgumentException:KeyValue size too large at Building Dimension Dictionary

is it possible that one of the dimensions specified as "dict encoding" turns out to be having huge cardinality/dimension length? if that's the case, the generated dictionary might be too large to fix. You should think about using other dimension encodings like "fixed length" or "extended column

Re: Timeout visiting cube!

Hi Amit seems no attachment is found On Tue, May 3, 2016 at 11:09 PM, Amit Jain wrote: > Hi Li, > Log file is attached. Please let me know your findings. > Thanks for your help. > Amit > > On Tue, May 3, 2016 at 5:00 AM, Li Yang wrote: > >> Could you share

Re: Empty result return in the Insight query kylin1.5.1

please check the content of the first steps output hive table. Usually it's because 0 rows exist in that table On Wed, Apr 27, 2016 at 11:58 AM, Tao Li(Internship) wrote: > Hi, > >I have successfully built a cube, however the cube size is zero and > query result is

[jira] [Created] (KYLIN-1627) add backdoor toggle to dump binary cube storage response for further analysis

hongbin ma created KYLIN-1627: - Summary: add backdoor toggle to dump binary cube storage response for further analysis Key: KYLIN-1627 URL: https://issues.apache.org/jira/browse/KYLIN-1627 Project: Kylin

Re: Re: No detail message when Error.

ntered similar issues. create cube, bulid cube, drop cube always show "Failed to take action". i try to reinstall kylin, it's not working. Best Regards Roy At 2016-04-13 20:17:44, "陈佛林" <chenfo...@gmail.com> wrote: >1.5.0 > >2016-04-13 19:41 G

Re: Cube is ready but insight tables not result

hi Roy as more than one users have reported this issue,we think it's a bug. However we need to reproduce it. can you tell us how to reproduce the issue? is it on a sample cube or your own cube? does it take very long to build the cube? and can you describe your hadoop env? On Tue, Apr 19, 2016

Re: Re： hive table change

...@gmail.com> wrote: > hi hongbin! > > can you give a more clear description, I can not understand "you'll find > it helpful", did you miss something? > > best regards! > > > > wangxianbin1...@gmail.com > > 发件人： hongbin ma > 发送时间： 2016-04-22 13:5

Re: 回复： hive table change

location is different > from the hive shell. how can i make the kylin to access these tables? > -- 原始邮件 -- 发件人: "hongbin ma"; > mahong...@apache.org; 发送时间: 2016年4月21日(星期四) 晚上6:31 收件人: "dev" > dev@kylin.apache.org; 主题: Re: 回复： hive tabl

Re: create error message

the image cannot display...can you attach the kylin.log under KYLIN_HOME/logs ? it will help analyse On Thu, Apr 21, 2016 at 5:26 PM, 耳东 <775620...@qq.com> wrote: > hi all > Every time I create a model or cube, when I clicked the save button > , it shows 'fail to take action', when I

[jira] [Created] (KYLIN-1601) Need not to shrink scan cache when hbase rows can be large

hongbin ma created KYLIN-1601: - Summary: Need not to shrink scan cache when hbase rows can be large Key: KYLIN-1601 URL: https://issues.apache.org/jira/browse/KYLIN-1601 Project: Kylin Issue

[jira] [Created] (KYLIN-1598) cannot run complete UT at dev machine

hongbin ma created KYLIN-1598: - Summary: cannot run complete UT at dev machine Key: KYLIN-1598 URL: https://issues.apache.org/jira/browse/KYLIN-1598 Project: Kylin Issue Type: Bug

Re: Kylin sample cube giving error

hi, did you follow http://kylin.apache.org/docs15/install/advance_settings.html to disable compression? and can you be more specific on where's not working? On Mon, Apr 18, 2016 at 10:26 AM, joffrey wrote: > Hi, I meet the same problem too, I tried to disable the snappy

[jira] [Created] (KYLIN-1595) columns in metric could also be in filter/groupby

hongbin ma created KYLIN-1595: - Summary: columns in metric could also be in filter/groupby Key: KYLIN-1595 URL: https://issues.apache.org/jira/browse/KYLIN-1595 Project: Kylin Issue Type: Bug

[jira] [Created] (KYLIN-1593) Agg group info will be blank when trying to edit cube

hongbin ma created KYLIN-1593: - Summary: Agg group info will be blank when trying to edit cube Key: KYLIN-1593 URL: https://issues.apache.org/jira/browse/KYLIN-1593 Project: Kylin Issue Type

[jira] [Created] (KYLIN-1591) enabling different block size setting for small column families

hongbin ma created KYLIN-1591: - Summary: enabling different block size setting for small column families Key: KYLIN-1591 URL: https://issues.apache.org/jira/browse/KYLIN-1591 Project: Kylin

[jira] [Created] (KYLIN-1586) UI part for KYLIN-1584

hongbin ma created KYLIN-1586: - Summary: UI part for KYLIN-1584 Key: KYLIN-1586 URL: https://issues.apache.org/jira/browse/KYLIN-1586 Project: Kylin Issue Type: New Feature Reporter

[jira] [Created] (KYLIN-1584) Specify region cut size in cubedesc and leave the RealizationCapacity in model as a hint

hongbin ma created KYLIN-1584: - Summary: Specify region cut size in cubedesc and leave the RealizationCapacity in model as a hint Key: KYLIN-1584 URL: https://issues.apache.org/jira/browse/KYLIN-1584

Re: ClassNotFoundException

are you using CHD, kylin 1.5.0? take a look at http://apache-kylin.74782.x6.nabble.com/Stuck-with-ClassNotFoundException-HCatInputFormat-td4032.html it can be found if you search google On Wed, Apr 13, 2016 at 6:01 PM, 耳东 <775620...@qq.com> wrote: > Hi all： when I built the cube, this

Re: No detail message when Error.

have you checked $KYLIN_HOME/logs/kylin.log? On Wed, Apr 13, 2016 at 6:18 PM, 陈佛林 wrote: > hi, > > almost all error just show a little message. > > such as: > > Error Message > > Failed to take action. > > > I have no idea what happened. > -- Regards, *Bin Mahone |

Re: Fwd: About the Cleanup Storage in Kylin

if you're using v1.3, just refer to the 1.3 document http://kylin.apache.org/docs/ On Tue, Apr 12, 2016 at 8:40 AM, Mars J wrote: > Thanks,My version is v 1.3, I had already found it. > org.apache.kylin.job.hadoop.cube.StorageCleanupJob > > I found the in the v 1.5

[jira] [Created] (KYLIN-1578) Coprocessor thread voluntarily stop itself when it reaches timeout

hongbin ma created KYLIN-1578: - Summary: Coprocessor thread voluntarily stop itself when it reaches timeout Key: KYLIN-1578 URL: https://issues.apache.org/jira/browse/KYLIN-1578 Project: Kylin

Re: [VOTE] Release apache-kylin-1.5.1 (release candidate 1)

+1 binding verified md5 and sha1 On Mon, Apr 11, 2016 at 11:41 AM, yu feng wrote: > +1 (binding) > > signature verified > > mvn test passed > > 2016-04-09 17:38 GMT+08:00 Luke Han : > > > +1 (binding) > > > > mvn test passed > > signature verified > > >

Re: Sample cube error

gt; should I remove hadoop and then install hadoop sandbox? > > On Fri, Apr 8, 2016 at 12:33 PM, hongbin ma <mahong...@apache.org> wrote: > > > I mean, hadoop local mode > > > > On Fri, Apr 8, 2016 at 3:03 PM, hongbin ma <mahong...@apache.org> wrote: > > >

Re: Sample cube error

I mean, hadoop local mode On Fri, Apr 8, 2016 at 3:03 PM, hongbin ma <mahong...@apache.org> wrote: > Hi, does the MR job not exist, or you can't find the MR history page? try > a hdp sandbox if you're not familiar with local mode > > On Fri, Apr 8, 2016 at 2:56 PM, Ya

Re: Sample cube error

s no page found. > > On Fri, Apr 8, 2016 at 9:01 AM, hongbin ma <mahong...@apache.org> wrote: > > > better if you can provide more context. maybe you can go to the MR job's > > page and get mapper/reducer log to help analysis > > > > On Wed, Apr 6, 2016 at 10:19 PM, Ya

Re: Kylin sample cube giving error

​Seems snappy compression is not enabled in your env. By default Kylin leverages snappy compression to compress the output of MR jobs, as well as hbase table storage, to reduce the storage overhead. We do not choose LZO compression in Kylin because hadoop venders tend to not include LZO in their

Re: Sample cube error

better if you can provide more context. maybe you can go to the MR job's page and get mapper/reducer log to help analysis On Wed, Apr 6, 2016 at 10:19 PM, Yagyank Chadha wrote: > Hi developers > > I am trying to run sample cube given here( >

Re: RANK/DENSE_RANK on KYLIN

it's not working for kylin On Thu, Apr 7, 2016 at 12:51 AM, sdangi wrote: > Does Kylin support these analytic functions? > > I'm hitting into an issue while running this. Works ok on hive. > > SELECT CST_KEY, AMT, > RANK() OVER( ORDER BY AMT DESC) > FROM FCT > > Message:

[jira] [Created] (KYLIN-1556) Improvement on cube selection

hongbin ma created KYLIN-1556: - Summary: Improvement on cube selection Key: KYLIN-1556 URL: https://issues.apache.org/jira/browse/KYLIN-1556 Project: Kylin Issue Type: Improvement

Re: kylin sample test error

for issue 1 if it's not blocking anything you can ignore that for issue 2, please google previous discussions ​ -- Regards, *Bin Mahone | 马洪宾* Apache Kylin: http://kylin.io Github: https://github.com/binmahone

[jira] [Created] (KYLIN-1545) should not setMaxResultSize on hbase scan as it might cause incorrect answers

hongbin ma created KYLIN-1545: - Summary: should not setMaxResultSize on hbase scan as it might cause incorrect answers Key: KYLIN-1545 URL: https://issues.apache.org/jira/browse/KYLIN-1545 Project: Kylin

[jira] [Created] (KYLIN-1544) Make hbase encoding and block size configurable just like hbase compression

hongbin ma created KYLIN-1544: - Summary: Make hbase encoding and block size configurable just like hbase compression Key: KYLIN-1544 URL: https://issues.apache.org/jira/browse/KYLIN-1544 Project: Kylin

Re: 使用Kylin遇到的问题

hi wyatt please send email to the apache kylin dev mail list you have further questions. Kylin will not generate any hadoop jobid. Are you using a local mode hadoop to run kylin? Suggest you at least use a sandbox env: http://hortonworks.com/products/releases/hdp-2-2/#install to mimic real

Re: update hbase data realtime and query it

hi zeliu just want to make sure how you're updating the cuboid values in hbase? Are you merely adding the new rows to the cuboid? it might not work. Take the cuboid (dt,code) as an example, it might already contains a row like "2016-03-01 001" : "100". Your storm outputs another row "2016-03-01

Re: About the function of the "Refresh" button under tab "System"

On Sat, Mar 26, 2016 at 7:36 AM, Zhong, Yanghong wrote: > After a property be updated by “Set Config”, the left TextArea’s contents > be updated automatically. > ​this looks great to me ​ > After the “refresh” button clicked for “Server Config”, kylin loads >

[jira] [Created] (KYLIN-1526) Move query cache back to query controller level

hongbin ma created KYLIN-1526: - Summary: Move query cache back to query controller level Key: KYLIN-1526 URL: https://issues.apache.org/jira/browse/KYLIN-1526 Project: Kylin Issue Type

[jira] [Created] (KYLIN-1520) Port Kylin-1249 to 1.5.x branch

hongbin ma created KYLIN-1520: - Summary: Port Kylin-1249 to 1.5.x branch Key: KYLIN-1520 URL: https://issues.apache.org/jira/browse/KYLIN-1520 Project: Kylin Issue Type: Bug Reporter

[jira] [Created] (KYLIN-1502) When cube is not empty, only signature consistent cube desc updates are allowed

hongbin ma created KYLIN-1502: - Summary: When cube is not empty, only signature consistent cube desc updates are allowed Key: KYLIN-1502 URL: https://issues.apache.org/jira/browse/KYLIN-1502 Project

Re: [jira] [Created] (KYLIN-1508) NPE error ERROR - Build Cube - Step 3 if LOOKUP table is Hive View - : java.lang.NullPointerException at org.apache.kylin.source.hive.HiveTable.getSignature

BTW, Richard you should take a look at http://apache-kylin.74782.x6.nabble.com/Back-to-one-dev-branch-td3851.html#a3863, we have renamed our branches On Sun, Mar 20, 2016 at 1:54 PM, hongbin ma <mahong...@apache.org> wrote: > ​hi rechard, > > you're right, ​ it IS NOT possible

Re: ClassNotFoundException in apache-kylin-1.5.0

what is the current version you're using? 1.5.0 is not release yet, and the metadata migration tool for 1.2.x => 1.5.0 or 1.3.0 => 1.5.0 is still under developping. On Mon, Mar 14, 2016 at 1:52 PM, zeLiu wrote: > hi,hongbin > Installation for the first time in a clean

Re: [VOTE] Release apache-kylin-1.5.0 (release candidate 1)

​+1 binding​ On Mon, Mar 14, 2016 at 11:01 AM, Yerui Sun wrote: > +1(binding) > md5 sha1 passed > > Already looking for this version long time! > > > 在 2016年3月13日，22:41，周千昊 写道： > > > > +1(binding) > > md5 sha1 passed > > -- Regards, *Bin Mahone | 马洪宾*

Re: ClassNotFoundException in apache-kylin-1.5.0

is there any context for this issue? any modification to the metastore, or any updates performed recently? On Mon, Mar 14, 2016 at 10:48 AM, zeLiu wrote: > when I build job, can not find the class of > "org.apache.kylin.job.cube.UpdateCubeInfoAfterIndex". > > > 2016-03-14

[ANNOUNCE] Apache Kylin 1.3.0 released

The Apache Kylin team is pleased to announce the immediate availability of the 1.3.0 release. The release note can be found here [1]; The source code and binary package can be downloaded from Kylin's download page [2]. The Apache Kylin Team would like to hear from you and welcomes your comments

[RESULT][VOTE]Release apache-kylin-1.3.0 (release candidate 2)

Thanks to everyone who has tested the release candidate and given their comments and votes. The tally is as follows. 5 binding +1s: 5 non-binding +1s: No 0s or -1s. Therefore I am delighted to announce that the proposal to release Apache-Kylin-1.3.0 has passed. hongbin ma

Re: Back to one dev branch

+1 pointing the latest dev branch is more intuitive for those who are not that familiar with Kylin dev. On Thu, Mar 10, 2016 at 12:37 PM, Li Yang wrote: > Hi all > > With the settling of 1.3.0 release, the development of 1.x-staging will > come to a maintenance mode. New

Re: Is there any way to kill a running query?

I just opened a ticket on this, please check; https://issues.apache.org/jira/browse/KYLIN-1479 If you're using 1.x versions it's less likely that the feature will be added soon. On Wed, Mar 9, 2016 at 12:51 PM, huawang <1032195...@qq.com> wrote: > hi, > Is there any way to kill a running

Re: [VOTE] Release apache-kylin-1.3 (release candidate 1)

Since current release does not differ significantly I'd suggest to rename the current release to 1.2.1 instead of 1.3. Otherwise we'll have to maintain too many minor versions at the same time. On Tue, Mar 8, 2016 at 1:32 PM, hongbin ma <mahong...@apache.org> wrote: > ​revoke this

Re: [VOTE] Release apache-kylin-1.3 (release candidate 1)

​revoke this ​release candidate, and I'll soon release RC2 On Tue, Mar 8, 2016 at 1:31 PM, hongbin ma <mahong...@apache.org> wrote: > > Internally we used ​the -P sandbox profile to run all the tests. Seems > need to run "mvn test" to cover th > -- Regards, *Bi

Re: [VOTE] Release apache-kylin-1.3 (release candidate 1)

​@shaofeng, thanks for your input, I'll check. Internally we used ​the -P sandbox profile to run all the tests. Seems need to run "mvn test" to cover the default minicluster profile On Tue, Mar 8, 2016 at 1:22 PM, ShaoFeng Shi wrote: > ashMap.java:362) > > at

[VOTE] Release apache-kylin-1.3 (release candidate 1)

Hi all, I have created a build for Apache Kylin 1.3, release candidate 1. Changes highlights: [KYLIN-1323] - Improve performance of converting data to hfile [KYLIN-1186] - Support precise Count Distinct using bitmap [KYLIN-976] - Support Custom Aggregation Types [KYLIN-1054] - Support Hive

Re: [jira] [Created] (KYLIN-1464) org.apache.kylin.cube.CubeInstance.getDataModelDesc throw java.lang.NullPointerException

ay.com> wrote: > > > > > That’s right, before we store the metadata, we need make sure it > already > > > passed all the check. > > > > > > -- > > > Best regards, > > > John Zhao > > > > > > Cell: +1 (408) 464-5225 > > >

<    1   2   3   >