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

2018-10-16 Thread Alberto Ramón
> 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 支持的一个数据源

2018-10-16 Thread Alberto Ramón
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: Can I build an hierarchy aggregation group with joint dimensions

2018-09-20 Thread Alberto Ramón
https://issues.apache.org/jira/browse/KYLIN-2149 On Thu, 20 Sep 2018 at 05:52, you Zhuang wrote: > Example: (aid,aname),(bid,bname),(cid,cname). The three joint dimensions > are also hierarchical .

Re: #3 Step Name: Extract Fact Table Distinct Columns (slow)

2018-03-14 Thread Alberto Ramón
is properly configured. we use many other m/r and spark programs >> that utilize the full slots. It's only when building cubes. >> >> On Wed, Mar 14, 2018 at 9:46 AM, Alberto Ramón <a.ramonporto...@gmail.com >> > wrote: >> >>> You need check your yarn

Re: #3 Step Name: Extract Fact Table Distinct Columns (slow)

2018-03-14 Thread Alberto Ramón
You need check your yarn configuration first On Wed, 14 Mar 2018, 14:58 Sonny Heer, wrote: > Step 3 isn't using our full cluster. How can i increase the > mappers/reducers to use all the slots? Any config to look at in kylin? > > Thanks >

Re: RAW Measure kylin 2.3

2018-03-06 Thread Alberto Ramón
>From this mailList: questions about 'RAW' measures MailList : Kylin 3062 v2.3 Propose to disable RAW from UI On 6 Mar 2018 1:38 p.m., "deva

Re: Get daily average for periodic readings

2018-03-01 Thread Alberto Ramón
its for one item. for 20 Million items it will > multiply by a lot. Do you think it wont make much differnce? > Also what is YY-MM-WW ? so I can explain you? Basically I need same > avg() for week, month, year, etc. > > Thanks > Deva > > On Thu, Mar 1, 2018 at 8:42 AM,

Re: Get daily average for periodic readings

2018-03-01 Thread Alberto Ramón
gt; On Wed, Feb 28, 2018 at 5:51 PM, Alberto Ramón <a.ramonporto...@gmail.com> > wrote: > >> Sounds like: >> - your minimum granularity for queries are on Weeks, your fact table need >> be on weeks (or less, like days) >> - you will need expand you actual fa

Re: Questions about 'RAW' measure

2018-03-01 Thread Alberto Ramón
ta > inside ? Is it a conceivable way of doing (in terms of space storage, > efficiency) or is it preferable to use separate tables foe dimensions and > why ? > > > > Thank you in advance for your help. > > Have a good day. > > > > Best regards, > > Jean

Re: Get daily average for periodic readings

2018-02-28 Thread Alberto Ramón
Sounds like: - your minimum granularity for queries are on Weeks, your fact table need be on weeks (or less, like days) - you will need expand you actual fact table to weeks (or more, days) Example use a hive view - as extra: Kylin can't use partition format columns on weeks, the minimum es days

Re: Questions about 'RAW' measure

2018-02-28 Thread Alberto Ramón
Hello - RAW format are deprecated. You will find the thread in this MailList - "Job hasn't been submitted after" sound a configuration problem with your YARN, please find it on Google and review your CPU and RAM resources On 28 February 2018 at 16:44, BELLIER Jean-luc <

RE: Optimize Cube Build process

2018-02-01 Thread Alberto Ramón
How many process are you runing in parallel? In build cube step On 1 Feb 2018 7:39 a.m., "Kumar, Manoj H" <manoj.h.ku...@jpmorgan.com> wrote: > We have 15 nodes & each nodes have 8 cores. RAM= 256 MB. > > > > I don’t think memory is issue here. > > >

Re: Optimize Cube Build process

2018-01-31 Thread Alberto Ramón
How many nodes do you have? how many RAM and CPU do you have per node? On 31 January 2018 at 05:07, Kumar, Manoj H wrote: > It has close to 68 mapper & reducers 500.. It keeps running on this. Pls. > advise. > > > > Regards, > > Manoj > > > > *From:* Kumar, Manoj H >

Re: segment size estimate when merging

2018-01-27 Thread Alberto Ramón
Could be this related? KYLIN-2779 , this JIRA have a lot of sense On 24 January 2018 at 13:43, ShaoFeng Shi wrote: > Hi Qilong, > > If seg A's estimation size is 10 GB, but real size is 5 GB; then when > merge or build

