Unable to create dataset with clickhouse as db

[sachinkbansal]

I can create a connection but get an error when I try to create a dataset.

select
  date_trunc('hour', date_add(day, date_diff(day, toDate('2014-03-23'), today()), EventTime)) as NewEventTime,
  MobilePhoneModel,
  count(1) as Hits
from hits_v1
GROUP BY
  date_trunc('hour', date_add(day, date_diff(day, toDate('2014-03-23'), today()), EventTime)), MobilePhoneModel
order by date_trunc('hour', date_add(day, date_diff(day, toDate('2014-03-23'), today()), EventTime))