Hi Sourav,
Flink does not support to execute SQL queries on DataSets, yet.
We just started an effort to change that. See the discussion on the dev mailing list [1] and the corresponding design document [2].
For simple relational queries, you can use the Table API [3].
Best,