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