Re: Kylin and BI Tools

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

> Thanks Anton
> I will complete/fix my report with your suggestions.
>
> 2017-01-17 3:56 GMT+01:00 Anton Bubna-Litic  com.au>:
>
>> I have successfully used Zeppelin’s Kylin interpreter with Kylin 1.6 to
>> run sql queries. It was very straight forward to set up and 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.org/docs/0.7.0-SNAPSHOT/interpreter/kylin.html
>>
>> If this work OK with Kylin 1.6 or 2.0, I can put a reference directly
>>
>>
>>
>> 2017-01-16 15:31 GMT+01:00 Billy Liu :
>>
>> I have interest on Zeppelin also, please refer 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 quality of the graphics are very good)
>>
>>  - Document about  Kylin and Zeppelink will be interesting, I have this
>> in my ToDo list
>>
>>  - More suggestions? bugs ?
>>
>>
>>
>> Thanks !!
>>
>>
>>
>> 2017-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 updated Kylin & BI tools with new notes:
>> https://github.com/albertoRamon/Kylin/tree/master/KylinWithMain
>>
>>
>>
>> 2016-09-28 1:30 GMT+02:00 Li Yang :
>>
>> Base on the great work, we could create more How-To page to add to Kylin
>> document section.
>>
>> Yang
>>
>>
>>
>> On Tue, Sep 20, 2016 at 9:03 AM, Luke Han  wrote:
>>
>> Very nice, thanks Alberto
>>
>>
>>
>>
>> Best Regards!
>> -
>>
>> Luke Han
>>
>>
>>
>> On Mon, Sep 19, 2016 at 10:21 PM, Billy(Yiming) Liu <
>> liuyiming@gmail.com> 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
>> 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 "Kylin Team", Alb
>>
>>
>>
>>
>>
>> --
>>
>> With Warm regards
>>
>> Yiming Liu (刘一鸣)
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
>

ApacheCon CFP closing soon (11 February)

[Rich Bowen]

Hello, fellow Apache enthusiast. Thanks for your participation, and
interest in, the projects of the Apache Software Foundation.

I wanted to remind you that the Call For Papers (CFP) for ApacheCon
North America, and Apache: Big Data North America, closes in less than a
month. If you've been putting it off because there was lots of time
left, it's time to dig for that inspiration and get those talk proposals in.

It's also time to discuss with your developer and user community whether
there's a track of talks that you might want to propose, so that you
have more complete coverage of your project than a talk or two.

We're looking for talks directly, and indirectly, related to projects at
the Apache Software Foundation. These can be anything from in-depth
technical discussions of the projects you work with, to talks about
community, documentation, legal issues, marketing, and so on. We're also
very interested in talks about projects and services built on top of
Apache projects, and case studies of how you use Apache projects to
solve real-world problems.

We are particularly interested in presentations from Apache projects
either in the Incubator, or recently graduated. ApacheCon is where
people come to find out what technology they'll be using this time next
year.

Important URLs are:

To submit a talk for Apache: Big Data -
http://events.linuxfoundation.org/events/apache-big-data-north-america/program/cfp
To submit a talk for ApacheCon -
http://events.linuxfoundation.org/events/apachecon-north-america/program/cfp

To register for Apache: Big Data -
http://events.linuxfoundation.org/events/apache-big-data-north-america/attend/register-
To register for ApacheCon -
http://events.linuxfoundation.org/events/apachecon-north-america/attend/register-

Early Bird registration rates end March 12th, but if you're a committer
on an Apache project, you get the low committer rate, which is less than
half of the early bird rate!

For further updated about ApacheCon, follow us on Twitter, @ApacheCon,
or drop by our IRC channel, #apachecon on the Freenode IRC network. Or
contact me - rbo...@apache.org - with any questions or concerns.

Thanks!

Rich Bowen, VP Conferences, Apache Software Foundation

-- 
(You've received this email because you're on a dev@ or users@ mailing
list of an Apache Software Foundation project. For subscription and
unsubscription information, consult the headers of this email message,
as this varies from one list to another.)

Re: Kylin loadbalancer

[ShaoFeng Shi]

Yes you need a LB or proxy between the ASP.net and Kylin; it can be running
in a dedicated server or a shared server (together with Kylin), depends on
how many resources you have;

2017-01-17 17:28 GMT+08:00 Hoang Le Trung :

