Re: kylin 作为Grafana 支持的一个数据源

> plug-in into grafan for data presentation > > > > > > ---------- > 发件人：Alberto Ramón > 发送时间：2018年10月16日(星期二) 17:31 > 收件人：user > 抄 送：潘博存 ; dev > 主 题：Re: kylin 作为Grafana 支持的一个数据源 > > I checked this possibility t

Re: kylin 作为Grafana 支持的一个数据源

I checked this possibility time ago (2-3years) Grafana is focus in time-line series (one column must be TimeStamp) Work with TS doesn't sense in A Kylin, because you are not aggregating On Tue, 16 Oct 2018 at 06:04, ShaoFeng Shi wrote: > Good question, let me translate it to English: > >

Re: TOPN

TopN is a predefinied measure in Apache Kylin, furthermore row_number is not needed (and isn't recomended because you are in a cube) "What is the link to the list of functions supported by kylin?" I think you refer to predefined measures: (Reference:

Lattices

FYI I’m reading about Apache Calcite Lattices Have sense expose Kylin as materialized view/cube ? Implementing data cubes efficiently

About GitBox and Jira

With the 'old' Jira Emails ( "[*jira] [Created] (KYLIN-3250) ***") You had the link to Jira, the description/target of it, the status, coments from people and you can suscribe to your favorites Jiras Did we lost these emails??? It Was very useful to know the progress of Apache Kylin (With

Re: [jira] [Created] (KYLIN-3171) Support hadoop 3 release

Duplicate ? KYLIN-2565 On 17 January 2018 at 03:28, Ted Yu (JIRA) wrote: > Ted Yu created KYLIN-3171: > - > > Summary: Support hadoop 3 release > Key: KYLIN-3171 >

Re: [jira] [Created] (KYLIN-3186) Add support for partitioning columns that combine date and time (e.g. YYYYMMDDHHMISS)

Could you check this: https://issues.apache.org/jira/browse/KYLIN-1427 Alb On 19 January 2018 at 21:33, Vsevolod Ostapenko (JIRA) wrote: > Vsevolod Ostapenko created KYLIN-3186: > - > > Summary: Add support for partitioning

Re: ODBC connections get error character

Could you check this KYLIN-2816 ? BR, Alb On 7 January 2018 at 05:21, Wangdp wrote: > Hi, > > When the column name is Chinese, connected by odbc in excel, the column > name display problem . > > > > >

Re: [Announce] New Apache Kylin PMC Billy Liu

Congratuolations to Bill, Guosheng and Cheng Wang !! On 16 October 2017 at 11:33, Luke Han wrote: > On behalf of the Apache Kylin PMC, I am very pleased to announce > that Billy Liu has accepted the PMC's invitation to become a > PMC member on the project. > > We

Re: Re: kylin encode

mestamp to date format? > 在 2017-09-30 16:05:23，"Alberto Ramón" <a.ramonporto...@gmail.com> 写道： > >As resume: > > > >-MM-dd / *MMdd* / -MM-dd HH:mm:ss > > > >Check this JIRAS: > >https://issues.apache.org/jira/browse/K

Re: kylin encode

As resume: -MM-dd / *MMdd* / -MM-dd HH:mm:ss Check this JIRAS: https://issues.apache.org/jira/browse/KYLIN-1101 https://issues.apache.org/jira/browse/KYLIN-1441 https://issues.apache.org/jira/browse/KYLIN-1427 On 30 September 2017 at 04:45, 崔苗 wrote: > we have

Project Level ACL

About Kylin 2760 (https://issues.apache.org/jira/browse/KYLIN-2760) I propose small change: - Only system admin can create and see connection strings - The connection string can't be see for Admin Project - Only system admin can add tables to Data Model - Then Admin Project is the

Re: Leap Month calculate error

Try to use DATE statement http://apache-kylin.74782.x6.nabble.com/about-kylin-sql-key-words-IN-td5908.html On 15 August 2017 at 08:59, apache_...@163.com wrote: > Hi, > > when i run sql by kyline GUI,Right result is 2011-02-28,but i got > 2011-03-01,is bug? > > select

Re: cube已经为ready状态，但无法执行查询语句

"Timeout visiting cube" is because HBase take long time to response to Apache Kylin Check: The status of your HBase and if design your cube is adequate to your query "select part_dt, sum(price) as total_selled, count(distinct seller_id) as sellers from kylin_sales group by part_dt order by

Re: cube计算结果为空

Check changes in Kylin 2513, 2601 and 2651 2017-07-27 3:08 GMT+01:00 253719...@qq.com <253719...@qq.com>: > > kylin v2.0 ，cube在计算（sum）类型为double的一列值以后，查询结果为空，该字段在数据库中查询一切正常， > 请问有人知道是怎么回事吗？ > -- > >

Re: kylin service has collapsed frequently

Queries like " Error while executing SQL "select count(*) from view_appdata_forkylin where program_id in catc1484739667844645 and flag=1 ", isn't good for Kylin check Kylin 1792 v1.5.3and this mailList On 30 July 2017 at 20:40, Li Yang

Re: Kylin2.0 can support create models or cube by restful ?

Check this mailList http://apache-kylin.74782.x6.nabble.com/Re-REST-APIs-for-Create-Update-models-and-cubes-and-selecting-datasources-tt7947.html On 17 July 2017 at 04:44, 1820983...@qq.com <1820983...@qq.com> wrote: > Hi, > > pls help: > >Kylin2.0 can support create models or cube by

Re: Query Metadata

."} work? yes, but you must put the name cube in HUE config. The connection is fixed to one cube On 29 August 2016 at 18:10, Alberto Ramón <a.ramonporto...@gmail.com> wrote: > Hi (This is ONLY a Idea - suggestion) > > I saw some problems integration between Kylin and HUE or Tab

Re: [jira] [Created] (KYLIN-2679) Report error when a dimension using "dict" encoding and also configured Global dictionary for "distinct_count" measure

Global dict can be used for Dim now? or only for measures On 22 June 2017 at 07:06, Shaofeng SHI (JIRA) wrote: > Shaofeng SHI created KYLIN-2679: > --- > > Summary: Report error when a dimension using "dict" encoding > and also

JARs in Hadoop 3.0

Could be this useful to avoid problems with JAR? or when HBase is in other cluster https://issues.apache.org/jira/browse/HADOOP-11804

Re: Some questions about Kylin2.0

About Q2: I'm agree with you, I think is a *issue* To start Kylin you must check exists one Source, one Engine and one Storage system (for example, is not necesary have Hive and Kafka) Example Spark

Re: Re: kylin connnect power bi by odbc

Hello, Some clarifications First, The connection ODBC1.6 can be configured check Kylin and PowerBi.odt Second, There is a bug in Kylin 1.6 Kylin 2235 Third, Older versions of

Re: Do kylin cache cube/segment data elsewhere other then hbase

FYI. >From HBase 1.1 you can use MemCache as Block Cache in HBase HBase 13170 MemCache is write on C and bypass the Java GC problem in BlockCache --> Fast Improvement: HBase 14984 v1.2.0

Serveral Things

FYI: 1 - About error: "snapshot more than 300MB", I think all columns of the table are loaded in RAM, independently these are used or no , is this possible ? 2 Apache Flink 1.2 is "ready" to docker, they had some changes to be more compatible Flink 6369

Re: Kylin multiple cube issue from the same data model

One query only can be resolved with one cube On 19 May 2017 at 07:58, elicer wrote: > Thanks for your answer > If I have the same aggregation group in different cubes will it cause > duplicate results? > > -- > View this message in context: http://apache-kylin.74782.x6.

Re: Kylin multiple cube issue from the same data model

If there are more than one cube per proyect, the kylin optimizator choose the best Cube to solve the query On 19 May 2017 at 06:59, elicer wrote: > Hi > I have some query on create multiple cube from the same data model, I have > a cute which build on a existing

Re: REST APIs for Create/Update models and cubes and selecting datasources

This is another possible solution (in the road map) On 11 May 2017 at 23:40, Nirav Patel <npa...@xactlycorp.com> wrote: > Sure. Is export/import in that JIRA means GET/CREATE? > > On Thu, May 11, 2017 at 3:05 PM, Alberto Ramón <a.ramonporto...@gmail.com> > wrote:

Re: REST APIs for Create/Update models and cubes and selecting datasources

(Its not necesary duplicate all Q in dev and user MailList, thanks) http://mail-archives.apache.org/mod_mbox/kylin-user/201609.mbox/%3C9EEA4677F012024598DC5D7E4D11FD53886EEAAE%40QTAUSC-VPEXC001.quantium.com.au.local%3E https://issues.apache.org/jira/browse/KYLIN-1605 On 11 May 2017 at 22:57,

Re: where is the source code kylin-2.0.0-hbase1x

This can help you: (in 2.0 the branch system ans been changed) https://issues.apache.org/jira/browse/KYLIN-2413 On 4 May 2017 at 05:36, xl l wrote: > hi,all: > In http://kylin.apache.org/download/ > apache-kylin-2.0.0-bin-hbase098.tar.gz source code in: >

Re: [Announce] New Apache Kylin committer Zhixiong Chen

Congratulations to Roger Shi and Zhixiong!! (and Dev team for next 2.0 version) If you are ever near London or Spain, let me know, have beer will be necesary :) 2017-04-29 12:47 GMT+01:00 Dong Li : > Welcome! > > Thanks, > Dong Li > > Original Message > *Sender:* Li

Re: BadQueryDetector (Please ignore the last post)

Hi Check this: https://issues.apache.org/jira/browse/KYLIN-1792 yes, like you said, if you have a cube its to use with agregates == group by 2017-04-25 16:12 GMT+01:00 rahulsingh : > Hi all, > > We are using Tableau Desktop 10.2.1 with Kylin 1.6. We got success to >

Re: cube building taking 8 hours just for 6 thousands records

Can you check how many ram and cpu is asigned to yarn? El 18 abr. 2017 7:40 a. m., "suresh m" escribió: > Hi This is the time consuming step in entire build process. > > #24 Step Name: Build Cube > > Please help me to get it resolved. > > Regards, > Suresh > > On Mon,

Re: kylin-yarn-ClassNotFoundException

Hi I think cdh 5.8 isn't supported yet See that there is a binary of 5.7 but not 5.8 El 9 abr. 2017 2:10 a. m., "chenping...@keruyun.com" < chenping...@keruyun.com> escribió: my environment is CDH 5.8.4 and kylin is apache-kylin-1.6.0-cdh5.7- bin.tar.gz I make the "Quick Start with Sample

Re: Cube query failing on changing rowkeys column order

not fail with any order of rowkeys. > > On Tue, Apr 4, 2017 at 2:46 PM, Alberto Ramón <a.ramonporto...@gmail.com> > wrote: > > > hello, from http://kylin.apache.org/docs16/tutorial/create_cube.html > > > > "You can drag & drop a dimension column to

Re: Cube query failing on changing rowkeys column order

hello, from http://kylin.apache.org/docs16/tutorial/create_cube.html "You can drag & drop a dimension column to adjust its position in rowkey; Put the mandantory dimension at the begining, then followed the dimensions that heavily involved in filters (where condition). Put high cardinality

Re: Kylin是否能够支持衍生指标

you can check this links http://apache-kylin.74782.x6.nabble.com/Derived-measures-in-Kylin-td5513.html http://apache-kylin.74782.x6.nabble.com/Does-Kylin-support-percent-function-td7061.html https://issues.apache.org/jira/browse/KYLIN-976 2017-03-31 10:20 GMT+01:00 赵天烁

Re: wait for stpe1 : Create Intermediate Flat Hive Table

> > 2017-03-27 7:25 GMT+08:00 Alberto Ramón <a.ramonporto...@gmail.com>: > > > Uppss "*ezmlm-reject: fatal: Sorry, I don't accept messages larger than > > 100 bytes* " > > > > I put in my GooDrive: > > https://drive.google.com/open?id=0B-6n

Re: Problem with building other cube than Sample [Cloudera]

To see actual jobs of YARN: localhost:8088 To see historical jobs (has been finished): localhost:19888 (check this ports with your Hadoop distribution and actual configuration) 2017-03-29 8:26 GMT+01:00 Bart : > To see what YARN is saying I need to kill my process. It shows me

Re: 答复: How to Custom Aggregate Functions;

quy...@tycmc.net>: > Thank you, but I still don't know how to do it. I don't know how to load > into kylin. > > -邮件原件----- > 发件人: Alberto Ramón [mailto:a.ramonporto...@gmail.com] > 发送时间: 2017年3月28日 15:17 > 收件人: dev > 主题: Re: How to Custom Aggregate Funct

Re: How to Custom Aggregate Functions;

Check this https://issues.apache.org/jira/browse/KYLIN-976 2017-03-28 4:59 GMT+01:00 quyang : > I write a json for metadata and how to do it? > > measureTypeFactory Export a jar ? > > I need a tutorial . > > Excuse me, my English is poor. > > > >

Re: wait for stpe1 : Create Intermediate Flat Hive Table

Uppss "*ezmlm-reject: fatal: Sorry, I don't accept messages larger than 100 bytes* " I put in my GooDrive: https://drive.google.com/open?id=0B-6nZ2q-HPTNU3BHU3BkMURXYlE 2017-03-27 0:02 GMT+01:00 Alberto Ramón <a.ramonporto...@gmail.com>: > Hello > > I attache

Re: wait for stpe1 : Create Intermediate Flat Hive Table

n Sat, Mar 25, 2017 at 7:46 AM, Li Yang <liy...@apache.org> wrote: > > > Great document! I love it!! > > > > On Tue, Mar 21, 2017 at 9:22 AM, Alberto Ramón < > a.ramonporto...@gmail.com> > > wrote: > > > >> This is the final text > >> >

Re: wait for stpe1 : Create Intermediate Flat Hive Table

announce it in a > JIRA, then people will be able to review. > > :-) > > On Sat, Mar 18, 2017 at 8:25 PM, Alberto Ramón <a.ramonporto...@gmail.com> > wrote: > > > @Li Yang, yes, I have an improved version in my laptop, Im adatpting to > > kelly > > (also of

Ozone

Hi I saw the PPT of Apahe Kylin 2.0 for the Haodoop Summit of Li Yang In the "What is the next" section, can be interesting for Apache Kylin, evaluate Apache Ozone (PPT of Summit 2015 Video

Re: Question Regrading Cube Query Time

Hi can you try to rebuild cube with a new measure? TopN 2017-03-17 17:58 GMT+00:00 Li Yang : > You didn't mention the Kylin version. Seems to be 1.6 from the > configuration property. > > The properties related to region number are (note names are slightly > differently in

Re: wait for stpe1 : Create Intermediate Flat Hive Table

> > Yang > > On Sat, Mar 11, 2017 at 5:16 AM, Alberto Ramón <a.ramonporto...@gmail.com> > wrote: > > > try to use ORC format in Hive with compression, the result: > > https://github.com/albertoRamon/Kylin/raw/master/ > > KylinPerformance/Images/08.png >

Re: 问题咨询

fyi http://apache-kylin.74782.x6.nabble.com/Hive-server-vs-Impala-server-td5639.html 2017-03-14 5:17 GMT+00:00 罗生亮 : > kylin能对接kudu和Impala吗？ > > > > 罗生亮 >

Re: count(distinct case when condittion) (distinct) return same result

jaja, sorry 2017-03-11 8:14 GMT+00:00 Alberto Ramón <a.ramonporto...@gmail.com>: > is this the same problem? > https://issues.apache.org/jira/browse/KYLIN-2341 > > 2017-03-11 1:04 GMT+00:00 Li Yang <liy...@apache.org>: > >> The behavior resembles KYLIN-2341

Re: count(distinct case when condittion) (distinct) return same result

is this the same problem? https://issues.apache.org/jira/browse/KYLIN-2341 2017-03-11 1:04 GMT+00:00 Li Yang : > The behavior resembles KYLIN-2341. Still worth a new JIRA to track. > > https://issues.apache.org/jira/browse/KYLIN-2500 > > > On Thu, Mar 9, 2017 at 2:48 PM, Roy

Re: wait for stpe1 : Create Intermediate Flat Hive Table

try to use ORC format in Hive with compression, the result: https://github.com/albertoRamon/Kylin/raw/master/KylinPerformance/Images/08.png (My apologies, I'm in process to improve these notes and put un kylin manual) Also partition fact table:

Re: How kylin limit mapreduce task Memory!!!!

??? Please check this properties - k*yl**in.job.mr.config.override.mapred.map.child.**java.opts=-Xmx8g *(for example) - *kylin.job.mr.config.override.mapreduce.map.memory.mb=8500 *(for example) Check the prefix "*kylin.job.mr.config.override.*" 2017-03-08 8:28

Re: Kylin build 13 Step (Build Cube) has error

This is a very tipical problem with YARN, you will find a lot of info on Internet. Review this parameters, and check if your hardward system is enougth (The values are an exaple) - yarn.nodemanager.resource.memory-mb = 15 GB - yarn.scheduler.maximum-allocation-mb = 8 GB -

Re: Unkown main cluster host when build new cube

Check this http://apache-kylin.74782.x6.nabble.com/Error-in-kylin-with-standalone-HBase-cluster-td6901.html Anyway this configuration, I don't know if this is recomended for production environment 2017-02-19 12:25 GMT+01:00 柯南 : > hi,all： > I want to deploy apache kylin

Re: [jira] [Created] (KYLIN-2445) UI: select cube engine in "Advanced setting" page

check the label "*Fix Version/s:*" of this JIRA, its planinig for 2.0 branch 2017-02-14 7:49 GMT+01:00 rahulsingh : > In which version of Kylin this is applied? > > -- > View this message in context: http://apache-kylin.74782.x6. >

Re: about cube building?

about NodeJS, there is another open thread "Kylin with Node JS" http://apache-kylin.74782.x6.nabble.com/Kylin-with-Node-JS-td7180.html 2017-02-14 14:43 GMT+01:00 rahulsingh : > need some clarification. > > 1. Is there any kylin package for nodejs? > 2. Can we use

Re: about cube building?

The size isn't a problem thanks to HBase. See this cubes of TB works fine, and one project can hold several cubes ;) About the merge slowness I can't see any problem 2017-02-14 10:07 GMT+01:00 rahulsingh

Re: about cube building?

I cant see any error How many GB are per day? 2017-02-13 18:16 GMT+01:00 rahulsingh : > Yes, it is a full date in the format of -MM-DD > > -- > View this message in context: http://apache-kylin.74782.x6. > nabble.com/about-cube-building-tp7181p7187.html > Sent from

Re: about cube building?

Merge segments in Kylin, means rebuild HBase region Is your partition Column a DaySlot ? 2017-02-13 15:30 GMT+01:00 rahulsingh : > Thank you for the solution. > > But I have already gone through this documentation. > Now my scenario is that i am building cube of 30 days

Re: Re: java.lang.RuntimeException:unexpectedevictreasonCOLLECTED

com>: > thx.But I rebuild the cube,it is scueessful.What happened? > > > > 446463...@qq.com > > From: Alberto Ramón > Date: 2017-02-12 17:34 > To: dev > Subject: Re: java.lang.RuntimeException:unexpectedevictreasonCOLLECTED > Exactly, this patch has been apply onl

Re: java.lang.RuntimeException:unexpectedevictreasonCOLLECTED

Exactly, this patch has been apply only to 2.0.0 (*"Fix Version/s:* v2.0.0" ) The actual version (1.6.0) don't have this commit and have this bug 2017-02-12 9:19 GMT+01:00 446463...@qq.com <446463...@qq.com>: > Hi all: > I

Re: Does kylin support the high-availability mode that uses multiple job instance: one active job instance and several backups in case it fails？

In 2.0, Kylin has full HA !! In 1.X has close to HA - it has HA to run your queries - it doesn't have HA to calculate cubes Check this : you can have 'n' queries nodes (to solve node) and use a Load Balancer to distribute the load

Query error on ODBC

About KYLIN-2274 The problem is this query run on OLEDB but doesn't on ODBC *"Select * from Table where 1=2"* *"ERROR: SQLColAttribute unknown attr, ColNum: 1"* This query is used to return column names (read metadata) and works fine on

Re: Getting this exception at step 18 Build Cube

you Can try: - add dim by dim, to find which column have a problem - Start use dicionary encoding and if work use integer or other and then: - Check all FK of Fact table are on Dim - Check dont have duplicates PK on Dim 2017-02-07 8:35 GMT+01:00 rahulsingh : >

Re: Getting this exception at step 18 Build Cube

What is your Kylin version? There was some bug with old version KYLIN-1834 and KYLIN-1934 Can you check if some of your Dim Data have unusual data ? can you try using diccitionary encoded ?

Re: Hive and Kylin synchronization

no, isn't sync you can sync metadata from Model > Data Source, > Arrow> Sync Changes in metadata may involve a invalid data model 2017-02-02 5:53 GMT+01:00 rahulsingh : > how kylin tables are synchronized with hive. if we drop table from hive > then > what would

Qlik

It's in Spanish, but the picture is very clear https://www.linkedin.com/pulse/qlik-cloudera-bigdatasmartdataanalytics-felipe-trigo?trk=hp-feed-article-title-publish

Re: New document: "How to optimize cube build"

Be careful about partition by "FLIGHTDATE" >From https://github.com/albertoRamon/Kylin/tree/master/KylinPerformance *"Option 1: Use id_date as partition column on Hive table. This have a big problem: the Hive metastore is meant for few hundred of partitions not thousand (Hive 9452 there is an

Re: hbase Very high read or write request count in a single RegionServer

The solution of Li Yand works works from CDH 5.4, but If your production env is HBase 1.2, dreaming is free ;) , you can also try: https://issues.apache.org/jira/browse/HBASE-10070 2017-01-25 5:52 GMT+01:00 Li Yang : > Try google 'hbase read replica'. > > Cheers > > On

Re: Aggregation with calculation

This will explain the solution: http://apache-kylin.74782.x6.nabble.com/Derived-measures-in-Kylin-td5513.html 2017-01-09 10:27 GMT+01:00 steelspace : > Hello, > > I am aware that Kylin supports only one measure per cube. What I need is to > calculate aggregation in the

Re: When kylin.job.run.as.remote.cmd=true, all hadoop、hive、hbase commands can be in remote cluster?

il.com%3E> 2.9.0) 2017-01-05 10:22 GMT+01:00 Alberto Ramón <a.ramonporto...@gmail.com>: > Upppsss, > Some times JAR Client and Server are the same file, (this is a performance > problem) > This can be a problem with docker, a lot of dependencies and program > runing, br

Re: When kylin.job.run.as.remote.cmd=true, all hadoop、hive、hbase commands can be in remote cluster?

eng...@apache.org>: > No necessary be hadoop nodes; The only thing is the node that running Kylin > should have hadoop/hive/hbase clients installed and configured. Docker > container is okay if it matches this. > > 2017-01-04 23:00 GMT+08:00 Alberto Ramón <a.ramonporto...@gmail.c

Re: When kylin.job.run.as.remote.cmd=true, all hadoop、hive、hbase commands can be in remote cluster?

ent machine. > Using a jumpbox is not recommended and may not work, the only scenario > is for development. > > > 2017-01-04 17:14 GMT+08:00 Alberto Ramón <a.ramonporto...@gmail.com>: > > > is it the same remote mode than cluster mode ? > > <http://kylin.

Re: When kylin.job.run.as.remote.cmd=true, all hadoop、hive、hbase commands can be in remote cluster?

is it the same remote mode than cluster mode ? 2017-01-04 9:35 GMT+01:00 ShaoFeng Shi : > Hi Lei, > > The remote mode is not recommended and not supported in real deployment. > (we only use it in dev

Re: [jira] [Created] (KYLIN-2355) kylin cube build is failing at #3 Step Name: Extract Fact Table Distinct Columns

See : Kylin 2326 MailList 2017-01-04 9:35

Re: Kylin Performance

About Kylin performance, I completed some uses cases: https://github.com/albertoRamon/Kylin/tree/master/KylinPerformance Any contribution or correction will be appreciated BR, Alb 2016-12-28 11:32 GMT+01:00 Alberto Ramón <a.ramonporto...@gmail.com>: > Don`t worry, I'm going to com

Re: docker version of apache kylin 1.6.0

You can use my docker image ( https://github.com/albertoRamon/Kylin/tree/master/KylinWithDocker) It runs OK, and uses Kylin 1.6.0 Notes about install, upgrade, problems, start/stop ( https://github.com/albertoRamon/Kylin/blob/master/KylinWithDocker/Readme_ARP.txt ) Also kyligence people have

Re: Kylin Performance

Don`t worry, I'm going to completed my KylinPerformace_I.pdf with new tests and some notes 2016-12-28 11:19 GMT+01:00 ShaoFeng Shi <shaofeng...@apache.org>: > Alberto, the image can not be displayed :-< > > 2016-12-28 2:39 GMT+08:00 Alberto Ramón <a.ramonporto...@gmail.c

Re: Kylin Performance

fact table, count and > redistribute on it will be low-cost; In next version there will be a > further optimization (https://issues.apache.org/jira/browse/KYLIN-2165) to > reduce the time in this step. > > > 2016-12-27 1:20 GMT+08:00 Alberto Ramón <a.ramonporto...@gmail.com>: >

Re: [jira] [Created] (KYLIN-2324) Kylin web hang with no error after query

sounds like, HBase / Region server is stop / dead and cant read Kylin metadata can you test if this is the reason ? start region server should be work OK 2016-12-27 4:18 GMT+01:00 hoangle (JIRA) : > hoangle created KYLIN-2324: > -- > >

Re: Kylin Performance

tarSchemaB.PDF > - https://github.com/hortonworks/hive-testbench > > > Cheers > Yang > > On Wed, Dec 21, 2016 at 8:45 PM, Alberto Ramón <a.ramonporto...@gmail.com> > wrote: > > > When Kylin 2149 <https://issues.apache.org/jira/browse/KYLIN-2149> will > be >

Re: Kylin Performance

When Kylin 2149 will be solved the performance will be* improve even more*, because: you know that 2016-05-05 Belongs to May, Week 18, and friday , but kylin doesnt know it It will try to calulate the combination of 2016-05-05 with January

Re: Kylin Performance

t to compare hive parition/non-partition, suggest you find a > bigger fact table, e.g 5 or 10 million rows; > > 2016-12-21 17:53 GMT+08:00 Alberto Ramón <a.ramonporto...@gmail.com>: > > > I attached as PDF, ... I don't know it this is forbidden in MailList > > > >

Kylin Performance

I made a small tech notes about my performance tests, the doc is unfinished (I need more time, test and knowledge) Review my English mistakes is pending If somebody have any comment, test, more experience , ... feel free make any suggestion Alb

Re: Re: Create Aggr Func(SUM,MIN,MAX) For Every Measure

yes, Nowadays, I'm doing a performance testing creating a lot of cubes, changing configuration of dimensions to evaluate their impact on building time and size of cube I'm bored of Create Cube Wizard :(, a lot of clicks !! Some small changes: * Default names of columns. I think this will be

Re: Can kylin intermediate tables in hive be deleted ?

You will need execute cleanUp Storage Can be made with Kylin Online? Yes In this mailList you will find extra info 2016-12-13 10:14 GMT+01:00 Luke_Selina

Re: kylin 1.6.0 cardinality can't greater than 5000000 ?

Humm, you can try this: With Kylin 1705 you can use Global dictionary Builder, which support 2 Billons of values (versus previous dic 5 Millons) In Teorical you can migrate from old dics (Kylin 1775

Re: select * clause still case all regionserver crash

:) We have some similiar problem with non-IT "Why do you want a result table of 1 Millon of rows ¿? " I don't Know any solution. The Q is: this is a problem/bug/issue of Kylin ? I think NO, the target of this is protect to coprocesor (is mandatory) Select * is not addecuate for Kylin

Re: select * clause still case all regionserver crash

About select * from :Kylin 1792 v1.5.3 Can you check if you see this error: "*Scan row count exceeded threshold: 100, please add filter condition to narrow down backend scan range, like where clause*" With Queries like this:

Re: select * clause still case all regionserver crash

Sounds like: KYLIN-1787 MailList MailList

Re: Consulting "EXTENDED_COLUMN"

This will help you http://kylin.apache.org/docs/howto/howto_optimize_cubes.html The idea is always, How I can reduce the number of Dimension ? If you reduce Dim, the time / resources to build the cube and final size of it decrease --> Its good An example can be DIM_Persons: Id_Person , Name,

Re: Apache Kylin 1.6.0 released

Heyyy, :) There is a new version of Kylin ODBC Driver ¡¡ [image: Imágenes integradas 1] I will testing with PowerBI (Last nigth I tried Kylin 1.6.0 & Driver 1.5 with PowerBI and failed) 2016-11-28 8:01 GMT+01:00 ShaoFeng Shi : > The Apache Kylin team is pleased to

Re: use RESTful API to create cube and model

check this: http://mail-archives.apache.org/mod_mbox/kylin-user/201609.mbox/%3C9EEA4677F012024598DC5D7E4D11FD53886EEAAE%40QTAUSC-VPEXC001.quantium.com.au.local%3E 2016-11-11 11:29 GMT+01:00 wang...@snqu.com : > Can use RESTful API to create cube and model? > In RESTful API

Re: how to refresh cube automatically in kylin 1.5.4.1

You have 2 options: SOL1: Rest Full API See this example SOL2: Kylin Client Tool with Python +

Re: [REPORT] Kylin - November 2016

Is There any Youtube channel with all Videos ? I cant find any 2016-11-08 0:24 GMT+01:00 Luke Han : > ## Description: > === > Apache Kylin is an open source Distributed Analytics Engine designed > to provide SQL interface and multi-dimensional analysis (OLAP) on >

Re: Cube Designer, In TOP_N Expression, the choice of SUM|ORDER BY Column and Group By Column are all measures column

Hello Now there are some bugs actives in UI with TopN: KYLIN-2024 KYLIN-2097 But for SUM you will need choose an Aggr Column 2016-11-07 7:28 GMT+01:00 张磊 <121762...@qq.com>: > Hi > When i

Re: http://127.0.0.1/kylin is giving 404, using HDP 2.5

And Check this file: /usr/local/apache-kylin-1.5.2.1-bin/logs/kylin.log 2016-11-03 12:49 GMT+01:00 Alberto Ramón <a.ramonporto...@gmail.com>: > Ideas: > - can you use a Web broser in your Virtual Box Machine? to discard network > problems > > - Try: kylin.sh stop and kyl

Re: [jira] [Created] (KYLIN-2154) source table rows will be skipped if TOPN's group column contains NULL values

2 by the price of 1 ? KYLIN-2049 2016-11-02 15:26 GMT+01:00 hongbin ma (JIRA) : > hongbin ma created KYLIN-2154: > - > > Summary: source table rows will be skipped if TOPN's group > column contains NULL values >

Re: Exceed scan threshold at 10000001

le KYLIN_78ROC49NQY > > > > > > > > > > -- 原始邮件 -- > > 发件人: "ShaoFeng Shi";<shaofeng...@apache.org>; > > 发送时间: 2016年10月28日(星期五) 中午11:20 > > 收件人: "dev"<dev@kylin.apache.org>; >

Re: Exceed scan threshold at 10000001

he number of the all groups > > threshold > > > > > ------ 原始邮件 -- > 发件人: "Alberto Ramón";<a.ramonporto...@gmail.com>; > 发送时间: 2016年10月27日(星期四) 下午5:47 > 收件人: "dev"<dev@kylin.apache.org>; > > 主题: Re: Exceed

Re: [jira] [Created] (KYLIN-2132) Unable to pull data from Kylin Cube ( learn_kylin cube ) to Excel or Power BI for Visualization and some dimensions are not showing up.

Duplicated KYLIN-2121 ?? Dev MailList 2016-10-27 8:42 GMT+02:00 Bhanuprakash (JIRA)

  1   2   >