Member since
09-11-2015
12
Posts
0
Kudos Received
0
Solutions
10-01-2015
03:12 AM
hi, how to install kylin in my system. present i have cloudera 5.3 vesrion in my local.how to install kylin in my computer? could you please help me. urgent.
... View more
10-01-2015
03:10 AM
hi, how to install kylin in my system. present i have cloudera 5.3 vesrion in my local. could you please help me.
... View more
09-22-2015
05:56 AM
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
09-14-2015
05:31 AM
thank you for giving reply. i have one small doubt in Rhadoop. here i am loading data from file using data.table option.does can we i have group by function with data. table method? but in last thread you said,using plymr method do group by. i read so many articles,using data.table is more fast compare to othermethods. pls suggest me .which one is good. please check below script ,i struck at group by with max value. give me exact syantax with group by then max value. -----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
09-12-2015
10:05 AM
thank you for your suggestuon. I need Group by in Rhadoop. pls help me
... View more
09-12-2015
02:18 AM
I need Group by function with max function in Rhadoop. please give me small syantax for me. could you please help me
... View more
09-11-2015
11:03 AM
but you are saying is Rhadoop is strong for data analytics.pig is better suited for transformation. which one is better for data manipication and processing,data analytics?
... View more
09-11-2015
10:56 AM
In My project,we are using ssis for transformation and ssas for analytic. so which tool is should be used for replacement of ssis and ssas? could you pelase hel pme.
... View more
- Tags:
- rhadoop
09-11-2015
10:55 AM
In My project,we are using ssis for transformation and ssas for analytic. so which tool is should be used for replacement of ssis and ssas? could you pelase hel pme.
... View more
09-11-2015
10:45 AM
09-11-2015
06:13 AM
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