Re: MDX queries on kylin cubes.

2018-01-24 Thread Alberto Ramón
You can check this Q in older mail List. You must think that Apache Kylin has been designed to use SQL as language (Use Apache Calcite to do it) Either way, if you want use MDX: E xcel using Mondrian Mondrian

Re: #20 Step Name: Load HFile to HBase Table failed

2018-01-22 Thread Alberto Ramón
You created HFiles, but Kylin don't have permissions to execute CompleteBulkLoad Its a typical issue on this mail-list, check permission of user that start Kylin service On 22 January 2018 at 09:14, Neters wrote: > Hello guys: > > I have some problem when the program access

Re: Re: kylin前端业务查询问题

2018-01-21 Thread Alberto Ramón
could you check these notes, too: To use, kylin.query.timeout-seconds, you will need Kylin 2.0 https://issues.apache.org/jira/browse/KYLIN-2847 (v2.4) https://issues.apache.org/jira/browse/KYLIN-3157 (open) 2018-01-17 5:15 GMT+00:00 杨浩 : > The conf of

Re: flat table stored as parquet

2017-12-29 Thread Alberto Ramón
Could you check this: Kylin 3070 v2.3 On 29 December 2017 at 22:22, Ruslan Dautkhanov wrote: > Is there is a knob I can set to tell Kylin to create flat table > as Parquet and not as default 'text' serialization? > I mean

Doubt Kylin 2363

2017-12-09 Thread Alberto Ramón
KYLIN-3067 If you put dim_cap=3 and Dim are A,B,C,D And you lunch a query . . . Group by A,B,C,D, how is this Q resolved? is Base Cuboid is A,B,C,D? Internal Cuboids are deleted after used? BR, Alb

Re: availableVirtualCores

2017-11-29 Thread Alberto Ramón
N_HOME}/logs/cluster.info" "*yarn_available_cores=`getValueByKey availableVirtualCores ${saveFileName}`*" On 28 November 2017 at 01:36, Li Yang <liy...@apache.org> wrote: > Where do you see -- Cluster.info: 'availableVirtualCores=3'?? > > Cannot recognize it. > >

availableVirtualCores

2017-11-24 Thread Alberto Ramón
Hello >From Ambari, the number of virtual cores is 4: [image: Inline images 1] But in the file Cluster.info: 'availableVirtualCores=3' (RAM is correct) I don't know from where Kylin read this config

Re: Can hierarchyDims contain jointDims

2017-11-17 Thread Alberto Ramón
https://issues.apache.org/jira/browse/KYLIN-2149 Check this link, you need choose between use one or other Some times would be great use both together On 17 November 2017 at 06:43, doom <43535...@qq.com> wrote: > So what's the second code segment mean in AggregationGroup build step? > is it

Kylin and SuperSet

2017-09-12 Thread Alberto Ramón
Hi Will be an official support of Apache Kylin on Apache SuperSet?

Re: Some questions about Kylin2.0

2017-06-13 Thread Alberto Ramón
Q1:Kylin 2633 The actual version of spark is 1.6.3 (in Kylin 2.0.0) On 13 June 2017 at 04:41, lxw wrote: > Hi,All : > >I have some questions about Kylin2.0, and my environment: > hadoop-2.6.0-cdh5.8.3 >

Re: Why in the Convert Cuboid Data to HFile step to start too many maps and reduces

2017-05-27 Thread Alberto Ramón
Sounds like a YARN configuration problem Parallelize is good :), not all Map / reduces are executed at same times Check some configurations like: - yarn.nodemanager.resource.memory-mb per node - yarn.nodemanager.resource.cpu-vcores per node This can help you to start:

Re: Cannot install Kylin on CDH 5.11 CentOS 7

2017-05-22 Thread Alberto Ramón
Java recomended (I dont know if mandatory) is 1.7 https://kylin.apache.org/docs20/install/hadoop_env.html On 22 May 2017 at 22:59, Szalai Gergely wrote: > Hi All, > > We have a blocking issue by installing Kylin on CDH 5.11. By executing > such lines on CentOS 7 we always

Re: How to apply historical Updates to existing cube data

2017-05-11 Thread Alberto Ramón
Q1- Check this previous mailList about late data: http://apache-kylin.74782.x6.nabble.com/Reloading-data-td5669.html You only will need recalculate segments involved Q2- Check Shardin (https://issues.apache.org/jira/browse/KYLIN-1453) Partition by time column is not reoomended (It Will create

