Support Questions

Find answers, ask questions, and share your expertise
Announcements
Welcome to the upgraded Community! Read this blog to see What’s New!

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 ! 🙂 

Labels