Re: Spark SQL: No function to evaluate expression

Yeah, sorry that error message is not very intuitive. There is already a JIRA open to make it better: SPARK-2059 Also, a bug has been fixed in master regarding attributes that contain "_". So if you are running 1.0 you might try upgrading. On

Re: Spark SQL: No function to evaluate expression

The error message *means* that there is no column called c_address. However, maybe it's a bug with Spark SQL not understanding the a.c_address syntax. Can you double-check the column name is correct? Thanks Tobias On Wed, Jun 18, 2014 at 5:02 AM, Zuhair Khayyat wrote: > Dear all, > > I am trying

Spark SQL: No function to evaluate expression

Dear all, I am trying to run the following query on Spark SQL using some custom TPC-H tables with standalone Spark cluster configuration: SELECT * FROM history a JOIN history b ON a.o_custkey = b.o_custkey WHERE a.c_address <> b.c_address; Unfortunately I get the following error during execution