使用indexr的tools工具创建了table，但是在drill中查看不到。 about indexr HOT 9 CLOSED

can‘t find table in drill console ，but find in tools.sh. just like the pictures describer

from indexr.

Hi AisTop,

Can you check the errors in drillbit.log?
If you want to check more details, set the log level of "io.indexr" to "info" in $DRILL_HOME/conf/logback.xml.

from indexr.

Hi flowbehappy ,thinks you answer very much.
i changed the logback.xml ,then i restart the drill and find some error in the drillbit.lgo 。
05:01:44.717 [main] WARN org.reflections.Reflections - could not scan file /opt/baian/drill/jars/drill-indexr-storage-1.8.0.jar!/org/apache/drill/exec/store/indexr/IndexRRecordReaderByPack.class with scanner AnnotationScanner
org.reflections.ReflectionsException: could not create class file from IndexRRecordReaderByPack.class
at org.reflections.scanners.AbstractScanner.scan(AbstractScanner.java:30) ~[reflections-0.9.8.jar:na]
at org.reflections.Reflections.scan(Reflections.java:217) [reflections-0.9.8.jar:na]
at org.reflections.Reflections.scan(Reflections.java:166) [reflections-0.9.8.jar:na]
at org.reflections.Reflections.(Reflections.java:94) [reflections-0.9.8.jar:na]
at org.apache.drill.common.scanner.ClassPathScanner.scan(ClassPathScanner.java:402) [drill-common-1.9.0.jar:1.9.0]
at org.apache.drill.common.scanner.RunTimeScan.fromPrescan(RunTimeScan.java:62) [drill-common-1.9.0.jar:1.9.0]
at org.apache.drill.common.scanner.ClassPathScanner.fromPrescan(ClassPathScanner.java:452) [drill-common-1.9.0.jar:1.9.0]
at org.apache.drill.exec.expr.fn.HiveFunctionRegistry.(HiveFunctionRegistry.java:67) [drill-storage-hive-core-1.9.0.jar:1.9.0]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [na:1.8.0_40]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [na:1.8.0_40]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [na:1.8.0_40]
at java.lang.reflect.Constructor.newInstance(Constructor.java:422) [na:1.8.0_40]
at org.apache.drill.exec.expr.fn.FunctionImplementationRegistry.(FunctionImplementationRegistry.java:110) [drill-java-exec-1.9.0.jar:1.9.0]
at org.apache.drill.exec.expr.fn.FunctionImplementationRegistry.(FunctionImplementationRegistry.java:125) [drill-java-exec-1.9.0.jar:1.9.0]
at org.apache.drill.exec.server.DrillbitContext.(DrillbitContext.java:92) [drill-java-exec-1.9.0.jar:1.9.0]
at org.apache.drill.exec.work.WorkManager.start(WorkManager.java:106) [drill-java-exec-1.9.0.jar:1.9.0]
at org.apache.drill.exec.server.Drillbit.run(Drillbit.java:120) [drill-java-exec-1.9.0.jar:1.9.0]
at org.apache.drill.exec.server.Drillbit.start(Drillbit.java:292) [drill-java-exec-1.9.0.jar:1.9.0]
at org.apache.drill.exec.server.Drillbit.start(Drillbit.java:272) [drill-java-exec-1.9.0.jar:1.9.0]
at org.apache.drill.exec.server.Drillbit.main(Drillbit.java:268) [drill-java-exec-1.9.0.jar:1.9.0]
Caused by: org.reflections.ReflectionsException: could not create class file from IndexRRecordReaderByPack.class
at org.reflections.adapters.JavassistAdapter.createClassObject(JavassistAdapter.java:128) ~[reflections-0.9.8.jar:na]
at org.reflections.adapters.JavassistAdapter.getOfCreateClassObject(JavassistAdapter.java:118) ~[reflections-0.9.8.jar:na]
at org.reflections.adapters.JavassistAdapter.getOfCreateClassObject(JavassistAdapter.java:26) ~[reflections-0.9.8.jar:na]
at org.reflections.scanners.AbstractScanner.scan(AbstractScanner.java:27) ~[reflections-0.9.8.jar:na]
... 19 common frames omitted
Caused by: java.io.IOException: invalid constant type: 18
at javassist.bytecode.ConstPool.readOne(ConstPool.java:1090) ~[javassist-3.12.1.GA.jar:na]
at javassist.bytecode.ConstPool.read(ConstPool.java:1033) ~[javassist-3.12.1.GA.jar:na]
at javassist.bytecode.ConstPool.(ConstPool.java:149) ~[javassist-3.12.1.GA.jar:na]
at javassist.bytecode.ClassFile.read(ClassFile.java:737) ~[javassist-3.12.1.GA.jar:na]
at javassist.bytecode.ClassFile.(ClassFile.java:108) ~[javassist-3.12.1.GA.jar:na]
at org.reflections.adapters.JavassistAdapter.createClassObject(JavassistAdapter.java:126) ~[reflections-0.9.8.jar:na]
... 22 common frames omitted

from indexr.

i can‘t solve this by my self ,thinks you very much!

from indexr.

Hi AisTop,

It looks like your jre does not support the class version. IndexR only support Java 1.8+. You should check your jre version.

from indexr.

Hi flowbehappy think you , i find it.
it's my mistake ,because my test_exmple.json is not right ，kafka is not config 。so can‘t receive data from the kafka topic .
i try the sample test.json the content is ;
{
"schema":{
"columns":
[
{"name": "date", "dataType": "int"},
{"name": "d1", "dataType": "string"},
{"name": "m1", "dataType": "int"},
{"name": "m2", "dataType": "long"},
{"name": "m3", "dataType": "float"},
{"name": "m4", "dataType": "double"}
]
}
}

create talbe
./tools.sh -cmd settb -t hjjtest -c test_schem.json

in the finally i succeess find the reson.

from indexr.

I notice that you running Drill 1.9, and IndexR plugin is compiled under Drill 1.8, maybe that is the root cause. I will push a indexr-drill-1.9.0 later.

from indexr.

Hi AisTop,
Happy to see you make it :)

from indexr.

i will set the kafka topic and to check the issue. think you .

from indexr.