Re: 答复: kylin nonsupport Multi-value dimensions?

2017-05-10 Thread Alberto Ramón
_sales it report that error: Dup key found. How can I solve it ? *发件人:* Alberto Ramón [mailto:a.ramonporto...@gmail.com] *发送时间:* 2017年5月10日 15:29 *收件人:* user <user@kylin.apache.org> *主题:* Re: kylin nonsupport Multi-value dimensions? Hi, Not all hive types are supported Check this lin

Re: kylin nonsupport Multi-value dimensions?

2017-05-10 Thread Alberto Ramón
Hi, Not all hive types are supported Check this lines: https://github.com/apache/kylin/blob/5d4982e247a2172d97d44c85309cef4b3dbfce09/core-metadata/src/main/java/org/apache/kylin/dimension/DimensionEncodingFactory.java#L76 On 10 May 2017 at 08:10, jianhui.yi wrote: > I

Re: [Announce] New Apache Kylin committer Zhixiong Chen

2017-04-29 Thread Alberto Ramón
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: The coprocessor thread stopped itself due to scan timeout or scan threshold

2017-03-18 Thread Alberto Ramón
For the new version , check this: https://issues.apache.org/jira/browse/KYLIN-2438 but keep in mind, that these limits exists to protect HBase coprocesor and it you query is to slow ... pehapt you need re-design the cube BR 2017-03-18 8:13 GMT+00:00 java_prog...@aliyun.com

Re: kylin job stop accidentally and can resume success!

2017-02-13 Thread Alberto Ramón
ntainer Memory Increment =512MiB > > Container Memory Maximum =8GiB > > -- 原始邮件 -- > *发件人:* "Alberto Ramón";<a.ramonporto...@gmail.com>; > *发送时间:* 2017年2月14日(星期二) 凌晨0:34 > *收件人:* "user"<user@kylin.apache.org>; > *主题:*

Re: kylin job stop accidentally and can resume success!

2017-02-13 Thread Alberto Ramón
a dedicated node) 2017-02-13 17:19 GMT+01:00 不清 <452652...@qq.com>: > how can i get this heap size? > > > -- 原始邮件 ------ > *发件人:* "Alberto Ramón";<a.ramonporto...@gmail.com>; > *发送时间:* 2017年2月14日(星期二) 凌晨0:17 > *收件人:

Re: kylin job stop accidentally and can resume success!

2017-02-13 Thread Alberto Ramón
Sounds like a problem of Resource Manager (RM) of YARN, check the Heap size for RM Kylin loose connectivity whit RM 2017-02-13 17:00 GMT+01:00 不清 <452652...@qq.com>: > hello,kylin community! > > sometimes my jobs stop accidenttly.It is can stop by any step. > > kylin log is like : > 2017-02-13

Re: 求助有一个超大维度

2017-02-13 Thread Alberto Ramón
ut for error B,should I fix this problem for whole hadoop cluster? Can > you speak the parameter fix in detail? > > This really helped us a lot! > > > ------ 原始邮件 -- > *发件人:* "Alberto Ramón";<a.ramonporto...@gmail.com>; > *发送时间:* 2017年2月13日(

Re: 求助有一个超大维度

2017-02-12 Thread Alberto Ramón
Hello 不清 >From your errors: "Failed to build cube in mapper " & A- "java.lang.OutOfMemoryError: Java heap space at java" & B- "java.lang.OutOfMemoryError: GC overhead limit" For error A:Check override this parameters from kylin: *

Re: create dictionary error

2017-02-10 Thread Alberto Ramón
Hi, Move this thread to User mailList SALE_ORD_ID is not a dim of cube, but isit a PK-FK ? I think yes :) Are you using DERIVED Dims in this table ? See this

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

2017-01-25 Thread Alberto Ramón
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: Jekyll

2017-01-23 Thread Alberto Ramón
the error was, I had two versions of "jekyll-multiple-language" 2017-01-23 20:26 GMT+01:00 Alberto Ramón <a.ramonporto...@gmail.com>: > I'm trying to add new doc to apache kylin > > > jekyll 2.5.3 | Error: undefined method `post_read' for class > `Jekyll::Docume

Jekyll

2017-01-23 Thread Alberto Ramón
I'm trying to add new doc to apache kylin jekyll 2.5.3 | Error: undefined method `post_read' for class `Jekyll::Document' And this is true: https://github.com/jekyll/jekyll/blob/master/lib/jekyll/document.rb I used: git init git clone -b document --single-branch

