Our Community is getting an upgrade! To get everything ready for the relaunch, we’ll be placing the site in read-only mode starting September 21st.
We really appreciate your understanding while we get things set up behind the scenes. Catch up on all the exciting details about the move here.
Need help or have questions? Drop us a line at [email protected]
Created on
03-08-2018
07:08 AM
- last edited on
04-21-2026
06:44 AM
by
GrazittiAPI
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!
Created 03-16-2018 08:28 AM
Created 03-10-2018 06:26 AM
Could you let me know if you are firing hive or impala query ?
whats the coloumn delimiter you are using ?
Created 03-16-2018 08:23 AM
Hive!
Field Separator:Comma (,)
Record Separator:New line
Quote Character: Double Quote
Example of a csv file line:
"MARCEL", "STREET TEST", "[email protected]"
Created 03-16-2018 08:28 AM
Created 03-16-2018 10:00 AM
Sounds Good ! 🙂