Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hue beeswax browse data error.

Highlighted

Hue beeswax browse data error.

New Contributor

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.

2 REPLIES 2

Re: Hue beeswax browse data error.

Master Guru
Does running the below query work, directly?

SELECT * FROM `tweeter_analysis.tweets` LIMIT 250

Re: Hue beeswax browse data error.

Is the error only on SELECT * on the tweet table?