Imporve performance in displaying content of data frame

2015-07-01 Thread Vinod Kuamr
Hi Everyone, I am using following sqlContext var df=sqlContext.sql("SELECT fullname,SUM(CAST(contactid AS decimal(38,6))) FROM adventurepersoncontacts GROUP BY fullname ORDER BY fullname ASC"); It executes fine but when I display the content of the data frame by using println method it take very

Show table in Spark

2015-06-30 Thread Vinod Kuamr
Hi Folks, Can anyone please let me know how to show content of dataframe in spark? when I using dt.show() ( here df is dataframe) I am getting following result I am using Scala version 1.3.1 in windows 8 Thanks in advance,Vinod

Import xlsx to HIve

2015-06-24 Thread Vinod Kuamr
Hi folks, Can anyone help me to import xlsx file db to hive/spark. Thanks in advanceVinod

Doubt Regards SPARK

2015-06-18 Thread Vinod Kuamr
Hi folks, Can anyone please tell me how to show databases list in SPARK? Regards,Vinod