I am unable to view the image. Could you please post it on some public hosting site like http://imgur.com/ ?
Having said that I have few questions: - Did the mvn clean install pass? - If yes, Did you install Drill in /opt/drill as mentioned in Step-1 of my previous mail - If yes, you should find bin/sqlline in location /opt/drill. You should be able to start sqlline by command mentioned in same mail. Share across if you are getting lost anywhere. Regards On Wed, Nov 5, 2014 at 6:46 PM, MohammadReza Mofateh <[email protected]> wrote: > Hi. > I build it but it doesn't have any bin/drillbit.sh and so on. > A shot of maven? > Maven shot: > Best > :[image: Inline image 1] > > On Wed, Nov 5, 2014 at 4:38 PM, Yash Sharma <[email protected]> wrote: > >> 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 >> > >> > > >> >> > > > >> > >> > > >> >> > > >> > >> > > >> >> > >> > >> > > >> >> >> > >> > > >> > >> > >> > > >> > >> > >> > > >> >> > >> > > > >> > >> > > > >> > >> > > >> > >> > >> > >> >> > > >> > > >> > >> > >