Re: Kylin and BI Tools

2017-01-18 Thread Alberto Ramón
Hello, https://github.com/albertoRamon/Kylin/tree/master/KylinWithMain *Changes*: - Fixed Carabel to Caravel - Added Zeppelin Reference - Added Apache Flink Thanks for all !! 2017-01-17 9:28 GMT+01:00 Alberto Ramón <a.ramonporto...@gmail.com>: > Thanks Anton > I will complete/f

Re: Problem with limit and joint aggregation

2017-01-17 Thread Alberto Ramón
Joint must be used for: - Group Dims with *very *low cardinality, Example: IdCurrency (most of bank's transactions uses < 10 currencies) - You Have columns with same cardinality: Country_ID and Contry_txt Check TopN feature of Kylin to precalcualte sum order by You can allocate more memory to

Re: Kylin and BI Tools

2017-01-17 Thread Alberto Ramón
run commands. > > > *From:* Alberto Ramón [mailto:a.ramonporto...@gmail.com] > *Sent:* Tuesday, 17 January 2017 01:49 > *To:* user <user@kylin.apache.org> > *Subject:* Re: Kylin and BI Tools > > > > Somebody has been tested this with last versions of Kylin?:

Re:

2017-01-17 Thread Alberto Ramón
RDER BY performance goes down when Total Scan Count is big. So how can i > improve this problem? > Thanks > > > 2017-01-16 18:45 GMT+07:00 Alberto Ramón <a.ramonporto...@gmail.com>: > >> Hi Phon, I'm not expert but I have some suggestions: >> >> - All Dim

Re: Kylin and BI Tools

2017-01-16 Thread Alberto Ramón
01-16 9:37 GMT+01:00 Jian Zhong <zhongj...@apache.org>: > very good document. > > I see "Kylin Carabel" section, maybe need to update to "Kylin Caravel" > > Thanks > > On Sun, Jan 1, 2017 at 6:53 AM, Alberto Ramón <a.ramonporto...@gmail.com> >

Re: Kylin and BI Tools

2016-12-31 Thread Alberto Ramón
ng) Liu < >> liuyiming@gmail.com> wrote: >> >>> So cool, impressive. Thank you, Alberto. >>> >>> 2016-09-19 21:42 GMT+08:00 Alberto Ramón <a.ramonporto...@gmail.com>: >>> >>>> Hello >>>> >>>> This is t

Re: kylin query with case return error result

2016-12-27 Thread Alberto Ramón
See calcite syntaxis I think isnt allowed: Agg ( distinct case) You can try with: Agg ( distinct value) 2016-12-27 9:41 GMT+01:00 Billy Liu : > When you talk about mismatch result, you'd better provide the

Re: ArrayIndexOutOfBoundsException: -1

2016-12-26 Thread Alberto Ramón
you can define the same column from Fact Table as Dim and as Measure Is this the desired behavior ?? Open JIRA ?? 2016-12-23 0:44 GMT+01:00 Alberto Ramón <a.ramonporto...@gmail.com>: > > Error on, Extract Fact Table Distinct Columns > > > > > * Insane record:

ArrayIndexOutOfBoundsException: -1

2016-12-22 Thread Alberto Ramón
Error on, Extract Fact Table Distinct Columns * Insane record: [1, 0600-160077, FVP DAFUTURO - ESTABLE, COP, 11, 11, Tipo de producto 11, 16.94579786] java.lang.ArrayIndexOutOfBoundsException: -1 at

Re: Joint and Order in RowKey

2016-12-21 Thread Alberto Ramón
gt; On Tue, Dec 20, 2016 at 2:46 AM, Alberto Ramón <a.ramonporto...@gmail.com> > wrote: > >> If we have these columns: >> [image: Imágenes integradas 1] >> >> With There Joints: >> [image: Imágenes integradas 3] >> >> *Why I cant order these columns

Re: if can add where clause to a measure?

2016-12-20 Thread Alberto Ramón
I never use, but Kylin 976 can be useful for you 2016-12-21 8:14 GMT+01:00 ZhouJie : > hi, everyone > i want to know if kylin can filter a column which has been measured, as > follows: > select sum(price) from hotprice_copy1

