Created on 03-08-2018 07:08 AM - edited 09-16-2022 05:56 AM
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", "marcel@test.com"
Created 03-16-2018 08:28 AM
Created 03-16-2018 10:00 AM
Sounds Good ! 🙂