[jira] [Commented] (TAJO-649) tajo 0.2.0 have a JDBC driver？

["Hyunsik Choi (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TAJO-649?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13919213#comment-13919213 ] 

Hyunsik Choi commented on TAJO-649:
-----------------------------------

Hi Guo,

Yes, Tajo provides the JDBC driver. Although the JDBC driver needs more tests, it works well in most cases. 

You can get Tajo JDBC driver as follows:

{noformat}
$ cd ${TAJO_ROOT}
$ mvn clean package -Pdist -Dtar -DskipTests
$ ls -l ${TAJO_ROOT}/tajo-dist/target/tajo-0.8.0-SNAPSHOT/share/jdbc-dist/
{noformat}

The directory jdbc-dist contains several jar files. In order to use this JDBC driver, you should include the jar files in jdbc-dist as well as the output of 'hadoop classpath'.

As you already know, '${HADOOP_HOME}/bin/hadoop classpath' command outputs the following CLASSPATH:
{noformat}
hyunsik@Hyunsiks-MacBook-Pro:hadoop-2.2.0$ bin/hadoop classpath
/Users/hyunsik/Code/hadoop-2.2.0/etc/hadoop:/Users/hyunsik/Code/hadoop-2.2.0/share/hadoop/common/lib/*:/Users/hyunsik/Code/hadoop-2.2.0/share/hadoop/common/*:/Users/hyunsik/Code/hadoop-2.2.0/share/hadoop/hdfs:/Users/hyunsik/Code/hadoop-2.2.0/share/hadoop/hdfs/lib/*:/Users/hyunsik/Code/hadoop-2.2.0/share/hadoop/hdfs/*:/Users/hyunsik/Code/hadoop-2.2.0/share/hadoop/yarn/lib/*:/Users/hyunsik/Code/hadoop-2.2.0/share/hadoop/yarn/*:/Users/hyunsik/Code/hadoop-2.2.0/share/hadoop/mapreduce/lib/*:/Users/hyunsik/Code/hadoop-2.2.0/share/hadoop/mapreduce/*:/Users/hyunsik/Code/hadoop-2.2.0/contrib/capacity-scheduler/*.jar
{noformat}

If you want to use smaller jar files, please refer this article (http://www.jaso.co.kr/491). Although this article is written in Korean, you can see the list of jar files. The author tried to use Tajo JDBC driver for R, which is a statistical computing framework. In his article, he showed only necessary JAR files.

In addition, I would like to suggest you to subscribe and use the user mailing list (user@tajo.incubator.apache.org) for Q&A because Jira has been used for development issues :) Please see this page (http://tajo.incubator.apache.org/mailing-lists.html) for more information of mailing list.

Regards,
Hyunsik

> tajo 0.2.0 have a JDBC driver？
> ------------------------------
>
>                 Key: TAJO-649
>                 URL: https://issues.apache.org/jira/browse/TAJO-649
>             Project: Tajo
>          Issue Type: Wish
>          Components: function/udf
>    Affects Versions: 0.2-incubating
>         Environment: Centos 6.3 32bit,jdk1.7,hadoop 2.2.0
>            Reporter: Andrew Guo
>            Priority: Minor
>              Labels: features
>             Fix For: 0.2-incubating
>
>   Original Estimate: 504h
>  Remaining Estimate: 504h
>
> Hi
> Excuse me,the tajo 0.2.0 have a JDBC driver？Can you provide to me?



--
This message was sent by Atlassian JIRA
(v6.2#6252)