Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Mon, 5 Aug 2013 18:30:49 +0000 (UTC)
From: "Thejas M Nair (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <JIRA.12648118.1368770672145.2488.1375727449709@arcas>
In-Reply-To: <JIRA.12648118.1368770672145@arcas>
References: <JIRA.12648118.1368770672145@arcas>
Subject: [jira] [Commented] (HIVE-4573) Support alternate table types for
 HiveServer2
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Thejas M Nair commented on HIVE-4573:
-------------------------------------

bq. Although it seems that eventually (.13?) you would want the default to be CLASSIC 

If we don't set the default to CLASSIC sooner, it would never happen. As time goes by, more applications would start relying this behavior.
As [~the6campbells] points out, the CLASSIC behavior is documented to be the 'normal' behavior. While we should aim for backward compatibility, I am not sure if that applies to bugs as well.

The managed vs external table information can certainly be very useful. It would be good to get that without changing the server configuration. Should we rely on something like 'describe table extended' for that ?

While I don't agree on the default, I don't think perfect should get in way of good. This improves things by making the classic behavior possible. We can discuss the default in a separate jira.
+1 for the patch.

                
> Support alternate table types for HiveServer2
> ---------------------------------------------
>
>                 Key: HIVE-4573
>                 URL: https://issues.apache.org/jira/browse/HIVE-4573
>             Project: Hive
>          Issue Type: Bug
>          Components: HiveServer2, JDBC
>    Affects Versions: 0.10.0
>            Reporter: Johndee Burks
>            Assignee: Prasad Mujumdar
>            Priority: Minor
>         Attachments: HIVE-4573.1.patch, HIVE-4573.2.patch
>
>
> The getTables jdbc function no longer returns information when using normal JDBC table types like TABLE or VIEW. You must now use a more specific type such as MANAGED_TABLE or VIRTUAL_VIEW. An example application that will fail to return results against 0.10 is below, works without issue in 0.9. In my 0.10 test I used HS2. 
> {code}
> import java.sql.SQLException;
> import java.sql.Connection;
> import java.sql.ResultSet;
> import java.sql.Statement;
> import java.sql.DriverManager;
> import org.apache.hive.jdbc.HiveDriver;
> import java.sql.DatabaseMetaData;
> public class TestGet {
>   private static String driverName = "org.apache.hive.jdbc.HiveDriver";
>   /**
>  * @param args
>  * @throws SQLException
>    */
>   public static void main(String[] args) throws SQLException {
>       try {
>       Class.forName(driverName);
>     } catch (ClassNotFoundException e) {
>       // TODO Auto-generated catch block
>       e.printStackTrace();
>       System.exit(1);
>     }
>     Connection con = DriverManager.getConnection("jdbc:hive2://hostname:10000/default");
>     DatabaseMetaData dbmd = con.getMetaData();
>     String[] types = {"TABLE"};
>     ResultSet rs = dbmd.getTables(null, null, "%", types);
>       while (rs.next()) {
>         System.out.println(rs.getString("TABLE_NAME"));
>       }
>     }
>   }
> }
> {code}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira