Issue 1:
Running a simple select * query on a DB table and getting an error: DatetimeTZDtype' object has no attribute 'char'

I have checked the superset logs for python stacktraces and included it here as text if any

Traceback (most recent call last):
File "/Users/ruchir/venv/lib/python2.7/site-packages/superset/views/core.py", line 2076, in sql_json
query_id=query_id, return_results=True)
File "/Users/ruchir/venv/lib/python2.7/site-packages/celery/local.py", line 188, in __call__
return self._get_current_object()(*a, **kw)
File "/Users/ruchir/venv/lib/python2.7/site-packages/celery/app/task.py", line 428, in __call__
return self.run(*args, **kwargs)
File "/Users/ruchir/venv/lib/python2.7/site-packages/superset/sql_lab.py", line 91, in get_sql_results
ctask, query_id, return_results, store_results)
File "/Users/ruchir/venv/lib/python2.7/site-packages/superset/sql_lab.py", line 233, in execute_sql
'columns': cdf.columns if cdf.columns else [],
File "/Users/ruchir/venv/lib/python2.7/site-packages/superset/dataframe.py", line 108, in columns
col_db_type = self.db_type(self.__df.dtypes[col])
File "/Users/ruchir/venv/lib/python2.7/site-packages/superset/dataframe.py", line 55, in db_type
return cls.type_map.get(dtype.char)
AttributeError: 'DatetimeTZDtype' object has no attribute 'char'

I have reproduced the issue with at least the latest released version of superset

Yes

I have checked the issue tracker for the same issue and I haven't found one similar

Found this: #2791 but does not address how to deal with situation when the DB table already exists

Superset version

0.19.1

Expected results

Should return result of SQL query

Actual results

Getting Error: 'DatetimeTZDtype' object has no attribute 'char'

Steps to reproduce

Run any query on a DB which has a timestamptz column type

Issue 2:
While pulling data from clickhouse within superset things work as long as fields are not of type datetime. When trying to get data for a datetime column then it gives the following python error.

AttributeError: 'DatetimeTZDtype' object has no attribute 'char'

Superset version

{ GIT_SHA: "", version: "0.18.2" }

Expected results

SQL query should give all the columns for give query.

Actual results

Python error (see below).

2017-05-22 10:32:10,890:ERROR:root:'DatetimeTZDtype' object has no attribute 'char'
Traceback (most recent call last):
File "/home/neeraj/Apps/superset-env/local/lib/python2.7/site-packages/superset/views/core.py", line 2028, in sql_json
query_id=query_id, return_results=True)
File "/home/neeraj/Apps/superset-env/local/lib/python2.7/site-packages/celery/local.py", line 188, in __call__
return self._get_current_object()(*a, **kw)
File "/home/neeraj/Apps/superset-env/local/lib/python2.7/site-packages/celery/app/task.py", line 420, in __call__
return self.run(*args, **kwargs)
File "/home/neeraj/Apps/superset-env/local/lib/python2.7/site-packages/superset/sql_lab.py", line 181, in get_sql_results
'columns': cdf.columns if cdf.columns else [],
File "/home/neeraj/Apps/superset-env/local/lib/python2.7/site-packages/superset/dataframe.py", line 108, in columns
col_db_type = self.db_type(self.__df.dtypes[col])
File "/home/neeraj/Apps/superset-env/local/lib/python2.7/site-packages/superset/dataframe.py", line 55, in db_type
return cls.type_map.get(dtype.char)
AttributeError: 'DatetimeTZDtype' object has no attribute 'char'

Steps to reproduce

Create the following table in clickhouse.

CREATE TABLE gauge_metric
(
EventDate Date,
Timestamp DateTime,
Node String,
Name String,
Value Float32
) ENGINE = MergeTree(EventDate, (Name, Node, Timestamp), 8192);

Insert some data into the above table.

Install sqlalchemy-clickhouse along with superset.

Add clickhouse as datasource with "clickhouse://:8123" as the SQLAlchemy URI.

Open SQL Lab and try executing the following query.

select EventDate,Node,Value,Timestamp,Name from dbname.gauge_metric LIMIT 10;