Reply
New Contributor
Posts: 3
Registered: ‎03-08-2018
Accepted Solution

Error on importer using csv

Hello. I´m trying to use the Importer, to create a table starting from a csv file, but i got this error:

 

 

 

{ "traceback": [ [ "/usr/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/core/handlers/base.py", 112, "get_response", "response = wrapped_callback(request, *callback_args, **callback_kwargs)" ], [ "/usr/lib/hue/build/env/lib/python2.6/site-packages/Django-1.6.10-py2.6.egg/django/db/transaction.py", 371, "inner", "return func(*args, **kwargs)" ], [ "/usr/lib/hue/desktop/libs/indexer/src/indexer/api3.py", 146, "guess_field_types", "return JsonResponse(format_)" ], [ "/usr/lib/hue/desktop/core/src/desktop/lib/django_util.py", 476, "__init__", "data = json.dumps(data, cls=encoder, indent=indent)" ], [ "/usr/lib64/python2.6/json/__init__.py", 237, "dumps", "**kw).encode(obj)" ], [ "/usr/lib64/python2.6/json/encoder.py", 367, "encode", "chunks = list(self.iterencode(o))" ], [ "/usr/lib64/python2.6/json/encoder.py", 309, "_iterencode", "for chunk in self._iterencode_dict(o, markers):" ], [ "/usr/lib64/python2.6/json/encoder.py", 275, "_iterencode_dict", "for chunk in self._iterencode(value, markers):" ], [ "/usr/lib64/python2.6/json/encoder.py", 306, "_iterencode", "for chunk in self._iterencode_list(o, markers):" ], [ "/usr/lib64/python2.6/json/encoder.py", 204, "_iterencode_list", "for chunk in self._iterencode(value, markers):" ], [ "/usr/lib64/python2.6/json/encoder.py", 306, "_iterencode", "for chunk in self._iterencode_list(o, markers):" ], [ "/usr/lib64/python2.6/json/encoder.py", 204, "_iterencode_list", "for chunk in self._iterencode(value, markers):" ], [ "/usr/lib64/python2.6/json/encoder.py", 294, "_iterencode", "yield encoder(o)" ] ] }

 

How to fix this? Thanks!

Champion
Posts: 676
Registered: ‎05-16-2016

Re: Error on importer using csv

Could you let me know if you are firing hive or impala query ? 

whats the coloumn delimiter you are using ? 

New Contributor
Posts: 3
Registered: ‎03-08-2018

Re: Error on importer using csv

Hive! 

Field Separator:Comma (,)
Record Separator:New line
Quote Character: Double Quote

 

Example of a csv file line:

 

"MARCEL", "STREET TEST", "marcel@test.com"

 

 

New Contributor
Posts: 3
Registered: ‎03-08-2018

Re: Error on importer using csv

Got it! Problem in the csv formatting. Some lines was missing information. Thanks!
Highlighted
Champion
Posts: 676
Registered: ‎05-16-2016

Re: Error on importer using csv

Sounds Good ! :) 

Announcements