I guess you can use cast(id as String) instead of just id in your where clause ?
Le mer. 29 avr. 2015 à 12:13, lonely Feb <lonely8...@gmail.com> a écrit : > Hi all, we are transfer our HIVE job into SparkSQL, but we found a litter > difference between HIVE and Spark SQL that our sql has a statement like: > > select A from B where id regexp '^12345$' > > in HIVE it works fine but in Spark SQL we got a: > > java.lang.ClassCastException: java.lang.Long cannot be cast to > java.lang.String > > Can this statement be handled with Spark SQL? >