> HI ShaoFeng Shi,
>
>
>
> So that meant I need one more server sit between my ASP.net to install
> Nginx for loadbalancer.
>
> --Web ASP.net--| Nginx|--Kylins node
>
> Is it prefer to install in one node running Kylin instance ?
>
>
>
> Thanks!
>
> Best  Regards,
>
>
>
> *From:* ShaoFeng Shi [mailto:shaofeng...@apache.org]
> *Sent:* Tuesday, January 17, 2017 4:14 PM
> *To:* user
> *Subject:* Re: Kylin loadbalancer
>
>
>
> Hi Hoang,
>
>
>
> You can use Nginx as a load balancer (https://nginx.org/en/docs/
> http/load_balancing.html), and then accessing the Nginx from your
> applications (whatever it is on Linux or Windows), it will distribute the
> requests to backend Kylin nodes;
>
>
>
> 2017-01-17 15:35 GMT+08:00 Hoang Le Trung :
>
> Hi team,
>
> I already deploy Kylin on multimode and now I want to setup load balancer
> on frontend website.
>
> But my Kylin running on Centos and my front-end running on ASP.net.
>
>
>
> Web ASP.net-
>
>  | | |
>
> |Kylin query| |Kylin query|   |Kylin query|
>
>
>
> For another frontend website using Centos, we can use Haproxy service.
>
>
>
> But for windows I do not known How can I routing all to balancer to my
> ASP.net site.
>
>
>
> Any guide for this case.
>
>
>
> Thanks!
>
> Best  Regards,
>
>
>
>
> --
>
> This e-mail may contain confidential or privileged information. If you
> received this e-mail by mistake, please don't forward it to anyone else,
> please erase it from your device and let me know so I don't do it again.
>
>
>
>
>
> --
>
> Best regards,
>
>
>
> Shaofeng Shi 史少锋
>
>
>
> --
> This e-mail may contain confidential or privileged information. If you
> received this e-mail by mistake, please don't forward it to anyone else,
> please erase it from your device and let me know so I don't do it again.
>



-- 
Best regards,

Shaofeng Shi 史少锋

Re: why cant not delete a segment by api , please

[ShaoFeng Shi]

I see; thanks

2017-01-18 18:16 GMT+08:00 雨日听风 <491245...@qq.com>:

> done! Thank you!
>
> HttpURLConnection conn = (HttpURLConnection)url.openConnection();
> conn.setDoOutput(true);
> conn.setRequestMethod("DELETE");
> //add this setting
> conn.setRequestProperty("Authorization", "");
>
>
> -- 原始邮件 --
> *发件人:* "ShaoFeng Shi";;
> *发送时间:* 2017年1月18日(星期三) 晚上6:00
> *收件人:* "user";
> *主题:* Re: why cant not delete a segment by api , please
>
> is there any error in kylin.log?
>
> 2017-01-18 15:36 GMT+08:00 雨日听风 <491245...@qq.com>:
>
>> String deleteUrl = "http://192.168.35.2:7070/kylin/api/cubes
>> /F_CUBE/segs/2017011300_2017011400";
>> Map map = new HashMap();
>> map.put("username", "ADMIN");
>> map.put("password", "KYLIN");
>> //still not work as
>> //map.put("Authorization", "Basic QURNSU46S1lMSU4=");
>> doDelete(deleteUrl,map);
>> _
>>  public static void doDelete(String urlStr,Map paramMap)
>> throws Exception{
>> String paramStr = prepareParam(paramMap);
>> if(paramStr == null || paramStr.trim().length()<1){
>>
>> }else{
>> urlStr +="?"+paramStr;
>> }
>> System.out.println(urlStr);
>> URL url = new URL(urlStr);
>> HttpURLConnection conn = (HttpURLConnection)url.openConnection();
>> conn.setDoOutput(true);
>> conn.setRequestMethod("DELETE");
>> if(conn.getResponseCode() ==200){
>> System.out.println("成功");
>> }else{
>> System.out.println(conn.getResponseCode());// always print
>> 505 or 401
>> }
>> }
>>
>>
>>
>
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>
>


-- 
Best regards,

Shaofeng Shi 史少锋

?????? why cant not delete a segment by api , please

[????????]

done! Thank you!
 
HttpURLConnection conn = (HttpURLConnection)url.openConnection();
conn.setDoOutput(true);
conn.setRequestMethod("DELETE");
 //add this setting
conn.setRequestProperty("Authorization", "");
  

 

 --  --
  ??: "ShaoFeng Shi";;
 : 2017??1??18??(??) 6:00
 ??: "user"; 
 
 : Re: why cant not delete a segment by api , please

 

 is there any error in kylin.log?
 
 2017-01-18 15:36 GMT+08:00  <491245...@qq.com>:
   String deleteUrl = 
"http://192.168.35.2:7070/kylin/api/cubes/F_CUBE/segs/2017011300_2017011400;;
Map map = new HashMap();
map.put("username", "ADMIN");
map.put("password", "KYLIN");
//still not work as
//map.put("Authorization", "Basic QURNSU46S1lMSU4=");
doDelete(deleteUrl,map);
 _
  public static void doDelete(String urlStr,Map paramMap) throws 
Exception{
String paramStr = prepareParam(paramMap);
if(paramStr == null || paramStr.trim().length()<1){

}else{
urlStr +="?"+paramStr;
}   
System.out.println(urlStr);
URL url = new URL(urlStr);
HttpURLConnection conn = (HttpURLConnection)url.openConnection();
conn.setDoOutput(true);
conn.setRequestMethod("DELETE");
if(conn.getResponseCode() ==200){
System.out.println("");
}else{
System.out.println(conn.getResponseCode());// always print 505 or 
401
}
}
 
 




 

-- 
Best regards,  

 Shaofeng Shi ??