Hi,
I am getting buffer over flow exception while using spark via thrifserver
base.May I know how to overcome this?
Code:
HqlConnection con = new HqlConnection("localhost", 10001,
HiveServer.HiveServer2);
con.Open();
HqlCommand createCommand = new HqlCommand(tablequery, con); =>
Here table query was the query which I used to create a table
createCommand.ExecuteNonQuery();
#.It seems spark works slower when compare to SQLServer.May I know the
reason for that?
My Case is:
I have used the table called "TestTable" with 40000 records in SQLServer
and I executed a query and it returns the result in 1 sec.
Then I have converted the same table as csv and exported it to spark and I
executed the same query like in code but it takes more time almost 2 minute
to return the results.
May I know the reason for this slow process too?
Thanks,
Vinod