Re: How to workaround with columns with NULL value?

2016-12-20 Thread Alberto Ramón
about 1º point: In Kylin 2049 there is a commet of Shaofeng SHI 2016-12-21 6:32

Re: Error when #2 Step: Redistribute Flat Hive Table - File does not exist

2016-12-19 Thread Alberto Ramón
; === > the follow command runs ok: > hdfs dfs -mkdir /young/kylin_test/kylin_metadata_nokia/ > kylin-678c15ba-5375-4f80-831e-1ae0af8ed576/row_count/tmp > And "ls" cant find file "00_0" which it said "file does not exist". > > -- 原

Joint and Order in RowKey

2016-12-19 Thread Alberto Ramón
If we have these columns: [image: Imágenes integradas 1] With There Joints: [image: Imágenes integradas 3] *Why I cant order these columns individually?* (Text , Id) now must be a tupple [image: Imágenes integradas 4] (I accept suggestion about order, anyo=year)

Re: Error when #2 Step: Redistribute Flat Hive Table - File does not exist

2016-12-19 Thread Alberto Ramón
i think i had this error last nigth :) (go to yarn to find detailed error & find on internet) in my case was free space less than 10% of hard disk. Check this please El 19/12/2016 11:35, "雨日听风" <491245...@qq.com> escribió: > When I build a cube in kylin1.6, I get error in step #2: Redistribute

Relocate SQL Query ?

2016-12-12 Thread Alberto Ramón
Hello I understand (from my point of view) that SQL TAB can be better under Data model and not under Cube Cube tabs: [image: Imágenes integradas 1] Data Model Tabs: [image: Imágenes integradas 2]

Re: Cut Size

2016-12-12 Thread Alberto Ramón
;https://issues.apache.org/jira/browse/KYLIN-1669>)? > --> Yes, that marker has been removed; Will use same split configuration > for all cubes; If user want to customize, he can overwrite the config > values at cube level. > > 2016-12-08 21:27 GMT+08:00 Alberto Ramón <a.ramo

Use derived or Joint

2016-12-08 Thread Alberto Ramón
Typical case 1: *IDDate* *Month_ID* *Month_Txt* *DayWeek_ID* *DayWeek_Txt* *Year* 2016-03-01 3 March 2 Wendesday 2016 2016-03-02 3 March 3 Thursday 2016 2016-03-02 3 March 4 Friday 2016 IDDate is PK of Dim table and Unique SOL 1: Uses Hierarchy and Derived from non PK

Re: Consulting "EXTENDED_COLUMN"

2016-12-02 Thread Alberto Ramón
yes, I will asume this overhead in rowKey 2016-12-02 9:58 GMT+01:00 Billy(Yiming) Liu <liuyiming@gmail.com>: > Using Joint Dimension for your 1:1 relation is the right design. > > 2016-12-02 0:21 GMT+08:00 Alberto Ramón <a.ramonporto...@gmail.com>: > >> Nice Liu

Re: corrupt metastore

2016-12-01 Thread Alberto Ramón
nds to do this I saw metadata.sh script, but I cant find this functionality 2016-12-02 2:46 GMT+01:00 ShaoFeng Shi <shaofeng...@apache.org>: > Hi Alberto, It looks like the HBase service is in trouble, please check it > firstly; > > 2016-12-02 8:03 GMT+08:00 Alberto Ramón <a

Re: Consulting "EXTENDED_COLUMN"

2016-12-01 Thread Alberto Ramón
16-12-01 17:07 GMT+08:00 Alberto Ramón <a.ramonporto...@gmail.com>: > >> Hello >> I was preparing a email with related doubts: >> >> Some times we have derived dimensions with relation 1:1, examples: >> WeekDayID & WeekDayTxt >> MonthID & Week

Re: User MailList

2016-12-01 Thread Alberto Ramón
Nice ¡¡ Will be very helpfull to find similar problems 2016-12-01 13:31 GMT+01:00 Luke Han <luke...@gmail.com>: > already working on that > > Get Outlook for iOS <https://aka.ms/o0ukef> > > > > > On Thu, Dec 1, 2016 at 5:15 PM +0800, "Alberto Ra

Re: ODBC 1.6

