hive-hbase integration throws classnotfoundexception NULL::character varying -

-

following link https://cwiki.apache.org/confluence/display/hive/hbaseintegration#hbaseintegration-hivemaptohbasecolumnfamily

i'm trying integrate hive , hbase, have configuration in hive-site.xml:

<property>   <name>hive.aux.jars.path</name>   <value>     file:///$hive_home/lib/hive-hbase-handler-2.0.0.jar,     file:///$hive_home/lib/hive-ant-2.0.0.jar,     file:///$hive_home/lib/protobuf-java-2.5.0.jar,     file:///$hive_home/lib/hbase-client-1.1.1.jar,     file:///$hive_home/lib/hbase-common-1.1.1.jar,     file:///$hive_home/lib/zookeeper-3.4.6.jar,     file:///$hive_home/lib/guava-14.0.1.jar   </value> </property>

then create table named 'ts:testtable' in hbase:

hbase> create 'ts:testtable','pokes' hbase> put 'ts:testtable', '10000', 'pokes:value','val_10000' hbase> put 'ts:testtable', '10001', 'pokes:value','val_10001' ...  hbase> scan  'ts:testtable' row                       column+cell  10000                    column=pokes:value, timestamp=1462782972084, value=val_10000  10001                    column=pokes:value, timestamp=1462783514212, value=val_10001 ....

and create external table in hive:

hive> create external table hbase_test_table(key int, value string )        stored 'org.apache.hadoop.hive.hbase.hbasestoragehandler'        serdeproperties ("hbase.columns.mapping" = ":key, pokes:value")        tblproperties ("hbase.table.name" = "ts:testtable",        "hbase.mapred.output.outputtable" = "ts:testtable");

so far good. when tried select data test table, exception thrown:

hive> select * hbase_test_table; failed: runtimeexception java.lang.classnotfoundexception: null::character varying error: error while compiling statement: failed: runtimeexception java.lang.classnotfoundexception: null::character varying (state=42000,code=40000)

am missing anything?

i'm trying hive 2.0.0 around hbase 1.2.1

ok, figured out, "null::character varying" not part of hive, coming postgresql, i'm using end of metastore. problem hive doesn't recognizes exception postgresql. have following code hive 2.0.0:

300: if (inputformatclass == null) { 301:   try { 302:     string classname = ttable.getsd().getinputformat(); 303:     if (classname == null) { 304:       if (getstoragehandler() == null) { 305:         return null; 306:       } 307:      inputformatclass = getstoragehandler().getinputformatclass(); 308:  } else { 309:  inputformatclass = (class<? extends inputformat>) 310:    class.forname(classname, true, utilities.getsessionspecifiedclassloader());     }

line 302 not return null supposed to. line 310 try load non-existing class in. that's reason why program failed.

i believe compatible bug, way fix change database hate to. replaced 302 with

if (classname == null || classname.tolowercase().startswith("null::")) {

and same thing getoutputformat() method, re-compile jar, that's it.


Comments

Post a Comment

Popular posts from this blog

javascript - Laravel datatable invalid JSON response -

-
everything work fine on code below fetch user logs: js: <script> $(document).ready(function () { var table =$('#systemlogs').datatable({ responsive: true, processing: true, serverside: true, "language": { "url": "/datatables/media/plug-in/persian.json" }, ajax: '{!! url('/admin/systemlogs/data/systemlogsdatatable') !!}', columns: [ { data: 'name', name: 'name' }, { data: 'message_text', name: 'message_text' }, { data: 'remote_addr', name: 'remote_addr' }, { data: 'log_created_at', name: 'management_logs.created_at' }, { data: 'log_updated_at', name: 'management_logs.updated_at' }, ] }); }); </script> routes: route::get('/systemlogs/data/systemlogsdatatable','systemlogscontrolle...
Read more

java - Exception in thread "main" org.springframework.context.ApplicationContextException: Unable to start embedded container; -

-
i getting error when run spring application: exception in thread "main" org.springframework.context.applicationcontextexception: unable start embedded container; nested exception org.springframework.context.applicationcontextexception: unable start embeddedwebapplicationcontext due missing embeddedservletcontainerfactory bean. @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.onrefresh(embeddedwebapplicationcontext.java:124) @ org.springframework.context.support.abstractapplicationcontext.refresh(abstractapplicationcontext.java:476) @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.refresh(embeddedwebapplicationcontext.java:109) @ org.springframework.boot.springapplication.refresh(springapplication.java:691) @ org.springframework.boot.springapplication.run(springapplication.java:320) @ org.springframework.boot.springapplication.run(springapplication.java:952) @ org.springframework.boot.springa...
Read more

sql server 2008 - My Sql Code Get An Error Of Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value '8:45 AM' to data type int -

-
msg 245, level 16, state 1, line 1 conversion failed when converting varchar value '8:45 am' data type int. script declare @specimenid bigint = 0, @script varchar(max); declare @starttime int = (select convert(int,substring(start_time,0,charindex(':', start_time)) - 12) appt appt._id=112601) --select @starttime set @script = 'select distinct ptlast_name + '', '' + pt.first_name patient_name, dbo.formatdate(pt.dob,''mm/dd/yyyy'') dob, (convert(varchar, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end)) + ''/'' + convert(varchar, (datediff(m, dateadd(yy, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end), d...
Read more