Odo Function with encoding error: ValueError: Unsupported string encoding u'SQL_Latin1_General_CP1_CI_AS'
- Dominant language
- Python
- Stars
- 1k
- Forks
- 131
- PR merge metrics
- No merged PRs in 30d
Description
`df = odo(url_source+"::NibrasEBSElementMap", pd.DataFrame, encoding='cp1512')`
and
`df = odo(url_source+"::NibrasEBSElementMap", pd.DataFrame, encoding='latin1')`
results in following error
> ValueError Traceback (most recent call last)
> in ()
> 3 url_source = 'mssql+pyodbc:///?odbc_connect={}'.format(quoted)
> 4
> ----> 5 df = odo(url_source+"::NibrasEBSElementMap", pd.DataFrame, encoding='cp1512')
> 6 df
>
> D:\Rahuketu\Anaconda\lib\site-packages\odo\odo.pyc in odo(source, target, *_kwargs)
> 89 odo.append.append - Add things onto existing things
> 90 """
> ---> 91 return into(target, source, *_kwargs)
>
> D:\Rahuketu\Anaconda\lib\site-packages\multipledispatch\dispatcher.pyc in **call**(self, _args, *_kwargs)
> 162 self._cache[types] = func
> 163 try:
> --> 164 return func(_args, *_kwargs)
> 165
> 166 except MDNotImplementedError:
>
> D:\Rahuketu\Anaconda\lib\site-packages\odo\into.pyc in wrapped(_args, *_kwargs)
> 41 raise TypeError('dshape argument is not an instance of DataShape')
> 42 kwargs['dshape'] = dshape
> ---> 43 return f(_args, *_kwargs)
> 44 return wrapped
> 45
>
> D:\Rahuketu\Anaconda\lib\site-packages\odo\into.pyc in into_string_string(a, b, *_kwargs)
> 147 @validate
> 148 def into_string_string(a, b, *_kwargs):
> --> 149 return into(a, resource(b, *_kwargs), *_kwargs)
> 150
> 151
>
> D:\Rahuketu\Anaconda\lib\site-packages\multipledispatch\dispatcher.pyc in **call**(self, _args, *_kwargs)
> 162 self._cache[types] = func
> 163 try:
> --> 164 return func(_args, *_kwargs)
> 165
> 166 except MDNotImplementedError:
>
> D:\Rahuketu\Anaconda\lib\site-packages\odo\into.pyc in wrapped(_args, *_kwargs)
> 41 raise TypeError('dshape argument is not an instance of DataShape')
> 42 kwargs['dshape'] = dshape
> ---> 43 return f(_args, *_kwargs)
> 44 return wrapped
> 45
>
> D:\Rahuketu\Anaconda\lib\site-packages\odo\into.pyc in into_type(a, b, dshape, *_kwargs)
> 50 with ignoring(NotImplementedError):
> 51 if dshape is None:
> ---> 52 dshape = discover(b)
> 53 return convert(a, b, dshape=dshape, *_kwargs)
> 54
>
> D:\Rahuketu\Anaconda\lib\site-packages\multipledispatch\dispatcher.pyc in **call**(self, _args, *_kwargs)
> 162 self._cache[types] = func
> 163 try:
> --> 164 return func(_args, *_kwargs)
> 165
> 166 except MDNotImplementedError:
>
> D:\Rahuketu\Anaconda\lib\site-packages\odo\backends\sql.pyc in discover_sqlalchemy_selectable(t)
> 201 def discover_sqlalchemy_selectable(t):
> 202 ordering = dict((c, i) for i, c in enumerate(c for c in t.columns.keys()))
> --> 203 records = list(sum([discover(c).parameters[0] for c in t.columns], ()))
> 204 fkeys = [discover(fkey, t, parent_measure=Record(records))
> 205 for fkey in t.foreign_keys]
>
> D:\Rahuketu\Anaconda\lib\site-packages\multipledispatch\dispatcher.pyc in **call**(self, _args, *_kwargs)
> 162 self._cache[types] = func
> 163 try:
> --> 164 return func(_args, *_kwargs)
> 165
> 166 except MDNotImplementedError:
>
> D:\Rahuketu\Anaconda\lib\site-packages\odo\backends\sql.pyc in discover_sqlalchemy_column(c)
> 195 def discover_sqlalchemy_column(c):
> 196 meta = Option if c.nullable else identity
> --> 197 return Record([(c.name, meta(discover(c.type)))])
> 198
> 199
>
> D:\Rahuketu\Anaconda\lib\site-packages\multipledispatch\dispatcher.pyc in **call**(self, _args, *_kwargs)
> 162 self._cache[types] = func
> 163 try:
> --> 164 return func(_args, *_kwargs)
> 165
> 166 except MDNotImplementedError:
>
> D:\Rahuketu\Anaconda\lib\site-packages\odo\backends\sql.pyc in discover_typeengine(typ)
> 173 return datashape.Decimal(precision=typ.precision, scale=typ.scale)
> 174 if isinstance(typ, (sa.String, sa.Unicode)):
> --> 175 return datashape.String(typ.length, typ.collation)
> 176 else:
> 177 for k, v in revtypes.items():
>
> D:\Rahuketu\Anaconda\lib\site-packages\datashape\coretypes.pyc in **init**(self, *args)
> 397 except KeyError:
> 398 raise ValueError('Unsupported string encoding %s' %
> --> 399 repr(encoding))
> 400
> 401 self.encoding = encoding
>
> ValueError: Unsupported string encoding u'SQL_Latin1_General_CP1_CI_AS'
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.