d.filter("id in max(id)")

[Ashok Kumar]

 Hi,
How can I make that work?
val d = HiveContext.table("table")
select * from table where ID = MAX(ID) from table
Thanks