2016-11-28 Thread Alberto Ramón
nks very much for your feedback. > > There're some packaging issues in previous build. We've uploaded a new > build. > Please go to download page and find the latest ODBC Drive 1.6. Thanks. > > Thanks, > Dong Li > > Thanks, > Dong Li > > 2016-11-28 22:28 GMT+08:00 Alber

Re: ODBC 1.6

2016-11-28 Thread Alberto Ramón
x64, all system are 64 bits (win 7 ultimate, and Win Server 2008 R2) 2016-11-28 14:58 GMT+01:00 ShaoFeng Shi <shaofeng...@apache.org>: > Hi Alberto, Kylin ODBC zip has two exe files; which one are you > installing, the x86 one or x64 one? > > 2016-11-28 21:51 GMT+0

ODBC 1.6

2016-11-28 Thread Alberto Ramón
Hello I'm try to test New Kylin ODBC Driver 1.6, When I try to create New ODBC, I have this error [image: Imágenes integradas 1] (I tested In two Win7 SP1, I didn't have problems with 1.5) The dependencies of Ms Visual C++ are the same than old version? (C++ 2012) Also saw the Version

Re: Codec of decimal (10,6)

2016-11-26 Thread Alberto Ramón
such query from the base > cuboid (group by all dimensions). The measure column value will be the > aggregated value; So user could not directly compare the "select *" result > from a cube with the source data. If you're comparing the aggregated > queries, I believe they are tot

Re: Testing 1.6

2016-11-26 Thread Alberto Ramón
e for 1.6.0 has been updated in > https://kylin.apache.org/docs16/howto/howto_upgrade.html , FYI > > 2016-11-26 19:36 GMT+08:00 Alberto Ramón <a.ramonporto...@gmail.com>: > >> I'm re-testing auto refreshing Job Progress , and not work in my case. >> I used Firefox and

Codec of decimal (10,6)

2016-11-25 Thread Alberto Ramón
I have a super-Fact Table with 5 rows [image: Imágenes integradas 2] A- Data in CSV == Hive (OK) B- Select * from Fact, in Kylin some values are different The value 9942758, has been transformed in 10937033.8 !!!

Re: Release apache-kylin-1.6.0 (RC2)

2016-11-24 Thread Alberto Ramón
git repository. Please note, to build a binary package, need > install maven, npm and grunt at first. > > 2016-11-24 5:39 GMT+08:00 Alberto Ramón <a.ramonporto...@gmail.com>: > >> My vote = Null (I'm rookie) >> >> 1 - Using: https://dist.apache.org/repos/dist/

Testing 1.6

2016-11-15 Thread Alberto Ramón
Hi - When you are building Cube, the web is not auto-refresh of Web page, was there the old behavior of older versions ? (I use Chrome) - There isn't doc about migration from Old Version

IN_THRESHOLD

2016-11-15 Thread Alberto Ramón
About Kylin 2193 What is the poupose of org.apache.kylin.storage.translate.DerivedFilterTranslator# IN_THRESHOLD ? :) (when is used?)

Re: 答复: Most Used BI Tools

2016-11-07 Thread Alberto Ramón
; *主题:* Re: Most Used BI Tools > > > > nice stuff! > > > > On Mon, Nov 7, 2016 at 1:09 AM, Alberto Ramón <a.ramonporto...@gmail.com> > wrote: > > fyi: > > https://image-store.slidesharecdn.com/0d3c9706- > b8a6-4716-afc1-26beb82c8704-large.png > > > > > > -- > > Regards, > > > *Bin Mahone | **马洪宾* >

Most Used BI Tools

2016-11-06 Thread Alberto Ramón
fyi: https://image-store.slidesharecdn.com/0d3c9706-b8a6-4716-afc1-26beb82c8704-large.png

Re: Kylin Dependencies

2016-11-02 Thread Alberto Ramón
kylin-docker > > From the docker file, you could find the kylin dependencies. > > 2016-11-02 22:46 GMT+08:00 Alberto Ramón <a.ramonporto...@gmail.com>: > >> With configs ... I can try it (Will be an interesting exercise for >> me) >> But libraries, ... >>

Re: Kylin Dependencies

2016-11-02 Thread Alberto Ramón
"minimal linux + Kylin" "to docker it" (The result must be few MB, < 150 MB) 2016-11-02 14:20 GMT+01:00 Li Yang <liy...@apache.org>: > Kylin needs Hadoop client library and configs, including hdfs, yarn, hive, > hbase. > > On Sun, Oct 30, 2016 at 1:42 AM,

Re: Kylin Version on UI

2016-11-02 Thread Alberto Ramón
jaja, Thanks ¡¡ +1 ;) 2016-11-02 14:22 GMT+01:00 Li Yang <liy...@apache.org>: > Yeah, there is a JIRA: KYLIN-1850 > <https://issues.apache.org/jira/browse/KYLIN-1850> > > Should be easy to do. Perhaps too easy to get attention. :-) > > On Sun, Oct 30,

