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 >> > > >> >> > > > >> > > >> >> > > >> > > >> >> > >> > > >> >> >> > > >> > >> > > >> > >> > > >> >> > > > >> > > > >> > > >> > >> > >
