Save querie issue

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

Model Designer Dimensions

Hello In example "learn_kylin", table name "DEFAULT.KYLIN_CATEGORY_GROUPINGS" appears 2 times: [image: Imágenes integradas 1] But when I create the dataMode Using Wizard : [image: Imágenes integradas 2] Only appear 1 time :¿¿WHY?? (After, when I try to create CUBE, I can't add columns: C

Re: Model Designer Dimensions

t the model JSON file and restore >> the metadata back – that’s too hardcore J). >> >> >> >> Bets regards, Richard. >> >> >> >> *From:* Alberto Ramón [mailto:a.ramonporto...@gmail.com] >> *Sent:* Tuesday, June 28, 2016 1:55 PM >> *To:* user@kylin.a

Re: Can't connect to '7070/kylin'

Hello Punit I have this issue a lot of times, and always was the same problem: HBase is Down ¡¡ (Check it and Start & Stop) HBase trend to suicide ...Why? because It was design with Real Time in mind --> If Region Server Is slow (for example you are on Virtual Machine) Then Kill self BR, Alb 2

Joint VS Derived

Hi I don't understand the difference between: - Joint Dim (from Dimension Step ) - Derived Dim (from Advance Setings Step) Some example ? :)

Re: Kylin auto refresh is not working

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 > re-invent the wheel. >

Re: Kylin auto refresh is not working

Kylin 1892 its same that 774 ?? https://issues.apache.org/jira/browse/KYLIN-1892 https://issues.apache.org/jira/browse/KYLIN-774 Thanks 2016-07-28 8:53 GMT+02:00 Alberto Ramón : > Hi > > Interesting: > https://issues.apache.org/jira/browse/KYLIN-1892 > > Thanks, Alberto >

Tableau & Kylin Manual

Hello I wrote an example of use Tableau Software with Apache Kylin https://github.com/albertoRamon/Kylin/tree/master/KylinWithTableau BR, Alberto

Re: Tableau & Kylin Manual

e! > > can we repost it to our blog http://kylin.apache.org/blog/? do you have > any concerns? @Alberto​ > > On Thu, Aug 4, 2016 at 8:35 AM, Yiming Liu > wrote: > >> Thanks, Alberto, great contribution. >> >> Very useful. >> >> 2016-08-04 7:46 GMT+08:0

Re: Kylin Deploy in cluster mode failed!

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 张天生 : > Hi ShaoFen

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

In teorical en v1.5.3, you can Group by 'n' columns: https://issues.apache.org/jira/browse/KYLIN-1693 I don't tested 1.5.3 yet, and I don't know if has been implemented in UI Kylin, perhaps you can add this columns to JSON manually :) BR, Alberto 2016-08-08 11:37 GMT+02:00 赵天烁 : > SUM(1)? you

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

:00 赵天烁 : >>> >>>> ok,I'll have a try >>>> >>>> -- >>>> >>>> 赵天烁 >>>> >>>> Kevin Zhao >>>> >>>> *zhaotians...@meizu.com * >>>> >&g

Re: Tableau & Kylin Manual

Nice ¡¡¡ I wish to be useful to other people, play with tableau It's a good way to start with Kylin BR, Alberto 2016-08-11 4:47 GMT+02:00 hongbin ma : > thanks @shaofeng > > @​Alberto thanks for your suggestions, we can definitely improve on > documents:) > > > > -- > Regards, > > *Bin Mahone |

Re: Tableau & Kylin Manual

To @shaofeng There is a small mismatch IN: https://kylin.apache.org/docs15/tutorial/tableau_91.html SAID: "Please make sure to download and install Kylin ODBC Driver *v1.2*" I tested Tableau with ODBC v1.2 *and not work, You needed use v1.5* 2016-08-11 6:52 GMT+02:00 Alb

Use Apache HUE with Kylin

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: Use Apache HUE with Kylin

@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 bug

Metadata II

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: Encou

Re: Metadata II

gt; On Mon, Sep 5, 2016 at 12:45 AM, Alberto Ramón > wrote: > >> Hello >> >> I'm testing Sisense Software <https://www.sisense.com/>, and saw similar >> integration-problem like with other vendors with "get Metadata" >> >> This don&#

Re: Documentation on how data is stored

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 on HBase? > For example, I

Re: Documentation on how data is stored

+02:00 Something Something : > 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 > wrote: > >> I have this picture: (I found this info in a PPT)

Re: Use Apache HUE with Kylin

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

Use Qlik and Kylin

Hello, I did a small manual, about How to intergate Qlik with Apache Kylin https://github.com/albertoRamon/Kylin/tree/master/KylinWithQlik For any suggestions/bug, *feel free to contact me* Thanks, Alberto

