ambari-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nitiraj Singh Rathore (JIRA)" <j...@apache.org>
Subject [jira] [Created] (AMBARI-18583) Ambari Hive View 'Upload Table' does not support UTF8 files with BOM
Date Thu, 13 Oct 2016 08:37:20 GMT
Nitiraj Singh Rathore created AMBARI-18583:
----------------------------------------------

             Summary: Ambari Hive View 'Upload Table' does not support UTF8 files with BOM
                 Key: AMBARI-18583
                 URL: https://issues.apache.org/jira/browse/AMBARI-18583
             Project: Ambari
          Issue Type: Bug
          Components: ambari-views
    Affects Versions: 2.2.2
            Reporter: Nitiraj Singh Rathore
            Assignee: Nitiraj Singh Rathore
             Fix For: 2.5.0


PROBLEM: Ambari Hive view throws an E090 HiveClientFormattedException exception when trying
to create a table via the 'Upload Table' function when the file contains the BOM for UTF8
(Byte Order Mark - 0xEF 0xBB 0xBF) . The same file has no problem being loaded when saved
without the BOM (via Sublime Text). Deleting the contents of the first column heading and
retyping it fixes the issue
STEPS TO REPRODUCE: Download attached CSV file and try to upload table via Ambari 2.2.2 view.
EXPECTED RESULT: Table previews correctly, so expected to be able to make the hive table
ACTUAL RESULT: Ambari view throws the 'E090 HiveClientFormattedException' error, and the hiverserver2.log
file throws the following error:

2016-08-01 15:29:57,284 INFO  [HiveServer2-Handler-Pool: Thread-32]: parse.ParseDriver (ParseDriver.java:parse(185))
- Parsing command: create table recordsView2 (�nengetu INT, kanji STRING) STORED AS ORC
2016-08-01 15:29:57,285 ERROR [HiveServer2-Handler-Pool: Thread-32]: ql.Driver (SessionState.java:printError(932))
- FAILED: ParseException line 1:27 character '�' not supported here
org.apache.hadoop.hive.ql.parse.ParseException: line 1:27 character '�' not supported here
	at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:211)
	at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:166)
	at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:428)
	at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:316)
	at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1181)
	at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1175)
	at org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:110)
	at org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:181)
	at org.apache.hive.service.cli.operation.Operation.run(Operation.java:257)
	at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:419)
	at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:406)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:78)
	at org.apache.hive.service.cli.session.HiveSessionProxy.access$000(HiveSessionProxy.java:36)
	at org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:63)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAs(Subject.java:415)
	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657)
	at org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:59)
	at com.sun.proxy.$Proxy19.executeStatementAsync(Unknown Source)
	at org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:274)
	at org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:486)
	at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1317)
	at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1302)
	at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
	at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
	at org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56)
	at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:285)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:745)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message