Got error: Unknown string format

[bo yang]

Hi Guys,

I am trying Caravel, but hit following error. Anyone has any idea? Thanks!

ValueError

ValueError: Unknown string format

Traceback (most recent call last)

• File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1836, in __call__

  return self.wsgi_app(environ, start_response)

• File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1820, in wsgi_app

  response = self.make_response(self.handle_exception(e))

• File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1403, in handle_exception

  reraise(exc_type, exc_value, tb)

• File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1817, in wsgi_app

  response = self.full_dispatch_request()

• File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1477, in full_dispatch_request

  rv = self.handle_user_exception(e)

• File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1381, in handle_user_exception

  reraise(exc_type, exc_value, tb)

• File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1475, in full_dispatch_request

  rv = self.dispatch_request()

• File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1461, in dispatch_request

  return self.view_functions[rule.endpoint](**req.view_args)

• File "/usr/local/lib/python2.7/dist-packages/flask_appbuilder/security/decorators.py", line 26, in wraps

  return f(self, *args, **kwargs)

• File "/usr/local/lib/python2.7/dist-packages/caravel/models.py", line 1294, in wrapper

  return f(*args, **kwargs)

• File "/usr/local/lib/python2.7/dist-packages/caravel/views.py", line 557, in explore

  payload = obj.get_json()

• File "/usr/local/lib/python2.7/dist-packages/caravel/viz.py", line 258, in get_json

  'data': self.get_data(),

• File "/usr/local/lib/python2.7/dist-packages/caravel/viz.py", line 956, in get_data

  df = self.get_df()

• File "/usr/local/lib/python2.7/dist-packages/caravel/viz.py", line 865, in get_df

  df = super(NVD3TimeSeriesViz, self).get_df(query_obj)

• File "/usr/local/lib/python2.7/dist-packages/caravel/viz.py", line 151, in get_df

  df.timestamp = pd.to_datetime(df.timestamp, utc=False)

• File "/usr/local/lib/python2.7/dist-packages/pandas/util/decorators.py", line 91, in wrapper

  return func(*args, **kwargs)

• File "/usr/local/lib/python2.7/dist-packages/pandas/tseries/tools.py", line 287, in to_datetime

  unit=unit, infer_datetime_format=infer_datetime_format)

• File "/usr/local/lib/python2.7/dist-packages/pandas/tseries/tools.py", line 409, in _to_datetime

  values = _convert_listlike(arg._values, False, format)

• File "/usr/local/lib/python2.7/dist-packages/pandas/tseries/tools.py", line 402, in _convert_listlike

  raise e

ValueError: Unknown string format

[Maxime Beauchemin]

It appears that your date/time column is not parseable as a date.

[bo yang]

Hi Maxime,

Thanks for response! My column is DATETIME in MySQL. So there is not "parsing" on that column.

Then I changed the name to exactly "timestamp", the issue was gone. So curious, is there any hardcode for time column to be "timestamp"?

Best,

Bo