Re: Use Qlik and Kylin

avel>, but the actual master have some bugs (I told with the owner), and previous brach also didn't work Nice Weekend, Alb 2016-09-11 12:06 GMT+02:00 Yiming Liu : > Thanks Alberto. Nice work. > > 2016-09-11 16:48 GMT+08:00 Alberto Ramón : > >> Hello, >> >&g

Kylin ODBC

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: Kylin ODBC

uot;DEFAULT"."KYLIN_SALES"": Timeout visiting cube!* This querie *from Microsoft, never finish* or kill my HBase, but from Kylin UI works fine < 0.5 sec 2016-09-14 6:49 GMT+02:00 Alberto Ramón : > Hello > I tested New Microsoft Power BI with Kylin > [image: I

Re: Kylin ODBC

t 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 > wrote: &

Re: Kylin ODBC

hello See this Video: <https://youtu.be/v9of5N3TcTw> Query with *limit 5*, the preview data run OK, but load data ... never finished Somebody has tested Kylin with New Microsoft Power Bi Desktop ? 2016-09-14 11:54 GMT+02:00 Alberto Ramón : > The cube is the Kylin Example, the fact t

Re: Use Apache HUE with Kylin

box/%3CCAEcyM14%2BCKz5j7gJEMUVYCtdHFcmuWJKRMQPbisDQhW3G5Mc9Q%40mail.gmail.com%3E> ) 2016-09-16 18:00 GMT+02:00 Luke Han : > Very nice! > > What's metadata bug? > > > Best Regards! > - > > Luke Han > > On Thu, Sep 8, 2016 at 3:51 PM, Alber

Re: Use Apache HUE with Kylin

2016-09-18 13:29 GMT+02:00 Luke Han : > 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 > wrote: > >> See this: HU

Kylin and BI Tools

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 "K

Re: Error while building cube from stream

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 > > ) says. > > I wa

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

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 赵天烁 : > >> I have a cube tha

Re: Question about future Kylin features and roapmap.

1 - I think, no 2 - There isnt MDX support (Kylin 1525 & Kylin 776 ):For now you can use mondrian see this example

Re: Question about future Kylin features and roapmap.

ry) 2016-10-04 8:38 GMT+02:00 Ashika Umanga Umagiliya : > 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 > wrote: > >> 1 - I think, no >> 2 - The

Re: Question about future Kylin features and roapmap.

ouping of Dimensions and Measure, grouping under folders...etc ) >>-- This is design purpose, we would like users treat Kylin as a read >> only database not a pure Cube system >> >>Please feel free to leave your comments. >> >>Thanks. >> Luke >> &g

Re: Trie dictionary Not a valid value

