Member since
12-11-2015
1
Post
0
Kudos Received
0
Solutions
12-11-2015
12:48 AM
I was following this http://www.thecloudavenue.com/2013/03/analyse-tweets-using-flume-hadoop-and.html tutorial after collecting the twitter data into hdfs i imported it to a hive tweets table and everything worked fine. But on clicking on browse data, I get this error. Cannot read table
Bad status for request TExecuteStatementReq(confOverlay={}, sessionHandle=TSessionHandle(sessionId=THandleIdentifier(secret="\x06{'\xb6\x1d\x13Dx\x90\x86^\xfc\xb6\xf9\\L", guid='m\xf3\x99\x81-\xb4L\xcc\x86\xc9(a\xcfP\xffc')), runAsync=True, statement='SELECT * FROM `tweeter_analysis.tweets` LIMIT 250'): TExecuteStatementResp(status=TStatus(errorCode=40000, errorMessage='Error while compiling statement: FAILED: RuntimeException org.apache.hadoop.hive.ql.metadata.HiveException: Failed with exception nulljava.lang.NullPointerException\n\tat org.apache.hadoop.hive.ql.exec.FetchOperator.needConversion(FetchOperator.java:607)\n\tat org.apache.hadoop.hive.ql.exec.FetchOperator.setupOutputObjectInspector(FetchOperator.java:578)\n\tat org.apache.hadoop.hive.ql.exec.FetchOperator.initialize(FetchOperator.java:172)\n\tat org.apache.hadoop.hive.ql.exec.FetchOperator.<init>(FetchOperator.java:140)\n\tat org.apache.hadoop.hive.ql.exec.FetchTask.initialize(FetchTask.java:79)\n\tat org.apache.hadoop.hive.ql.Driver.compile(Driver.java:453)\n\tat org.apache.hadoop.hive.ql.Driver.compile(Driver.java:307)\n\tat org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1110)\n\tat org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1104)\n\tat org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:101)\n\tat org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:172)\n\tat org.apache.hive.service.cli.operation.Operation.run(Operation.java:257)\n\tat org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:386)\n\tat org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:373)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:606)\n\tat org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:78)\n\tat org.apache.hive.service.cli.session.HiveSessionProxy.access$000(HiveSessionProxy.java:36)\n\tat org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:63)\n\tat java.security.AccessController.doPrivileged(Native Method)\n\tat javax.security.auth.Subject.doAs(Subject.java:415)\n\tat org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1671)\n\tat org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:59)\n\tat com.sun.proxy.$Proxy23.executeStatementAsync(Unknown Source)\n\tat org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:271)\n\tat org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:486)\n\tat org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1313)\n\tat org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1298)\n\tat org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)\n\tat org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)\n\tat org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56)\n\tat org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:285)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)\n\tat java.lang.Thread.run(Thread.java:745)\n', sqlState='42000', infoMessages=['*org.apache.hive.service.cli.HiveSQLException:Error while compiling statement: FAILED: RuntimeException org.apache.hadoop.hive.ql.metadata.HiveException: Failed with exception nulljava.lang.NullPointerException\n\tat org.apache.hadoop.hive.ql.exec.FetchOperator.needConversion(FetchOperator.java:607)\n\tat org.apache.hadoop.hive.ql.exec.FetchOperator.setupOutputObjectInspector(FetchOperator.java:578)\n\tat org.apache.hadoop.hive.ql.exec.FetchOperator.initialize(FetchOperator.java:172)\n\tat org.apache.hadoop.hive.ql.exec.FetchOperator.<init>(FetchOperator.java:140)\n\tat org.apache.hadoop.hive.ql.exec.FetchTask.initialize(FetchTask.java:79)\n\tat org.apache.hadoop.hive.ql.Driver.compile(Driver.java:453)\n\tat org.apache.hadoop.hive.ql.Driver.compile(Driver.java:307)\n\tat org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1110)\n\tat org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1104)\n\tat org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:101)\n\tat org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:172)\n\tat org.apache.hive.service.cli.operation.Operation.run(Operation.java:257)\n\tat org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:386)\n\tat org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:373)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:606)\n\tat org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:78)\n\tat org.apache.hive.service.cli.session.HiveSessionProxy.access$000(HiveSessionProxy.java:36)\n\tat org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:63)\n\tat java.security.AccessController.doPrivileged(Native Method)\n\tat javax.security.auth.Subject.doAs(Subject.java:415)\n\tat org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1671)\n\tat org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:59)\n\tat com.sun.proxy.$Proxy23.executeStatementAsync(Unknown Source)\n\tat org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:271)\n\tat org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:486)\n\tat org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1313)\n\tat org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1298)\n\tat org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)\n\tat org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)\n\tat org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56)\n\tat org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:285)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)\n\tat java.lang.Thread.run(Thread.java:745)\n:29:28', 'org.apache.hive.service.cli.operation.Operation:toSQLException:Operation.java:315', 'org.apache.hive.service.cli.operation.SQLOperation:prepare:SQLOperation.java:103', 'org.apache.hive.service.cli.operation.SQLOperation:runInternal:SQLOperation.java:172', 'org.apache.hive.service.cli.operation.Operation:run:Operation.java:257', 'org.apache.hive.service.cli.session.HiveSessionImpl:executeStatementInternal:HiveSessionImpl.java:386', 'org.apache.hive.service.cli.session.HiveSessionImpl:executeStatementAsync:HiveSessionImpl.java:373', 'sun.reflect.NativeMethodAccessorImpl:invoke0:NativeMethodAccessorImpl.java:-2', 'sun.reflect.NativeMethodAccessorImpl:invoke:NativeMethodAccessorImpl.java:57', 'sun.reflect.DelegatingMethodAccessorImpl:invoke:DelegatingMethodAccessorImpl.java:43', 'java.lang.reflect.Method:invoke:Method.java:606', 'org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:78', 'org.apache.hive.service.cli.session.HiveSessionProxy:access$000:HiveSessionProxy.java:36', 'org.apache.hive.service.cli.session.HiveSessionProxy$1:run:HiveSessionProxy.java:63', 'java.security.AccessController:doPrivileged:AccessController.java:-2', 'javax.security.auth.Subject:doAs:Subject.java:415', 'org.apache.hadoop.security.UserGroupInformation:doAs:UserGroupInformation.java:1671', 'org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:59', 'com.sun.proxy.$Proxy23:executeStatementAsync::-1', 'org.apache.hive.service.cli.CLIService:executeStatementAsync:CLIService.java:271', 'org.apache.hive.service.cli.thrift.ThriftCLIService:ExecuteStatement:ThriftCLIService.java:486', 'org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement:getResult:TCLIService.java:1313', 'org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement:getResult:TCLIService.java:1298', 'org.apache.thrift.ProcessFunction:process:ProcessFunction.java:39', 'org.apache.thrift.TBaseProcessor:process:TBaseProcessor.java:39', 'org.apache.hive.service.auth.TSetIpAddressProcessor:process:TSetIpAddressProcessor.java:56', 'org.apache.thrift.server.TThreadPoolServer$WorkerProcess:run:TThreadPoolServer.java:285', 'java.util.concurrent.ThreadPoolExecutor:runWorker:ThreadPoolExecutor.java:1145', 'java.util.concurrent.ThreadPoolExecutor$Worker:run:ThreadPoolExecutor.java:615', 'java.lang.Thread:run:Thread.java:745', '*java.lang.RuntimeException:org.apache.hadoop.hive.ql.metadata.HiveException: Failed with exception nulljava.lang.NullPointerException\n\tat org.apache.hadoop.hive.ql.exec.FetchOperator.needConversion(FetchOperator.java:607)\n\tat org.apache.hadoop.hive.ql.exec.FetchOperator.setupOutputObjectInspector(FetchOperator.java:578)\n\tat org.apache.hadoop.hive.ql.exec.FetchOperator.initialize(FetchOperator.java:172)\n\tat org.apache.hadoop.hive.ql.exec.FetchOperator.<init>(FetchOperator.java:140)\n\tat org.apache.hadoop.hive.ql.exec.FetchTask.initialize(FetchTask.java:79)\n\tat org.apache.hadoop.hive.ql.Driver.compile(Driver.java:453)\n\tat org.apache.hadoop.hive.ql.Driver.compile(Driver.java:307)\n\tat org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1110)\n\tat org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1104)\n\tat org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:101)\n\tat org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:172)\n\tat org.apache.hive.service.cli.operation.Operation.run(Operation.java:257)\n\tat org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:386)\n\tat org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:373)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:606)\n\tat org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:78)\n\tat org.apache.hive.service.cli.session.HiveSessionProxy.access$000(HiveSessionProxy.java:36)\n\tat org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:63)\n\tat java.security.AccessController.doPrivileged(Native Method)\n\tat javax.security.auth.Subject.doAs(Subject.java:415)\n\tat org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1671)\n\tat org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:59)\n\tat com.sun.proxy.$Proxy23.executeStatementAsync(Unknown Source)\n\tat org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:271)\n\tat org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:486)\n\tat org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1313)\n\tat org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1298)\n\tat org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)\n\tat org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)\n\tat org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56)\n\tat org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:285)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)\n\tat java.lang.Thread.run(Thread.java:745)\n:33:5', 'org.apache.hadoop.hive.ql.exec.FetchTask:initialize:FetchTask.java:87', 'org.apache.hadoop.hive.ql.Driver:compile:Driver.java:453', 'org.apache.hadoop.hive.ql.Driver:compile:Driver.java:307', 'org.apache.hadoop.hive.ql.Driver:compileInternal:Driver.java:1110', 'org.apache.hadoop.hive.ql.Driver:compileAndRespond:Driver.java:1104', 'org.apache.hive.service.cli.operation.SQLOperation:prepare:SQLOperation.java:101', '*org.apache.hadoop.hive.ql.metadata.HiveException:Failed with exception nulljava.lang.NullPointerException\n\tat org.apache.hadoop.hive.ql.exec.FetchOperator.needConversion(FetchOperator.java:607)\n\tat org.apache.hadoop.hive.ql.exec.FetchOperator.setupOutputObjectInspector(FetchOperator.java:578)\n\tat org.apache.hadoop.hive.ql.exec.FetchOperator.initialize(FetchOperator.java:172)\n\tat org.apache.hadoop.hive.ql.exec.FetchOperator.<init>(FetchOperator.java:140)\n\tat org.apache.hadoop.hive.ql.exec.FetchTask.initialize(FetchTask.java:79)\n\tat org.apache.hadoop.hive.ql.Driver.compile(Driver.java:453)\n\tat org.apache.hadoop.hive.ql.Driver.compile(Driver.java:307)\n\tat org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1110)\n\tat org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1104)\n\tat org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:101)\n\tat org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:172)\n\tat org.apache.hive.service.cli.operation.Operation.run(Operation.java:257)\n\tat org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:386)\n\tat org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:373)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:606)\n\tat org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:78)\n\tat org.apache.hive.service.cli.session.HiveSessionProxy.access$000(HiveSessionProxy.java:36)\n\tat org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:63)\n\tat java.security.AccessController.doPrivileged(Native Method)\n\tat javax.security.auth.Subject.doAs(Subject.java:415)\n\tat org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1671)\n\tat org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:59)\n\tat com.sun.proxy.$Proxy23.executeStatementAsync(Unknown Source)\n\tat org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:271)\n\tat org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:486)\n\tat org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1313)\n\tat org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1298)\n\tat org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)\n\tat org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)\n\tat org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56)\n\tat org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:285)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)\n\tat java.lang.Thread.run(Thread.java:745)\n:36:3', 'org.apache.hadoop.hive.ql.exec.FetchOperator:setupOutputObjectInspector:FetchOperator.java:585', 'org.apache.hadoop.hive.ql.exec.FetchOperator:initialize:FetchOperator.java:172', 'org.apache.hadoop.hive.ql.exec.FetchOperator:<init>:FetchOperator.java:140', 'org.apache.hadoop.hive.ql.exec.FetchTask:initialize:FetchTask.java:79'], statusCode=3), operationHandle=None) On clicking the more info link i get this. File Name Line Number Function Name /usr/lib/hue/apps/metastore/src/metastore/views.py 213 read_table /usr/lib/hue/apps/beeswax/src/beeswax/server/dbms.py 150 select_star_from /usr/lib/hue/apps/beeswax/src/beeswax/server/dbms.py 158 execute_statement /usr/lib/hue/apps/beeswax/src/beeswax/server/dbms.py 461 execute_and_watch Any help would really be appreciated. Am using cloudera quick start vm and am new to hadoop.
... View more
- Tags:
- browse data
- error
- hue