drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MohammadReza Mofateh <mofate...@gmail.com>
Subject Re: Error in Build Drill
Date Wed, 05 Nov 2014 12:54:49 GMT
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 <yash360@gmail.com> wrote:

> Great to hear. Hopefully we will meet deadlines then :)
>
> Good luck Drilling !!
>
> On Wed, Nov 5, 2014 at 5:14 PM, MohammadReza Mofateh <mofateh72@gmail.com>
> 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 <yash360@gmail.com> 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 <yash360@gmail.com> 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 <
> > > mofateh72@gmail.com>
> > > > 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 <
> > > mofateh72@gmail.com
> > > >> >
> > > >> 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 <yash360@gmail.com>
> > > 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 <
> > > >> mofateh72@gmail.com
> > > >> >> >
> > > >> >> 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 <
> adityakishore@gmail.com
> > >
> > > >> >> 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
<
> > > >> >> > mofateh72@gmail.com
> > > >> >> > > >
> > > >> >> > > 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
> > > >> >> > > >
> > > >> >> > >
> > > >> >> >
> > > >> >>
> > > >> >
> > > >> >
> > > >>
> > > >
> > > >
> > >
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message