Kylin Version on UI

2016-10-29 Thread Alberto Ramón
(Honestly, I'm using old Kylin version, I don't know if somebody do it in new version) Similar to Kylin 2096 Can be useful, put "Kylin version" on UI Exists ?

Kylin Dependencies

2016-10-29 Thread Alberto Ramón
Hi Target: All Kylin docker are VERY heavy !! (GB and hundred of process) ---> That Is Good for Develop / testing , but BAD Idea for production I'm trying to install Kylin on minimal linux, ideally Alpine or similar I have: - a clean install of linux (minimal Centos for example) , without

Read Apache Kylin from Apache Flink

2016-10-18 Thread Alberto Ramón
Hello I made a small contribution / manual about: *"How-to Read Apache Kylin data from Apache Flink With Scala" * For any suggestions, feel free to contact me Thanks, Alberto

Re: Question about future Kylin features and roapmap.

2016-10-04 Thread Alberto Ramón
10-04 8:38 GMT+02:00 Ashika Umanga Umagiliya <umanga@gmail.com>: > Sorry, > I meant "Snowflake schema" not "Star Schema" . Star Schema is already > supported. > > On Tue, Oct 4, 2016 at 3:24 PM, Alberto Ramón <a.ramonporto...@gmail.com> > wrot

Re: Question about future Kylin features and roapmap.

2016-10-04 Thread Alberto Ramón
1 - I think, no 2 - There isnt MDX support (Kylin 1525 & Kylin 776 ):For now you can use mondrian see this example

Re: support count or count distinct measure in multiple column topN

2016-09-24 Thread Alberto Ramón
KYLIN-1377 2016-09-24 9:25 GMT+02:00 ShaoFeng Shi : > It is possible, while with limited resource, we may not able to implement > it soon. If you'd like to contribute, that would be nice. > > 2016-09-19 9:43 GMT+08:00 赵天烁

Re: Error while building cube from stream

2016-09-20 Thread Alberto Ramón
I don't know but , can you check this change?: KYLIN-1744 in V1.3 2016-09-20 14:50 GMT+02:00 Tony Lee : > Hi, > > I was building cube from stream as the document(http://kylin.apache. > org/docs15/tutorial/cube_streaming.html

Kylin and BI Tools

2016-09-19 Thread Alberto Ramón
Hello This is the end of all my previous articles, about Kylin and differents tools With some successful and some failures :) https://github.com/albertoRamon/Kylin/tree/master/KylinWithMain If you have any comment / improvement, feel free to indicate me the changes A lot of thanks to the

Re: Use Apache HUE with Kylin

2016-09-18 Thread Alberto Ramón
2016-09-18 13:29 GMT+02:00 Luke Han <luke...@gmail.com>: > I see, maybe you should add your comments there to ask help from Hue > community > > > Best Regards! > - > > Luke Han > > On Sat, Sep 17, 2016 at 1:20 AM, Alberto Ramón <a.ram

Re: Use Apache HUE with Kylin

2016-09-16 Thread Alberto Ramón
box/%3CCAEcyM14%2BCKz5j7gJEMUVYCtdHFcmuWJKRMQPbisDQhW3G5Mc9Q%40mail.gmail.com%3E> ) 2016-09-16 18:00 GMT+02:00 Luke Han <luke...@gmail.com>: > Very nice! > > What's metadata bug? > > > Best Regards! > - > > Luke Han > > On Thu, Sep 8,

Re: Kylin ODBC

2016-09-14 Thread Alberto Ramón
ent over odbc, kylin server is expected to > send all the records as the output > > Please check the thread titled 'kylin cube performance' for more > information. > > Regards, > Abhilash > > On Wed, Sep 14, 2016 at 10:48 AM, Alberto Ramón <a.ramonporto...@gmai

Kylin ODBC

