Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Error on importer using csv

avatar
New Contributor

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!

1 ACCEPTED SOLUTION

avatar
New Contributor
Got it! Problem in the csv formatting. Some lines was missing information. Thanks!

View solution in original post

4 REPLIES 4

avatar
Champion

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

whats the coloumn delimiter you are using ? 

avatar
New Contributor

Hive! 

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

 

Example of a csv file line:

 

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

 

 

avatar
New Contributor
Got it! Problem in the csv formatting. Some lines was missing information. Thanks!

avatar
Champion

Sounds Good ! 🙂