I would really suggest you to build Drill on your box instead of replacing with 0.5.0 jars. Could you plz give it a shot and share the error messages? Thats the best way and will help you troubleshoot any future issues you come across with new releases.
- From mobile. Pardon typos. On 05/11/2014 6:33 pm, "MohammadReza Mofateh" <[email protected]> wrote: > Hi, > Thank you > I think It's my jars problems. > Could you send me or share your 0.7.0 complete as tar.gz ? > Best > > On Wed, Nov 5, 2014 at 4:24 PM, MohammadReza Mofateh <[email protected]> > wrote: > > > Hi, > > Thank you > > One odd thing and Some additional problems!!!! > > Is it odd to see Completed Queries (in profiles) with version .5.0?(I > > create a new directory) > > > > Problems: > > 1-In a simple join I don't get any result and this error: > > Error: Query failed: Failure while running fragment., Hash join does not > > support schema changes > > My query:select * from hbase.ab2 join hbase.ab on ab2.row_key=ab.row_key > > > > 2-In the other query I see this error: > > Error: > > > > Query failed: Failure while running fragment., Failure while trying to > > materialize incoming schema. Errors: > > > > Error in expression at index 0. Error: Missing function implementation: > > [hash(MAP-REQUIRED)]. Full expression: null.. [ > > 9f0df4ef-6432-4b1d-bf31-80bc286d674b > > > > My query:select * from hbase.ab2 as w join (select flatten(z.d) as x from > > (select convert_from(ab.i.n,'JSON')As d from hbase.ab) as z) as y on > > y.x=w.row_key > > > > > > Best > > > > On Wed, Nov 5, 2014 at 3:23 PM, Yash Sharma <[email protected]> wrote: > > > >> Great to hear. Hopefully we will meet deadlines then :) > >> > >> Good luck Drilling !! > >> > >> On Wed, Nov 5, 2014 at 5:14 PM, MohammadReza Mofateh < > [email protected] > >> > > >> wrote: > >> > >> > Hi Yash > >> > Thank you It seems working now. > >> > I changed 0.7.0 jars with 0.5.0 jars and now it's working well. > >> > > >> > Best > >> > > >> > On Wed, Nov 5, 2014 at 2:50 PM, Yash Sharma <[email protected]> > wrote: > >> > > >> > > And once your build passes you can use below info for installing > Drill > >> > and > >> > > using Sqlline: > >> > > > >> > > > >> > > // Install Drill > >> > > mkdir /opt/drill > >> > > tar xvzf distribution/target/*.tar.gz --strip=1 -C /opt/drill > >> > > > >> > > // Switch to installed directory > >> > > cd /opt/drill > >> > > bin/sqlline -u jdbc:drill:zk=local -n admin -p admin > >> > > > >> > > //Check/Sublit jobs from Web Interface > >> > > http://localhost:8047/status > >> > > > >> > > //Sqlline Log File: > >> > > /var/log/drill/sqlline.log > >> > > > >> > > Hope it helps. > >> > > > >> > > On Wed, Nov 5, 2014 at 4:30 PM, Yash Sharma <[email protected]> > >> wrote: > >> > > > >> > > > Drill required Java 7 and Maven 3.x . Could you please check the > >> > > versions ? > >> > > > > >> > > > Could you check: > >> > > > > >> > > >> java -version > >> > > >> mvn --version > >> > > > > >> > > > > >> > > > Regards > >> > > > > >> > > > On Wed, Nov 5, 2014 at 3:58 PM, MohammadReza Mofateh < > >> > > [email protected]> > >> > > > wrote: > >> > > > > >> > > >> Hi, > >> > > >> I made it but with one error! > >> > > >> Is it important?For using I should replace them with old?(How to > >> use > >> > it > >> > > >> tools like drillbit.sh?) > >> > > >> Best > >> > > >> > >> > > >> Downloading: > >> > > >> > >> > > >> > >> > > > >> > > >> > http://repo.maven.apache.org/maven2/org/codehaus/mojo/exec-maven-plugin/maven-metadata.xml > >> > > >> [WARNING] Could not transfer metadata > >> > > >> org.codehaus.mojo:exec-maven-plugin/maven-metadata.xml from/to > >> > central ( > >> > > >> http://rep > >> > > >> o.maven.apache.org/maven2): repo.maven.apache.org > >> > > >> [INFO] > >> > > >> > >> > > ------------------------------------------------------------------------ > >> > > >> [INFO] Reactor Summary: > >> > > >> [INFO] > >> > > >> [INFO] Apache Drill Root POM ............................. > SUCCESS > >> > > >> [12.438s] > >> > > >> [INFO] Drill Protocol .................................... > SUCCESS > >> > > >> [10.598s] > >> > > >> [INFO] Common (Logical Plan, Base expressions) ........... > SUCCESS > >> > > >> [9.004s] > >> > > >> [INFO] contrib/Parent Pom ................................ > SUCCESS > >> > > >> [0.500s] > >> > > >> [INFO] contrib/data/Parent Pom ........................... > SUCCESS > >> > > >> [0.500s] > >> > > >> [INFO] contrib/data/tpch-sample-data ..................... > SUCCESS > >> > > >> [3.188s] > >> > > >> [INFO] exec/Parent Pom ................................... > SUCCESS > >> > > >> [0.622s] > >> > > >> [INFO] exec/Java Execution Engine ........................ > SUCCESS > >> > > >> [2:00.362s] > >> > > >> [INFO] contrib/hbase-storage-plugin ...................... > SUCCESS > >> > > >> [2:56.887s] > >> > > >> [INFO] contrib/hive-storage-plugin/Parent Pom ............ > SUCCESS > >> > > >> [0.493s] > >> > > >> [INFO] contrib/hive-storage-plugin/hive-exec-shaded ...... > SUCCESS > >> > > >> [9:03.349s] > >> > > >> [INFO] contrib/hive-storage-plugin/core .................. > SUCCESS > >> > > >> [5.571s] > >> > > >> [INFO] contrib/mongo-storage-plugin ...................... > SUCCESS > >> > > >> [14.712s] > >> > > >> [INFO] exec/JDBC Driver using dependencies ............... > SUCCESS > >> > > >> [1:06.260s] > >> > > >> [INFO] contrib/sqlline ................................... > SUCCESS > >> > > >> [0.836s] > >> > > >> [INFO] JDBC JAR with all dependencies .................... > SUCCESS > >> > > >> [2:25.468s] > >> > > >> [INFO] exec/Drill expression interpreter ................. > FAILURE > >> > > >> [0.066s] > >> > > >> [INFO] Packaging and Distribution Assembly ............... > SKIPPED > >> > > >> [INFO] > >> > > >> > >> > > ------------------------------------------------------------------------ > >> > > >> [INFO] BUILD FAILURE > >> > > >> [INFO] > >> > > >> > >> > > ------------------------------------------------------------------------ > >> > > >> [INFO] Total time: 18:31.570s > >> > > >> [INFO] Finished at: Wed Nov 05 13:45:50 IRST 2014 > >> > > >> [INFO] Final Memory: 87M/441M > >> > > >> [INFO] > >> > > >> > >> > > ------------------------------------------------------------------------ > >> > > >> [ERROR] Error resolving version for plugin > >> > > >> 'org.codehaus.mojo:exec-maven-plugin' from the repositories > [local > >> > > >> (E:\MAVEN) > >> > > >> , central (http://repo.maven.apache.org/maven2)]: Plugin not > >> found in > >> > > any > >> > > >> plugin repository -> [Help 1] > >> > > >> [ERROR] > >> > > >> [ERROR] To see the full stack trace of the errors, re-run Maven > >> with > >> > the > >> > > >> -e > >> > > >> switch. > >> > > >> [ERROR] Re-run Maven using the -X switch to enable full debug > >> logging. > >> > > >> [ERROR] > >> > > >> [ERROR] For more information about the errors and possible > >> solutions, > >> > > >> please read the following articles: > >> > > >> [ERROR] [Help 1] > >> > > >> > >> > > >> > >> > > > >> > > >> > http://cwiki.apache.org/confluence/display/MAVEN/PluginVersionResolutionException > >> > > >> > >> > > >> On Wed, Nov 5, 2014 at 1:20 PM, MohammadReza Mofateh < > >> > > [email protected] > >> > > >> > > >> > > >> wrote: > >> > > >> > >> > > >> > Hi Yash > >> > > >> > > >> > > >> > Yes I access to it. > >> > > >> > Thank you.I will test it and send feedback you. > >> > > >> > > >> > > >> > Best > >> > > >> > > >> > > >> > On Wed, Nov 5, 2014 at 12:48 PM, Yash Sharma < > [email protected]> > >> > > wrote: > >> > > >> > > >> > > >> >> Hi Mofateh no Apologies required :) > >> > > >> >> > >> > > >> >> If you are not able to access the repo then there is only > little > >> > that > >> > > >> we > >> > > >> >> might be able to point out. You might want to check with the > >> > internal > >> > > >> team > >> > > >> >> at your workplace. > >> > > >> >> > >> > > >> >> As Aditya mentioned - Are you able to access this link via > your > >> > > >> browser? > >> > > >> >> http://repository.mapr.com/nexus/content/repositories/drill/ > >> > > >> >> > >> > > >> >> If yes then you are good to go. > >> > > >> >> > >> > > >> >> Try a new build with the commands mentioned in last mail and > It > >> > > should > >> > > >> >> build it without any hurdles. > >> > > >> >> Do share any errors that you face. > >> > > >> >> > >> > > >> >> Good luck > >> > > >> >> > >> > > >> >> > >> > > >> >> On Wed, Nov 5, 2014 at 1:39 PM, MohammadReza Mofateh < > >> > > >> [email protected] > >> > > >> >> > > >> > > >> >> wrote: > >> > > >> >> > >> > > >> >> > Hi > >> > > >> >> > Excuse me dear Aditya and Yash. > >> > > >> >> > Thank you and big apology. > >> > > >> >> > I'm not unable to create it and I should test it (flatten) > >> > > >> today(It's a > >> > > >> >> > deadline by My project manger):(. > >> > > >> >> > Maybe mapr blocked my area id. > >> > > >> >> > Now I try again will be mail to you > >> > > >> >> > > >> > > >> >> > Best Regards > >> > > >> >> > > >> > > >> >> > > >> > > >> >> > On Wed, Nov 5, 2014 at 10:54 AM, Aditya < > >> [email protected] > >> > > > >> > > >> >> wrote: > >> > > >> >> > > >> > > >> >> > > Hi MohammadReza, > >> > > >> >> > > > >> > > >> >> > > I apologize for not getting back to you on your issue > >> sooner. > >> > > >> >> > > > >> > > >> >> > > Apparently, ping has been disabled for this host and hence > >> is > >> > not > >> > > >> >> > > a good indication if the host is reachable from your build > >> > > machine. > >> > > >> >> > > > >> > > >> >> > > Could you see if you can access this URL[1] on the same > >> build > >> > > >> machine > >> > > >> >> > > using a browser? The error indicate that the host is not > >> > > reachable > >> > > >> >> from > >> > > >> >> > > the machine you are trying to build. > >> > > >> >> > > > >> > > >> >> > > [1] > >> > http://repository.mapr.com/nexus/content/repositories/drill/ > >> > > >> >> > > > >> > > >> >> > > On Tue, Nov 4, 2014 at 10:51 PM, MohammadReza Mofateh < > >> > > >> >> > [email protected] > >> > > >> >> > > > > >> > > >> >> > > wrote: > >> > > >> >> > > > >> > > >> >> > > > Hi > >> > > >> >> > > > I asked question about How to building 0.7.0 that I > >> > downloaded > >> > > >> it > >> > > >> >> from > >> > > >> >> > > > Github. > >> > > >> >> > > > But I couldn't make It."Aditya" said me to ping > >> > > >> repository.mapr.com > >> > > >> >> It > >> > > >> >> > > > timed out.Could you share compiled version 0.7.0 in a > >> place > >> > and > >> > > >> >> link it > >> > > >> >> > > > me?I must test it new flatten function. > >> > > >> >> > > > > >> > > >> >> > > > A criticism: > >> > > >> >> > > > I choose drill because It's better than the other APIs , > >> but > >> > > Why > >> > > >> >> here > >> > > >> >> > no > >> > > >> >> > > > body don't answer clear?(Excuse me But It's a big blind > >> > spot). > >> > > >> >> > > > > >> > > >> >> > > > C:\>ping repository.mapr.com Pinging stage.mapr.com > >> > > >> >> [107.20.230.228] > >> > > >> >> > > with > >> > > >> >> > > > 32 bytes of data: Request timed out. Request timed out. > >> > Request > >> > > >> >> timed > >> > > >> >> > > out. > >> > > >> >> > > > Request timed out. Ping statistics for 107.20.230.228: > >> > > Packets: > >> > > >> >> Sent = > >> > > >> >> > > 4, > >> > > >> >> > > > Received = 0, Lost = 4 (100% loss), > >> > > >> >> > > > > >> > > >> >> > > > Best > >> > > >> >> > > > > >> > > >> >> > > > >> > > >> >> > > >> > > >> >> > >> > > >> > > >> > > >> > > >> > > >> > >> > > > > >> > > > > >> > > > >> > > >> > > > > >
