[jira] [Updated] (HIVE-3963) Allow Hive to connect to RDBMS

2013-03-26 Thread Maxime LANCIAUX (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maxime LANCIAUX updated HIVE-3963: -- Description: I am thinking about something like : SELECT jdbcload('driver',&

[jira] [Commented] (HIVE-3963) Allow Hive to connect to RDBMS

2013-03-15 Thread Maxime LANCIAUX (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13603506#comment-13603506 ] Maxime LANCIAUX commented on HIVE-3963: --- I will work on improving the implementa

[jira] [Commented] (HIVE-3963) Allow Hive to connect to RDBMS

2013-03-12 Thread Maxime LANCIAUX (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13599910#comment-13599910 ] Maxime LANCIAUX commented on HIVE-3963: --- Of course, https://reviews.apache.o

[jira] [Commented] (HIVE-3963) Allow Hive to connect to RDBMS

2013-03-11 Thread Mark Grover (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13599022#comment-13599022 ] Mark Grover commented on HIVE-3963: --- Thanks Maxime. Can you also please post the p

[jira] [Commented] (HIVE-3963) Allow Hive to connect to RDBMS

2013-03-11 Thread Maxime LANCIAUX (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13598976#comment-13598976 ] Maxime LANCIAUX commented on HIVE-3963: --- BI users will like this function bec

[jira] [Updated] (HIVE-3963) Allow Hive to connect to RDBMS

2013-03-11 Thread Maxime LANCIAUX (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maxime LANCIAUX updated HIVE-3963: -- Release Note: This development is rather a POC using UDTF hive function but it works !, I will

[jira] [Updated] (HIVE-3963) Allow Hive to connect to RDBMS

2013-03-11 Thread Maxime LANCIAUX (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maxime LANCIAUX updated HIVE-3963: -- Attachment: patchfile This development is rather a POC using UDTF hive function but it works

[jira] [Updated] (HIVE-3963) Allow Hive to connect to RDBMS

2013-03-11 Thread Maxime LANCIAUX (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maxime LANCIAUX updated HIVE-3963: -- Fix Version/s: (was: 0.9.1) Affects Version/s: (was: 0.9.0

[jira] [Updated] (HIVE-3963) Allow Hive to connect to RDBMS

2013-03-11 Thread Maxime LANCIAUX (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maxime LANCIAUX updated HIVE-3963: -- Fix Version/s: 0.10.1 0.9.1 Release Note: First implementation using

[jira] [Commented] (HIVE-3963) Allow Hive to connect to RDBMS

2013-03-09 Thread Mark Grover (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13598050#comment-13598050 ] Mark Grover commented on HIVE-3963: --- Maxime, can you upload a patch and post it

Re: Hive-3963

2013-03-09 Thread Mark Grover
Maxime, I posted a comment on the JIRA. Thanks! On Thu, Mar 7, 2013 at 5:57 AM, mlanciau wrote: > Hello ! > > I am working on https://issues.apache.org/jira/browse/HIVE-3963 to allow > Hive's users to get data from databases to do join with big Hadoop/Hive > table and s

[jira] [Commented] (HIVE-3963) Allow Hive to connect to RDBMS

2013-03-07 Thread Lianhui Wang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13596639#comment-13596639 ] Lianhui Wang commented on HIVE-3963: i think that must support as clause

Hive-3963

2013-03-07 Thread mlanciau
Hello ! I am working on https://issues.apache.org/jira/browse/HIVE-3963 to allow Hive's users to get data from databases to do join with big Hadoop/Hive table and small/reference table. So I have coded a UDTF LoadFromJDBC and it is working well. But I am sure it can be improved a lot !

[jira] [Updated] (HIVE-3963) Allow Hive to connect to RDBMS

2013-03-07 Thread Maxime LANCIAUX (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maxime LANCIAUX updated HIVE-3963: -- Affects Version/s: 0.11.0 0.9.0 > Allow Hive to connect to RD

[jira] [Updated] (HIVE-3963) Allow Hive to connect to RDBMS

2013-03-01 Thread Maxime LANCIAUX (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maxime LANCIAUX updated HIVE-3963: -- Description: I am thinking about something like : SELECT jdbcload('driver',&

[jira] [Updated] (HIVE-3963) Allow Hive to connect to RDBMS

2013-01-31 Thread Maxime LANCIAUX (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maxime LANCIAUX updated HIVE-3963: -- Description: I am thinking about something like : CREATE JDBCEXTERNAL TABLE ( col1 int, col2

[jira] [Updated] (HIVE-3963) Allow Hive to connect to RDBMS

2013-01-30 Thread Maxime LANCIAUX (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maxime LANCIAUX updated HIVE-3963: -- Component/s: StorageHandler SQL JDBC

[jira] [Created] (HIVE-3963) Allow Hive to get connect to RDBMS

2013-01-30 Thread Maxime LANCIAUX (JIRA)
Maxime LANCIAUX created HIVE-3963: - Summary: Allow Hive to get connect to RDBMS Key: HIVE-3963 URL: https://issues.apache.org/jira/browse/HIVE-3963 Project: Hive Issue Type: New Feature