hi,\   how to install apache kylin software in cloudera5.3 vmware. ... View more

Hi,   In my project ,we are processing data with ssas cube.then we can retrive data in cube using with mdxquery. that mdxquery we can call into .net application.that it the process.   so now i am getting large data so unable to process cube because it takes more time.that it is the reason i want to take any tool in hadoop.   could you please suggest me,which tool is best for my requirement.   i tried with kylin cube.that cube ,we can take data using sql query. here my question is how to retrive data in kylin cube  using .net application?what is connection string for that?   please help me.     ... View more

I need Group by function with max function in Rhadoop.   please give me small syantax for me.   could you please help me ... View more

Hi,   I am trying to convert pig script to Rhadoop script.but I am unable to convert, struck some thing. Please help me.   -------pig script--------- batting = LOAD '/home/cloudera/Desktop/test/Batting.csv' using PigStorage(','); runs = FOREACH batting GENERATE $0 as playerID, $1 as year, $8 as runs; grp_data = GROUP runs by (year); max_runs = FOREACH grp_data GENERATE group as grp,MAX(runs.runs) as max_runs; join_max_run = JOIN max_runs by ($0, max_runs), runs by (year,runs);  join_data = FOREACH join_max_run GENERATE $0 as year, $2 as playerID, $1 as runs;  dump join_data;   -----Rhadoop script--- batting <- read.table(file="/home/cloudera/Desktop/test/Batting.csv",header=FALSE,sep=",",fill=TRUE,quote=NULL)   run <- batting[,c(1,2,10)] max_runs <- run[,ax(v2)] --strucked   write.table(max_runs,"8.txt",quote=F, row.names=F, col.names=T,sep=",") ... View more