blaze / blaze/odo

odo can not read back datetime column from sqlite generated by itself

Open
#392 1 comment 3 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
1k
Forks
131
PR merge metrics
No merged PRs in 30d

Description

given a simple foo.csv like:

```
,colA,colB
0,1,2015-12-25
1,3,
2,3,
3,2,2015-12-28
4,3,

```

convert it into a sqlite db:

```
>>> odo('foo.csv', 'sqlite:///foo_1::foo')
Table('foo', MetaData(bind=Engine(sqlite:///foo_1)), Column('Unnamed: 0', BigInteger(), table=, nullable=False), Column('A', BigInteger(), table=, nullable=False), Column('B', DateTime(), table=), schema=None)
```

but now odo can not read it back:

```
df1 = odo('sqlite:///foo_1::foo', pd.DataFrame)
```

gives error:
ValueError: Couldn't parse datetime string: u'2015-12-25'

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.