Re: Drill embedded mode on Linux
Hi Jaims, I installed devel distro and it worked. Thanks for your help. Regards Prabhakar On Thu, Apr 9, 2020, 19:57 Prabhakar Bhosaale wrote: > Thanks Jaims, This helps. I have only openJDK. I will get the devel and > will update you. > > Regards > Prabhakar > > On Thu, Apr 9, 2020 at 7:53 PM Rafael Jaimes III > wrote: > >> Prab, >> >> I don't think screenshots work on the list. What distro are you using? >> >> On Red Hat, OpenJDK is a JRE but OpenJDK-devel has the JDK. It may be >> confusing. >> >> On Thu, Apr 9, 2020, 10:17 AM Prabhakar Bhosaale >> wrote: >> >> > Hi All, >> > >> > Just to give you some additional information. I came across information >> on >> > >> http://www.openkb.info/2017/05/drill-errors-with-jdk-java-compiler-not.html >> > >> > >> > As per this article, my output of step 2 is not as expected. But this >> > article does not mention what to do in this case. thx >> > >> > Regards >> > Prabhakar >> > >> > On Thu, Apr 9, 2020 at 7:37 PM Prabhakar Bhosaale < >> bhosale@gmail.com> >> > wrote: >> > >> >> Hi James, >> >> thanks for quick reply. >> >> Below is Java version screenshot. As per documentation this is correct. >> >> [image: image.png] >> >> >> >> Below is screenshot of java path. this is also correct. But still same >> >> error >> >> [image: image.png] >> >> >> >> Regards >> >> Prabhakar >> >> >> >> On Thu, Apr 9, 2020 at 7:08 PM Jaimes, Rafael - 0993 - MITLL < >> >> rafael.jai...@ll.mit.edu> wrote: >> >> >> >>> The error tells you that it's not finding a Java 1.8 JDK. You can use >> >>> OpenJDK >> >>> 1.8 for the job. >> >>> I would check: >> >>> 1) your java version (both version # and whether it is a JDK, not a >> JRE) >> >>> 2) your java path env vars >> >>> >> >>> -Original Message- >> >>> From: Prabhakar Bhosaale >> >>> Sent: Thursday, April 9, 2020 9:29 AM >> >>> To: user@drill.apache.org >> >>> Subject: Drill embedded mode on Linux >> >>> >> >>> Hi All, >> >>> I am using drill 1.16 and trying to start the drill in embedded mode >> on >> >>> linux >> >>> machine. Following the documentation from drill website. >> >>> >> >>> I am using bin/drill-embedded command but it is giving following >> error. >> >>> Checked the java version and it is correct. Please help urgently. thx >> >>> >> >>> Regards >> >>> Prabhakar >> >>> >> >>> Error: Failure in starting embedded Drillbit: >> >>> org.apache.drill.exec.exception.DrillbitStartupException: JDK Java >> >>> compiler >> >>> not available. Ensure Drill is running with the java executable from a >> >>> JDK and >> >>> not a JRE (state=,code=0) >> >>> java.sql.SQLException: Failure in starting embedded Drillbit: >> >>> org.apache.drill.exec.exception.DrillbitStartupException: JDK Java >> >>> compiler >> >>> not available. Ensure Drill is running with the java executable from a >> >>> JDK and >> >>> not a JRE >> >>> at >> >>> >> >>> >> org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:143) >> >>> at >> >>> >> >>> >> org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:67) >> >>> at >> >>> >> >>> >> org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:67) >> >>> at >> >>> >> >>> >> org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:138) >> >>> at org.apache.drill.jdbc.Driver.connect(Driver.java:72) >> >>> at >> >>> sqlline.DatabaseConnection.connect(DatabaseConnection.java:130) >> >>> at >> >>> sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:179) >> >>> at sqlline.Commands.connect(Commands.java:1278) >> >>> at sqlline.Comman
RE: Drill embedded mode on Linux
filed https://issues.apache.org/jira/browse/DRILL-7695 -Original Message- From: Paul Rogers Sent: Thursday, April 9, 2020 3:24 PM To: user@drill.apache.org Subject: Re: Drill embedded mode on Linux Hi Prabhakar, Rafael has pointed you in the right direction. Drill does code generation at run time and for that it needs the Java compiler which requires the JDK, not just the JRE. I do development on Linux (Ubuntu-based Linux Mint) and was able to install the JDK. It's been awhile so I don't recall exactly what I did. Which distro are you using? There are different ways to install the JDK depending on your distro. I find a Google search often reveals the correct path for each. That you have to ask this question shows a hole in the Drill documentation. Please file a JIRA ticket to describe the problem. Once you find how to install the JDK on your distro, please add that to the ticket so we can update the docs. Thanks, - Paul On Thursday, April 9, 2020, 7:27:58 AM PDT, Prabhakar Bhosaale wrote: Thanks Jaims, This helps. I have only openJDK. I will get the devel and will update you. Regards Prabhakar On Thu, Apr 9, 2020 at 7:53 PM Rafael Jaimes III wrote: > Prab, > > I don't think screenshots work on the list. What distro are you using? > > On Red Hat, OpenJDK is a JRE but OpenJDK-devel has the JDK. It may be > confusing. > > On Thu, Apr 9, 2020, 10:17 AM Prabhakar Bhosaale > > wrote: > > > Hi All, > > > > Just to give you some additional information. I came across > > information > on > > > http://www.openkb.info/2017/05/drill-errors-with-jdk-java-compiler-not > .html > > > > > > As per this article, my output of step 2 is not as expected. But > > this article does not mention what to do in this case. thx > > > > Regards > > Prabhakar > > > > On Thu, Apr 9, 2020 at 7:37 PM Prabhakar Bhosaale > > > > > wrote: > > > >> Hi James, > >> thanks for quick reply. > >> Below is Java version screenshot. As per documentation this is correct. > >> [image: image.png] > >> > >> Below is screenshot of java path. this is also correct. But still > >> same error > >> [image: image.png] > >> > >> Regards > >> Prabhakar > >> > >> On Thu, Apr 9, 2020 at 7:08 PM Jaimes, Rafael - 0993 - MITLL < > >> rafael.jai...@ll.mit.edu> wrote: > >> > >>> The error tells you that it's not finding a Java 1.8 JDK. You can > >>> use OpenJDK > >>> 1.8 for the job. > >>> I would check: > >>> 1) your java version (both version # and whether it is a JDK, not > >>> a > JRE) > >>> 2) your java path env vars > >>> > >>> -Original Message- > >>> From: Prabhakar Bhosaale > >>> Sent: Thursday, April 9, 2020 9:29 AM > >>> To: user@drill.apache.org > >>> Subject: Drill embedded mode on Linux > >>> > >>> Hi All, > >>> I am using drill 1.16 and trying to start the drill in embedded > >>> mode on linux machine. Following the documentation from drill > >>> website. > >>> > >>> I am using bin/drill-embedded command but it is giving following > error. > >>> Checked the java version and it is correct. Please help urgently. > >>> thx > >>> > >>> Regards > >>> Prabhakar > >>> > >>> Error: Failure in starting embedded Drillbit: > >>> org.apache.drill.exec.exception.DrillbitStartupException: JDK Java > >>>compiler not available. Ensure Drill is running with the java > >>>executable from a JDK and not a JRE (state=,code=0) > >>> java.sql.SQLException: Failure in starting embedded Drillbit: > >>> org.apache.drill.exec.exception.DrillbitStartupException: JDK Java > >>>compiler not available. Ensure Drill is running with the java > >>>executable from a JDK and not a JRE > >>>at > >>> > >>> > org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionI > mpl.java:143) > >>>at > >>> > >>> > org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(Drill > Jdbc41Factory.java:67) > >>>at > >>> > >>> > org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.jav > a:67) > >>>at > >>> > >>> > org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriv > er.java:138) > >>&
Re: Drill embedded mode on Linux
Hi Prabhakar, Rafael has pointed you in the right direction. Drill does code generation at run time and for that it needs the Java compiler which requires the JDK, not just the JRE. I do development on Linux (Ubuntu-based Linux Mint) and was able to install the JDK. It's been awhile so I don't recall exactly what I did. Which distro are you using? There are different ways to install the JDK depending on your distro. I find a Google search often reveals the correct path for each. That you have to ask this question shows a hole in the Drill documentation. Please file a JIRA ticket to describe the problem. Once you find how to install the JDK on your distro, please add that to the ticket so we can update the docs. Thanks, - Paul On Thursday, April 9, 2020, 7:27:58 AM PDT, Prabhakar Bhosaale wrote: Thanks Jaims, This helps. I have only openJDK. I will get the devel and will update you. Regards Prabhakar On Thu, Apr 9, 2020 at 7:53 PM Rafael Jaimes III wrote: > Prab, > > I don't think screenshots work on the list. What distro are you using? > > On Red Hat, OpenJDK is a JRE but OpenJDK-devel has the JDK. It may be > confusing. > > On Thu, Apr 9, 2020, 10:17 AM Prabhakar Bhosaale > wrote: > > > Hi All, > > > > Just to give you some additional information. I came across information > on > > > http://www.openkb.info/2017/05/drill-errors-with-jdk-java-compiler-not.html > > > > > > As per this article, my output of step 2 is not as expected. But this > > article does not mention what to do in this case. thx > > > > Regards > > Prabhakar > > > > On Thu, Apr 9, 2020 at 7:37 PM Prabhakar Bhosaale > > > wrote: > > > >> Hi James, > >> thanks for quick reply. > >> Below is Java version screenshot. As per documentation this is correct. > >> [image: image.png] > >> > >> Below is screenshot of java path. this is also correct. But still same > >> error > >> [image: image.png] > >> > >> Regards > >> Prabhakar > >> > >> On Thu, Apr 9, 2020 at 7:08 PM Jaimes, Rafael - 0993 - MITLL < > >> rafael.jai...@ll.mit.edu> wrote: > >> > >>> The error tells you that it's not finding a Java 1.8 JDK. You can use > >>> OpenJDK > >>> 1.8 for the job. > >>> I would check: > >>> 1) your java version (both version # and whether it is a JDK, not a > JRE) > >>> 2) your java path env vars > >>> > >>> -Original Message- > >>> From: Prabhakar Bhosaale > >>> Sent: Thursday, April 9, 2020 9:29 AM > >>> To: user@drill.apache.org > >>> Subject: Drill embedded mode on Linux > >>> > >>> Hi All, > >>> I am using drill 1.16 and trying to start the drill in embedded mode on > >>> linux > >>> machine. Following the documentation from drill website. > >>> > >>> I am using bin/drill-embedded command but it is giving following > error. > >>> Checked the java version and it is correct. Please help urgently. thx > >>> > >>> Regards > >>> Prabhakar > >>> > >>> Error: Failure in starting embedded Drillbit: > >>> org.apache.drill.exec.exception.DrillbitStartupException: JDK Java > >>> compiler > >>> not available. Ensure Drill is running with the java executable from a > >>> JDK and > >>> not a JRE (state=,code=0) > >>> java.sql.SQLException: Failure in starting embedded Drillbit: > >>> org.apache.drill.exec.exception.DrillbitStartupException: JDK Java > >>> compiler > >>> not available. Ensure Drill is running with the java executable from a > >>> JDK and > >>> not a JRE > >>> at > >>> > >>> > org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:143) > >>> at > >>> > >>> > org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:67) > >>> at > >>> > >>> > org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:67) > >>> at > >>> > >>> > org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:138) > >>> at org.apache.drill.jdbc.Driver.connect(Driver.java:72) > >>> at > >>> sqlline.DatabaseConnection.connect(DatabaseConnection.java:130) > >>> at > >>> s
Re: Drill embedded mode on Linux
Thanks Jaims, This helps. I have only openJDK. I will get the devel and will update you. Regards Prabhakar On Thu, Apr 9, 2020 at 7:53 PM Rafael Jaimes III wrote: > Prab, > > I don't think screenshots work on the list. What distro are you using? > > On Red Hat, OpenJDK is a JRE but OpenJDK-devel has the JDK. It may be > confusing. > > On Thu, Apr 9, 2020, 10:17 AM Prabhakar Bhosaale > wrote: > > > Hi All, > > > > Just to give you some additional information. I came across information > on > > > http://www.openkb.info/2017/05/drill-errors-with-jdk-java-compiler-not.html > > > > > > As per this article, my output of step 2 is not as expected. But this > > article does not mention what to do in this case. thx > > > > Regards > > Prabhakar > > > > On Thu, Apr 9, 2020 at 7:37 PM Prabhakar Bhosaale > > > wrote: > > > >> Hi James, > >> thanks for quick reply. > >> Below is Java version screenshot. As per documentation this is correct. > >> [image: image.png] > >> > >> Below is screenshot of java path. this is also correct. But still same > >> error > >> [image: image.png] > >> > >> Regards > >> Prabhakar > >> > >> On Thu, Apr 9, 2020 at 7:08 PM Jaimes, Rafael - 0993 - MITLL < > >> rafael.jai...@ll.mit.edu> wrote: > >> > >>> The error tells you that it's not finding a Java 1.8 JDK. You can use > >>> OpenJDK > >>> 1.8 for the job. > >>> I would check: > >>> 1) your java version (both version # and whether it is a JDK, not a > JRE) > >>> 2) your java path env vars > >>> > >>> -Original Message- > >>> From: Prabhakar Bhosaale > >>> Sent: Thursday, April 9, 2020 9:29 AM > >>> To: user@drill.apache.org > >>> Subject: Drill embedded mode on Linux > >>> > >>> Hi All, > >>> I am using drill 1.16 and trying to start the drill in embedded mode on > >>> linux > >>> machine. Following the documentation from drill website. > >>> > >>> I am using bin/drill-embedded command but it is giving following > error. > >>> Checked the java version and it is correct. Please help urgently. thx > >>> > >>> Regards > >>> Prabhakar > >>> > >>> Error: Failure in starting embedded Drillbit: > >>> org.apache.drill.exec.exception.DrillbitStartupException: JDK Java > >>> compiler > >>> not available. Ensure Drill is running with the java executable from a > >>> JDK and > >>> not a JRE (state=,code=0) > >>> java.sql.SQLException: Failure in starting embedded Drillbit: > >>> org.apache.drill.exec.exception.DrillbitStartupException: JDK Java > >>> compiler > >>> not available. Ensure Drill is running with the java executable from a > >>> JDK and > >>> not a JRE > >>> at > >>> > >>> > org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:143) > >>> at > >>> > >>> > org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:67) > >>> at > >>> > >>> > org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:67) > >>> at > >>> > >>> > org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:138) > >>> at org.apache.drill.jdbc.Driver.connect(Driver.java:72) > >>> at > >>> sqlline.DatabaseConnection.connect(DatabaseConnection.java:130) > >>> at > >>> sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:179) > >>> at sqlline.Commands.connect(Commands.java:1278) > >>> at sqlline.Commands.connect(Commands.java:1172) > >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > >>> at > >>> > >>> > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > >>> at > >>> > >>> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > >>> at java.lang.reflect.Method.invoke(Method.java:498) > >>> at > >>> > >>> > sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38) > >>> at sqlline.SqlLine.dispatch(SqlLine.java:736) > >>> at sqlline.SqlLine.initArgs(SqlLine.java:428) > >>> at sqlline.SqlLine.begin(SqlLine.java:531) > >>> at sqlline.SqlLine.start(SqlLine.java:270) > >>> at sqlline.SqlLine.main(SqlLine.java:201) > >>> Caused by: org.apache.drill.exec.exception.DrillbitStartupException: > JDK > >>> Java > >>> compiler not available. Ensure Drill is running with the java > executable > >>> from > >>> a JDK and not a JRE > >>> at > >>> org.apache.drill.exec.server.Drillbit.(Drillbit.java:152) > >>> at > >>> org.apache.drill.exec.server.Drillbit.(Drillbit.java:125) > >>> at > >>> > >>> > org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:133) > >>> ... 18 more > >>> > >> >
Re: Drill embedded mode on Linux
Prab, I don't think screenshots work on the list. What distro are you using? On Red Hat, OpenJDK is a JRE but OpenJDK-devel has the JDK. It may be confusing. On Thu, Apr 9, 2020, 10:17 AM Prabhakar Bhosaale wrote: > Hi All, > > Just to give you some additional information. I came across information on > http://www.openkb.info/2017/05/drill-errors-with-jdk-java-compiler-not.html > > > As per this article, my output of step 2 is not as expected. But this > article does not mention what to do in this case. thx > > Regards > Prabhakar > > On Thu, Apr 9, 2020 at 7:37 PM Prabhakar Bhosaale > wrote: > >> Hi James, >> thanks for quick reply. >> Below is Java version screenshot. As per documentation this is correct. >> [image: image.png] >> >> Below is screenshot of java path. this is also correct. But still same >> error >> [image: image.png] >> >> Regards >> Prabhakar >> >> On Thu, Apr 9, 2020 at 7:08 PM Jaimes, Rafael - 0993 - MITLL < >> rafael.jai...@ll.mit.edu> wrote: >> >>> The error tells you that it's not finding a Java 1.8 JDK. You can use >>> OpenJDK >>> 1.8 for the job. >>> I would check: >>> 1) your java version (both version # and whether it is a JDK, not a JRE) >>> 2) your java path env vars >>> >>> -Original Message- >>> From: Prabhakar Bhosaale >>> Sent: Thursday, April 9, 2020 9:29 AM >>> To: user@drill.apache.org >>> Subject: Drill embedded mode on Linux >>> >>> Hi All, >>> I am using drill 1.16 and trying to start the drill in embedded mode on >>> linux >>> machine. Following the documentation from drill website. >>> >>> I am using bin/drill-embedded command but it is giving following error. >>> Checked the java version and it is correct. Please help urgently. thx >>> >>> Regards >>> Prabhakar >>> >>> Error: Failure in starting embedded Drillbit: >>> org.apache.drill.exec.exception.DrillbitStartupException: JDK Java >>> compiler >>> not available. Ensure Drill is running with the java executable from a >>> JDK and >>> not a JRE (state=,code=0) >>> java.sql.SQLException: Failure in starting embedded Drillbit: >>> org.apache.drill.exec.exception.DrillbitStartupException: JDK Java >>> compiler >>> not available. Ensure Drill is running with the java executable from a >>> JDK and >>> not a JRE >>> at >>> >>> org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:143) >>> at >>> >>> org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:67) >>> at >>> >>> org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:67) >>> at >>> >>> org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:138) >>> at org.apache.drill.jdbc.Driver.connect(Driver.java:72) >>> at >>> sqlline.DatabaseConnection.connect(DatabaseConnection.java:130) >>> at >>> sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:179) >>> at sqlline.Commands.connect(Commands.java:1278) >>> at sqlline.Commands.connect(Commands.java:1172) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) >>> at >>> >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>> at java.lang.reflect.Method.invoke(Method.java:498) >>> at >>> >>> sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38) >>> at sqlline.SqlLine.dispatch(SqlLine.java:736) >>> at sqlline.SqlLine.initArgs(SqlLine.java:428) >>> at sqlline.SqlLine.begin(SqlLine.java:531) >>> at sqlline.SqlLine.start(SqlLine.java:270) >>> at sqlline.SqlLine.main(SqlLine.java:201) >>> Caused by: org.apache.drill.exec.exception.DrillbitStartupException: JDK >>> Java >>> compiler not available. Ensure Drill is running with the java executable >>> from >>> a JDK and not a JRE >>> at >>> org.apache.drill.exec.server.Drillbit.(Drillbit.java:152) >>> at >>> org.apache.drill.exec.server.Drillbit.(Drillbit.java:125) >>> at >>> >>> org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:133) >>> ... 18 more >>> >>
Re: Drill embedded mode on Linux
Hi All, Just to give you some additional information. I came across information on http://www.openkb.info/2017/05/drill-errors-with-jdk-java-compiler-not.html As per this article, my output of step 2 is not as expected. But this article does not mention what to do in this case. thx Regards Prabhakar On Thu, Apr 9, 2020 at 7:37 PM Prabhakar Bhosaale wrote: > Hi James, > thanks for quick reply. > Below is Java version screenshot. As per documentation this is correct. > [image: image.png] > > Below is screenshot of java path. this is also correct. But still same > error > [image: image.png] > > Regards > Prabhakar > > On Thu, Apr 9, 2020 at 7:08 PM Jaimes, Rafael - 0993 - MITLL < > rafael.jai...@ll.mit.edu> wrote: > >> The error tells you that it's not finding a Java 1.8 JDK. You can use >> OpenJDK >> 1.8 for the job. >> I would check: >> 1) your java version (both version # and whether it is a JDK, not a JRE) >> 2) your java path env vars >> >> -Original Message- >> From: Prabhakar Bhosaale >> Sent: Thursday, April 9, 2020 9:29 AM >> To: user@drill.apache.org >> Subject: Drill embedded mode on Linux >> >> Hi All, >> I am using drill 1.16 and trying to start the drill in embedded mode on >> linux >> machine. Following the documentation from drill website. >> >> I am using bin/drill-embedded command but it is giving following error. >> Checked the java version and it is correct. Please help urgently. thx >> >> Regards >> Prabhakar >> >> Error: Failure in starting embedded Drillbit: >> org.apache.drill.exec.exception.DrillbitStartupException: JDK Java >> compiler >> not available. Ensure Drill is running with the java executable from a >> JDK and >> not a JRE (state=,code=0) >> java.sql.SQLException: Failure in starting embedded Drillbit: >> org.apache.drill.exec.exception.DrillbitStartupException: JDK Java >> compiler >> not available. Ensure Drill is running with the java executable from a >> JDK and >> not a JRE >> at >> >> org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:143) >> at >> >> org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:67) >> at >> >> org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:67) >> at >> >> org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:138) >> at org.apache.drill.jdbc.Driver.connect(Driver.java:72) >> at sqlline.DatabaseConnection.connect(DatabaseConnection.java:130) >> at >> sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:179) >> at sqlline.Commands.connect(Commands.java:1278) >> at sqlline.Commands.connect(Commands.java:1172) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >> >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) >> at >> >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:498) >> at >> sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38) >> at sqlline.SqlLine.dispatch(SqlLine.java:736) >> at sqlline.SqlLine.initArgs(SqlLine.java:428) >> at sqlline.SqlLine.begin(SqlLine.java:531) >> at sqlline.SqlLine.start(SqlLine.java:270) >> at sqlline.SqlLine.main(SqlLine.java:201) >> Caused by: org.apache.drill.exec.exception.DrillbitStartupException: JDK >> Java >> compiler not available. Ensure Drill is running with the java executable >> from >> a JDK and not a JRE >> at org.apache.drill.exec.server.Drillbit.(Drillbit.java:152) >> at org.apache.drill.exec.server.Drillbit.(Drillbit.java:125) >> at >> >> org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:133) >> ... 18 more >> >
Re: Drill embedded mode on Linux
Hi James, thanks for quick reply. Below is Java version screenshot. As per documentation this is correct. [image: image.png] Below is screenshot of java path. this is also correct. But still same error [image: image.png] Regards Prabhakar On Thu, Apr 9, 2020 at 7:08 PM Jaimes, Rafael - 0993 - MITLL < rafael.jai...@ll.mit.edu> wrote: > The error tells you that it's not finding a Java 1.8 JDK. You can use > OpenJDK > 1.8 for the job. > I would check: > 1) your java version (both version # and whether it is a JDK, not a JRE) > 2) your java path env vars > > -Original Message- > From: Prabhakar Bhosaale > Sent: Thursday, April 9, 2020 9:29 AM > To: user@drill.apache.org > Subject: Drill embedded mode on Linux > > Hi All, > I am using drill 1.16 and trying to start the drill in embedded mode on > linux > machine. Following the documentation from drill website. > > I am using bin/drill-embedded command but it is giving following error. > Checked the java version and it is correct. Please help urgently. thx > > Regards > Prabhakar > > Error: Failure in starting embedded Drillbit: > org.apache.drill.exec.exception.DrillbitStartupException: JDK Java > compiler > not available. Ensure Drill is running with the java executable from a JDK > and > not a JRE (state=,code=0) > java.sql.SQLException: Failure in starting embedded Drillbit: > org.apache.drill.exec.exception.DrillbitStartupException: JDK Java > compiler > not available. Ensure Drill is running with the java executable from a JDK > and > not a JRE > at > > org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:143) > at > > org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:67) > at > org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:67) > at > > org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:138) > at org.apache.drill.jdbc.Driver.connect(Driver.java:72) > at sqlline.DatabaseConnection.connect(DatabaseConnection.java:130) > at > sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:179) > at sqlline.Commands.connect(Commands.java:1278) > at sqlline.Commands.connect(Commands.java:1172) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38) > at sqlline.SqlLine.dispatch(SqlLine.java:736) > at sqlline.SqlLine.initArgs(SqlLine.java:428) > at sqlline.SqlLine.begin(SqlLine.java:531) > at sqlline.SqlLine.start(SqlLine.java:270) > at sqlline.SqlLine.main(SqlLine.java:201) > Caused by: org.apache.drill.exec.exception.DrillbitStartupException: JDK > Java > compiler not available. Ensure Drill is running with the java executable > from > a JDK and not a JRE > at org.apache.drill.exec.server.Drillbit.(Drillbit.java:152) > at org.apache.drill.exec.server.Drillbit.(Drillbit.java:125) > at > > org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:133) > ... 18 more >
RE: Drill embedded mode on Linux
The error tells you that it's not finding a Java 1.8 JDK. You can use OpenJDK 1.8 for the job. I would check: 1) your java version (both version # and whether it is a JDK, not a JRE) 2) your java path env vars -Original Message- From: Prabhakar Bhosaale Sent: Thursday, April 9, 2020 9:29 AM To: user@drill.apache.org Subject: Drill embedded mode on Linux Hi All, I am using drill 1.16 and trying to start the drill in embedded mode on linux machine. Following the documentation from drill website. I am using bin/drill-embedded command but it is giving following error. Checked the java version and it is correct. Please help urgently. thx Regards Prabhakar Error: Failure in starting embedded Drillbit: org.apache.drill.exec.exception.DrillbitStartupException: JDK Java compiler not available. Ensure Drill is running with the java executable from a JDK and not a JRE (state=,code=0) java.sql.SQLException: Failure in starting embedded Drillbit: org.apache.drill.exec.exception.DrillbitStartupException: JDK Java compiler not available. Ensure Drill is running with the java executable from a JDK and not a JRE at org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:143) at org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:67) at org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:67) at org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:138) at org.apache.drill.jdbc.Driver.connect(Driver.java:72) at sqlline.DatabaseConnection.connect(DatabaseConnection.java:130) at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:179) at sqlline.Commands.connect(Commands.java:1278) at sqlline.Commands.connect(Commands.java:1172) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38) at sqlline.SqlLine.dispatch(SqlLine.java:736) at sqlline.SqlLine.initArgs(SqlLine.java:428) at sqlline.SqlLine.begin(SqlLine.java:531) at sqlline.SqlLine.start(SqlLine.java:270) at sqlline.SqlLine.main(SqlLine.java:201) Caused by: org.apache.drill.exec.exception.DrillbitStartupException: JDK Java compiler not available. Ensure Drill is running with the java executable from a JDK and not a JRE at org.apache.drill.exec.server.Drillbit.(Drillbit.java:152) at org.apache.drill.exec.server.Drillbit.(Drillbit.java:125) at org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:133) ... 18 more smime.p7s Description: S/MIME cryptographic signature
Drill embedded mode on Linux
Hi All, I am using drill 1.16 and trying to start the drill in embedded mode on linux machine. Following the documentation from drill website. I am using bin/drill-embedded command but it is giving following error. Checked the java version and it is correct. Please help urgently. thx Regards Prabhakar Error: Failure in starting embedded Drillbit: org.apache.drill.exec.exception.DrillbitStartupException: JDK Java compiler not available. Ensure Drill is running with the java executable from a JDK and not a JRE (state=,code=0) java.sql.SQLException: Failure in starting embedded Drillbit: org.apache.drill.exec.exception.DrillbitStartupException: JDK Java compiler not available. Ensure Drill is running with the java executable from a JDK and not a JRE at org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:143) at org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:67) at org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:67) at org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:138) at org.apache.drill.jdbc.Driver.connect(Driver.java:72) at sqlline.DatabaseConnection.connect(DatabaseConnection.java:130) at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:179) at sqlline.Commands.connect(Commands.java:1278) at sqlline.Commands.connect(Commands.java:1172) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38) at sqlline.SqlLine.dispatch(SqlLine.java:736) at sqlline.SqlLine.initArgs(SqlLine.java:428) at sqlline.SqlLine.begin(SqlLine.java:531) at sqlline.SqlLine.start(SqlLine.java:270) at sqlline.SqlLine.main(SqlLine.java:201) Caused by: org.apache.drill.exec.exception.DrillbitStartupException: JDK Java compiler not available. Ensure Drill is running with the java executable from a JDK and not a JRE at org.apache.drill.exec.server.Drillbit.(Drillbit.java:152) at org.apache.drill.exec.server.Drillbit.(Drillbit.java:125) at org.apache.drill.jdbc.impl.DrillConnectionImpl.(DrillConnectionImpl.java:133) ... 18 more
Re: Drill embedded mode
It may be a misunderstanding of terminology. “Embedded” means the Drill Java code running in a process other than the Drill server. The most common community example of an embedded Drill is when Drill runs inside of the Sqlline command-line app. In fact, if you run the drill-embedded script, what actually happens is that the script launches Sqlline with an embedded Drillbit. Take a look at the script itself and this will be clear. What you want is a single-node Drill server. You still need to run Zookeeper, but if you launch Drill using the normal script, and on do so on a single node, you will have a Drill server that processes REST and Web requests, as well as Sqlline and other SQL queries. - Paul > On May 15, 2017, at 12:48 PM, Kunal Khatua wrote: > > Is there a reason you want to use Drill in Embedded mode and not as a > standalone server? > > > You can always use a screen session and start up Drill embedded mode and then > detach that session. > > > From: Selvarajan Thangavel > Sent: Sunday, May 14, 2017 7:31:58 AM > To: user@drill.apache.org > Subject: Drill embedded mode > > Hi, We have installed drill in embedded mode on our Linux server to query > some of our csv files and produce json data via rest api(8047) to our web > application. When I run the command "./drill-embedded" the drill service > started and the rest api service is getting connected and all looks good. But > once I close the drill shell or if my putty session expired then the drill > service is also getting killed.. so our application losses the json data. > Is there a way to keep the drill(embedded) service running in the background > all the time(like a web server)? So that we can query on port 8047 any time. > Pls let me know any information regarding the same. At the moment we are in > critical situation. > > Thanks > Selvarajan
Re: Drill embedded mode
Is there a reason you want to use Drill in Embedded mode and not as a standalone server? You can always use a screen session and start up Drill embedded mode and then detach that session. From: Selvarajan Thangavel Sent: Sunday, May 14, 2017 7:31:58 AM To: user@drill.apache.org Subject: Drill embedded mode Hi, We have installed drill in embedded mode on our Linux server to query some of our csv files and produce json data via rest api(8047) to our web application. When I run the command "./drill-embedded" the drill service started and the rest api service is getting connected and all looks good. But once I close the drill shell or if my putty session expired then the drill service is also getting killed.. so our application losses the json data. Is there a way to keep the drill(embedded) service running in the background all the time(like a web server)? So that we can query on port 8047 any time. Pls let me know any information regarding the same. At the moment we are in critical situation. Thanks Selvarajan
Drill embedded mode
Hi, We have installed drill in embedded mode on our Linux server to query some of our csv files and produce json data via rest api(8047) to our web application. When I run the command "./drill-embedded" the drill service started and the rest api service is getting connected and all looks good. But once I close the drill shell or if my putty session expired then the drill service is also getting killed.. so our application losses the json data. Is there a way to keep the drill(embedded) service running in the background all the time(like a web server)? So that we can query on port 8047 any time. Pls let me know any information regarding the same. At the moment we are in critical situation. Thanks Selvarajan