2016-09-13 Thread Alberto Ramón
Hello I tested New Microsoft Power BI with Kylin [image: Imágenes integradas 1] With KYLIN_CAL_DT connector can read data: [image: Imágenes integradas 2] But with KYLIN GROUPING AND SALES: And I have this error Unexpected error: *Value was either too large or too small for an Int32.* Details:

Re: Use Apache HUE with Kylin

2016-09-08 Thread Alberto Ramón
p at some point ;) BR, Alberto Ramón 2016-08-30 11:09 GMT+02:00 Luke Han <luke...@gmail.com>: > Thanks Alberto, your contribution will benefit many people:) > > > > > Best Regards! > - > > Luke Han > > On Mon, Aug 29, 2016 at 11:38 PM, Al

Re: Documentation on how data is stored

2016-09-06 Thread Alberto Ramón
+02:00 Something Something <mailinglist...@gmail.com>: > Hmm... that's a good start... but is there more info available somewhere? > Can you direct me to that PPT? Thanks. > > On Tue, Sep 6, 2016 at 12:16 AM, Alberto Ramón <a.ramonporto...@gmail.com> > wrote: > >&g

Re: Documentation on how data is stored

2016-09-06 Thread Alberto Ramón
I have this picture: (I found this info in a PPT) [image: Imágenes integradas 1] Remember that you can encode dim, by dictionarty or fix length 2016-09-06 1:57 GMT+02:00 Something Something : > Hello, > > Is there any documentation available on how Kylin stores data

Re: Metadata II

2016-09-05 Thread Alberto Ramón
s web GUI?​ > > On Mon, Sep 5, 2016 at 12:45 AM, Alberto Ramón <a.ramonporto...@gmail.com> > wrote: > >> Hello >> >> I'm testing Sisense Software <https://www.sisense.com/>, and saw similar >> integration-problem like with other vendors with "

Metadata II

2016-09-04 Thread Alberto Ramón
Hello I'm testing Sisense Software , and saw similar integration-problem like with other vendors with "get Metadata" This don't work: (Picture optional) [image: Imágenes integradas 1] select * from KYLIN_CAL_DT ==> OK select * from [KYLIN_CAL_DT] ==> Error:

Re: Use Apache HUE with Kylin

2016-08-29 Thread Alberto Ramón
@Luke Han: fell free to add where you want (I think the integration with HUE, will be very interested due to Notebooks, The people use it a lot in reports of BI or ML, with MarkDown ) About Kylin + Hue: - Hue 3.10 & 3.11, have the same issues. But in the next version ¿3.12? Will solve some

Use Apache HUE with Kylin

2016-08-27 Thread Alberto Ramón
Hello, I did a small manual, about How to querie Kylin on HUE https://github.com/albertoRamon/Kylin/tree/master/KylinWithHue For any suggestions/bug, *feel free to contact me* Thanks, Alberto

Re: Re: does kylin support top-N on a count or count distinct measure?

2016-08-09 Thread Alberto Ramón
>> >>>> *zhaotians...@meizu.com <zhaotians...@meizu.com>* >>>> >>>> >>>> >>>> 珠海市魅族科技有限公司 >>>> >>>> MEIZU Technology Co., Ltd. >>>> >>>> 广东省珠海市科技创新海岸魅族科技楼 >>>> >>>> ME

Re: Kylin Deploy in cluster mode failed!

2016-08-06 Thread Alberto Ramón
Hi Q1:In Doc put "Notice that only one server can run the job engine(“all” mode or “job” mode)" --> How many 'All' servers can you have? Q2: what is the diference betten: Query + Engine and Engine Q3: Is this automatic load balanced? BR, Alberto 2016-08-03 4:14 GMT+02:00 张天生

Re: Kylin auto refresh is not working

2016-07-28 Thread Alberto Ramón
Hi Interesting: https://issues.apache.org/jira/browse/KYLIN-1892 Thanks, Alberto 2016-07-28 8:28 GMT+02:00 ShaoFeng Shi : > yes you need trigger the build from outside; The simpliest way is using > Linux cron + curl comand; As that is quite easy to achieve, Kylin didn't

Save querie issue

2016-06-23 Thread Alberto Ramón
Hello I'm testing K 1.5.2.1 : Insight > Save querie Isn't working (do notihin, no errors) Somebody can check this issue in their systems? BR. Alberto