can you check this bug: KYLIN-1834 check if your actual version is 1.5.2 there is a new version 1.5.4.2 good luck, Alb 2016-10-10 18:38 GMT+02:00 Joel Victor : > I have come across this error where I get a exception in the cube build > step (st

SQuirrieL and Kylin

Hello I Wrote a Tech note , about use "SQuireL: Universal SQL Client ", with Apache Kylin I used a lot for testing/develop purpose, because get a lot information about, tables and columns If you ha

Read Apache Kylin from Apache Flink

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

Kylin Dependencies

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 Hado

Kylin Version on UI

(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 ?

Re: Kylin Version on UI

jaja, Thanks ¡¡ +1 ;) 2016-11-02 14:22 GMT+01:00 Li Yang : > 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, 2016 at 1:53 AM, Alberto Ramón >

Re: Kylin Dependencies

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

Re: Kylin Dependencies

file, you could find the kylin dependencies. > > 2016-11-02 22:46 GMT+08:00 Alberto Ramón : > >> With configs ... I can try it (Will be an interesting exercise for >> me) >> But libraries, ... >>These libraries can be static compiled on Kylin? >>

Re: Kylin Dependencies

ed like openssh-server openssh-clients snappy snappy-devel > hadoop-native (from 1.5.4 kylin doesn't use compression by default) > > 2016-11-02 23:15 GMT+08:00 Alberto Ramón : > >> yes, I tested (and use) this and other previous version >> >> BUT the image : >&g

Most Used BI Tools

fyi: https://image-store.slidesharecdn.com/0d3c9706-b8a6-4716-afc1-26beb82c8704-large.png

Re: 答复: Most Used BI Tools

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

IN_THRESHOLD

About Kylin 2193 What is the poupose of org.apache.kylin.storage.translate.DerivedFilterTranslator# IN_THRESHOLD ? :) (when is used?)

Testing 1.6

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

Re: 答复: Re[2]: build cube step 3 error

Ckeck This , If you have any problem tell me it https://drive.google.com/drive/folders/0B-6nZ2q-HPTNV0xqRnNtZE03d0E?usp=sharing 2016-11-18 10:51 GMT+01:00 Li Yang : > Do you (or anyone) still have CDH 5.4 sandbox? We've wanted to test Kylin > on that env but lack of sandbox for long time. > > Ya

Re: IN_THRESHOLD

nce > problem during storage scanning. In such case, the filter can be translated > into a range filter instead, like USER_ID between 1 and 382. > > The threshold is used to decided whether the translation to return a IN > condition or a range condition. > > Cheers > Yang >

Release apache-kylin-1.6.0 (RC2)

My vote = Null (I'm rookie) 1 - Using: https://dist.apache.org/repos/dist/dev/kylin/apache-kylin-1.6.0-rc2/ 2 - mvn clean install -DskipTests --> OK on Ubuntu 16.04 But how create Binary package? : http://kylin.apache.org/development/howto_package.html, I don't have /build/ folder ?

Re: Release apache-kylin-1.6.0 (RC2)

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 : > >> My vote = Null (I'm rookie) >> >> 1 - Using: https://dist.apache.org/repos/dist/dev/kylin/apache-kylin-1. >> 6.0-rc2/ >> 2

Re: KYLIN throws null exception when execute specific query

Hello I tested your querie on "apache-kylin-1.6.0-SNAPSHOT-bin" and also fails :( I tried with some changes SELECT count (1) FROM ( SELECT PART_DT as PART_DT1, COUNT(1) as vv1 FROM KYLIN_SALES GROUP BY PART_DT ) AS t1 JOIN ( SELECT PART_DT as PART_DT2, COUNT(1) as vv2 FROM KYLIN_SALES GROUP

Codec of decimal (10,6)

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: Testing 1.6

patible with previous version. The upgrade shall >> be pretty straightforward. But you are right. It deserves a document. >> >> @Shaofeng, consider an upgrade guide next time. >> >> Cheers >> Yang >> >> On Wed, Nov 16, 2016 at 3:02 AM, Alberto Ramón >

Re: Testing 1.6

> https://kylin.apache.org/docs16/howto/howto_upgrade.html , FYI > > 2016-11-26 19:36 GMT+08:00 Alberto Ramón : > >> I'm re-testing auto refreshing Job Progress , and not work in my case. >> I used Firefox and Chromium on Ubuntu 16.04 >> Isn't important for me

Re: Codec of decimal (10,6)

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 totally the

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 announce the immediate avai

ODBC 1.6

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 identifie

Re: ODBC 1.6

More Info: - Same error in Win Srv 2008R2 - I start ODBC config using: C:\Windows\System32\odbcad32.exe (to be sure start ODBC 64 bits version) 2016-11-28 14:34 GMT+01:00 Alberto Ramón : > Hello > > I'm try to test New Kylin ODBC Driver 1.6, > When I try to create New ODBC,

Re: ODBC 1.6

x64, all system are 64 bits (win 7 ultimate, and Win Server 2008 R2) 2016-11-28 14:58 GMT+01:00 ShaoFeng Shi : > 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+08:00 Alberto Ramón : > >> More Inf

Re: ODBC 1.6

28 22:17 GMT+08:00 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 : >> >>> Hi Alberto, Kylin ODBC zip has two exe files; which one are you >>> installing, the x86 o

Re: ODBC 1.6

edback. > > 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 Alberto Ramón : >

Re: Consulting "EXTENDED_COLUMN"

> understanding. > > 2016-11-30 19:00 GMT+08:00 Alberto Ramón : > >> 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 / re

User MailList

Small Proposal: Dev mailList is in Nabble (more practical than mail-archives.apache.org: You can find by txt, see pictures and more readable) Is it possible make the same with UserList ? (nowadays, a lot of user's doubts are in Dev MailList or in both)

Re: User MailList

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

Re: Consulting "EXTENDED_COLUMN"

umn is you have more > columns in the HBase rowkey. It may harm the query performance. But most > time, joint dimension is still recommended, since the normal dimension > column supports much more functions than extended column, such as count(*). > > 2016-12-01 17:07 GMT+08:00 Alberto

corrupt metastore

I had some problems with corrupt data on HDFS and Meta HDFS Now all services started OK *None query is excuted in none cube * *Error while executing SQL "select part_dt, sum(price) as total_selled, count(distinct seller_id) as sellers from kylin_sales group by part_dt order by part_dt LIMIT 5"

Re: corrupt metastore

ools/commands to do this I saw metadata.sh script, but I cant find this functionality 2016-12-02 2:46 GMT+01:00 ShaoFeng Shi : > 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 : > >> I had some

Re: corrupt metastore

loss, > then Kylin has no data loss; You can watch the kylin.log during the > startup, Kylin will report error when finding inconsistent metadata. > > 2016-12-02 15:23 GMT+08:00 Alberto Ramón : > >> yes, yes, >> I had this type of problems, I needed used >> hdfs

Re: Consulting "EXTENDED_COLUMN"

yes, I will asume this overhead in rowKey 2016-12-02 9:58 GMT+01:00 Billy(Yiming) Liu : > Using Joint Dimension for your 1:1 relation is the right design. > > 2016-12-02 0:21 GMT+08:00 Alberto Ramón : > >> Nice Liu >> >> We have some cases like >> DayWeek

Cut Size

I'm reading this MailList and have some doubts (Example ): region-cut-gb max-region-count hfile-siz

Use derived or Joint

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 col

Re: Use derived or Joint

has 1:1 (like "Month_ID" "Month_Txt") or close > to 1:1 relationship (like "USER_ID", "USER_EMAIL") > > For case 1, I might design the cube in this way (assume you have the need > to group by year, month, dayweek): > 1) define all them as normal

Cuboid WhiteList

Hello Kylin – 242 Nowadays Does cuboid whiteList / Partial Cube exist? or has been replaced by Agregation groups ?

Re: Use derived or Joint

number as the > combination "IDDate"; so aggregate from the former to the latter will not > aggregate much; Then we can prune the later with the "hierarchy" to reduce > the cube size; > > Nowadays, in derived columns, the Host column, is always the PK of table ?

Re: Cut Size

rg/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 : > >> I'm reading th

Relocate SQL Query ?

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: Error when #2 Step: Redistribute Flat Hive Table - File does not exist

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 F

Joint and Order in RowKey

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

. > === > 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". > > -

Re: How to workaround with columns with NULL value?

about 1º point: In Kylin 2049 there is a commet of Shaofeng SHI 2016-12-21 6:32 GMT

Re: if can add where clause to a measure?

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 where price > 100.0 an

Re: Joint and Order in RowKey

, 2016 at 2:46 AM, Alberto Ramón > 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 individually?* (Text , Id) now must be >>

ArrayIndexOutOfBoundsException: -1

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 org.apache.kylin.engine.mr.steps.FactDistinctHiveColumnsMapper.map(FactDistinctHiveC

Re: ArrayIndexOutOfBoundsException: -1

In Data model, 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 : > > Error on, Extract Fact Table Distinct Columns > > > > > * Insane record: [1, 0600-160077, FVP D

Re: kylin query with case return error result

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 sample data > and actu

Re: Kylin and BI Tools

; wrote: >> >>> So cool, impressive. Thank you, Alberto. >>> >>> 2016-09-19 21:42 GMT+08:00 Alberto Ramón : >>> >>>> Hello >>>> >>>> This is the end of all my previous articles, about Kylin and differents >>>&

Re: Kylin and BI Tools

01-16 9:37 GMT+01:00 Jian Zhong : > 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 > wrote: > >> Happy 2017 :) >> >> I u

Re:

Hi Phon, I'm not expert but I have some suggestions: - All Dim en are using Dict: you can change a lot to Integer (Fix length) - Re-Order row key its a good idea. I always try to first fields of key have Fix Length. Put mandatory the First its a good Idea - See hierarchy optimizations, will be ver

Re: Kylin and BI Tools

to > http://zeppelin.apache.org/docs/0.7.0-SNAPSHOT/interpreter/kylin.html > first. > > 2017-01-16 19:14 GMT+08:00 Alberto Ramón : > >> yes, >> - I will fix "Carabel" to "Caravel". (It is a shame that this project >> is not updated, because the qua

Re:

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 : > >> Hi Phon, I'm not expert but I have some suggestions: >> >> - All Dim en are using Dict: you can change a lot to Integer (Fix len

Re: Kylin and BI Tools

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

Re:

ionsServer and Cold RS 2017-01-17 9:26 GMT+01:00 Alberto Ramón : > Did you compressed the output cube? This is very important (see last link) > > About Order BY > - Check if TopN can solve your problem: > http://kylin.apache.org/blog/2016/03/19/approximate-topn-measure/ >

Re: Problem with limit and joint aggregation

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 Ky

Re: Kylin and BI Tools

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 : > Thanks Anton > I will complete/fix my report with your sugge

Jekyll

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 git://git.apache.org/kylin.

Re: Jekyll

the error was, I had two versions of "jekyll-multiple-language" thanks 2017-01-23 20:26 GMT+01:00 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' > &g

Re: Jekyll

the error was, I had two versions of "jekyll-multiple-language" 2017-01-23 20:26 GMT+01:00 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

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 ide

  1   2   >