You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Sunil Kumar (JIRA)" <ji...@apache.org> on 2010/05/25 13:18:26 UTC

[jira] Created: (HIVE-1368) Hive JDBC Integration with SQuirrel SQL Client support Enhanced

Hive JDBC Integration with SQuirrel SQL Client support Enhanced
---------------------------------------------------------------

                 Key: HIVE-1368
                 URL: https://issues.apache.org/jira/browse/HIVE-1368
             Project: Hadoop Hive
          Issue Type: Improvement
          Components: Clients
    Affects Versions: 0.5.0
         Environment: ubuntu8.04, jdk-6,hive-0.5.0, hadoop-0.20.1 
            Reporter: Sunil Kumar


Hive JDBC Integration with SQuirrel SQL Client support Enhanced:-

Hive JDBC Client enhanced to browse hive default schema tables through Squirrel SQL Client.
This enhancement help to browse the hive table's structure i.e. table's column and their data type in the Squirrel SQL client interface and SQL query can be also performed on the tables through Squirrel SQL client.
To enable this following Hive JDBC Java files are modified and added:-
1.	Methods of org.apache.hadoop.hive.jdbc.HiveDatabaseMetaData.java are updated.
2.	Hive org.apache.hadoop.hive.jdbc.ResultSet.java updated and extended (org.apache.hadoop.hive.jdbc.ExtendedHiveResultSet.java) to support additional JDBC metadata 
3.	Methods of org.apache.hadoop.hive.jdbc. HiveResultSetMetaData are updated.
4.	Methods of  org.apache.hadoop.hive.jdbc. HiveConnection are updated.


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (HIVE-1368) Hive JDBC Integration with SQuirrel SQL Client support Enhanced

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-1368?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Namit Jain updated HIVE-1368:
-----------------------------

        Status: Resolved  (was: Patch Available)
    Resolution: Duplicate

Duplicate of https://issues.apache.org/jira/browse/HIVE-1268

> Hive JDBC Integration with SQuirrel SQL Client support Enhanced
> ---------------------------------------------------------------
>
>                 Key: HIVE-1368
>                 URL: https://issues.apache.org/jira/browse/HIVE-1368
>             Project: Hadoop Hive
>          Issue Type: Improvement
>          Components: Clients
>    Affects Versions: 0.5.0
>         Environment: ubuntu8.04, jdk-6,hive-0.5.0, hadoop-0.20.1 
>            Reporter: Sunil Kumar
>            Assignee: Sunil Kumar
>             Fix For: 0.5.0
>
>         Attachments: Hive JDBC Integration with SQuirrel SQL Client support Enhanced.doc, HIVE-1368.patch, SQLClient_support.patch
>
>
> Hive JDBC Integration with SQuirrel SQL Client support Enhanced:-
> Hive JDBC Client enhanced to browse hive default schema tables through Squirrel SQL Client.
> This enhancement help to browse the hive table's structure i.e. table's column and their data type in the Squirrel SQL client interface and SQL query can be also performed on the tables through Squirrel SQL client.
> To enable this following Hive JDBC Java files are modified and added:-
> 1.	Methods of org.apache.hadoop.hive.jdbc.HiveDatabaseMetaData.java are updated.
> 2.	Hive org.apache.hadoop.hive.jdbc.ResultSet.java updated and extended (org.apache.hadoop.hive.jdbc.ExtendedHiveResultSet.java) to support additional JDBC metadata 
> 3.	Methods of org.apache.hadoop.hive.jdbc. HiveResultSetMetaData are updated.
> 4.	Methods of  org.apache.hadoop.hive.jdbc. HiveConnection are updated.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (HIVE-1368) Hive JDBC Integration with SQuirrel SQL Client support Enhanced

Posted by "John Sichi (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-1368?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12871313#action_12871313 ] 

John Sichi commented on HIVE-1368:
----------------------------------

See also HIVE-1126.


> Hive JDBC Integration with SQuirrel SQL Client support Enhanced
> ---------------------------------------------------------------
>
>                 Key: HIVE-1368
>                 URL: https://issues.apache.org/jira/browse/HIVE-1368
>             Project: Hadoop Hive
>          Issue Type: Improvement
>          Components: Clients
>    Affects Versions: 0.5.0
>         Environment: ubuntu8.04, jdk-6,hive-0.5.0, hadoop-0.20.1 
>            Reporter: Sunil Kumar
>             Fix For: 0.5.0
>
>         Attachments: Hive JDBC Integration with SQuirrel SQL Client support Enhanced.doc, SQLClient_support.patch
>
>
> Hive JDBC Integration with SQuirrel SQL Client support Enhanced:-
> Hive JDBC Client enhanced to browse hive default schema tables through Squirrel SQL Client.
> This enhancement help to browse the hive table's structure i.e. table's column and their data type in the Squirrel SQL client interface and SQL query can be also performed on the tables through Squirrel SQL client.
> To enable this following Hive JDBC Java files are modified and added:-
> 1.	Methods of org.apache.hadoop.hive.jdbc.HiveDatabaseMetaData.java are updated.
> 2.	Hive org.apache.hadoop.hive.jdbc.ResultSet.java updated and extended (org.apache.hadoop.hive.jdbc.ExtendedHiveResultSet.java) to support additional JDBC metadata 
> 3.	Methods of org.apache.hadoop.hive.jdbc. HiveResultSetMetaData are updated.
> 4.	Methods of  org.apache.hadoop.hive.jdbc. HiveConnection are updated.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (HIVE-1368) Hive JDBC Integration with SQuirrel SQL Client support Enhanced

Posted by "Ashish Thusoo (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-1368?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12872965#action_12872965 ] 

Ashish Thusoo commented on HIVE-1368:
-------------------------------------

In my opinion best would be to load this patch to HIVE-1126 and name it for 0.5.0 in case others want to use it for 0.5.0 and mark this JIRA as a duplicate of that one.

> Hive JDBC Integration with SQuirrel SQL Client support Enhanced
> ---------------------------------------------------------------
>
>                 Key: HIVE-1368
>                 URL: https://issues.apache.org/jira/browse/HIVE-1368
>             Project: Hadoop Hive
>          Issue Type: Improvement
>          Components: Clients
>    Affects Versions: 0.5.0
>         Environment: ubuntu8.04, jdk-6,hive-0.5.0, hadoop-0.20.1 
>            Reporter: Sunil Kumar
>            Assignee: Sunil Kumar
>             Fix For: 0.5.0
>
>         Attachments: Hive JDBC Integration with SQuirrel SQL Client support Enhanced.doc, SQLClient_support.patch
>
>
> Hive JDBC Integration with SQuirrel SQL Client support Enhanced:-
> Hive JDBC Client enhanced to browse hive default schema tables through Squirrel SQL Client.
> This enhancement help to browse the hive table's structure i.e. table's column and their data type in the Squirrel SQL client interface and SQL query can be also performed on the tables through Squirrel SQL client.
> To enable this following Hive JDBC Java files are modified and added:-
> 1.	Methods of org.apache.hadoop.hive.jdbc.HiveDatabaseMetaData.java are updated.
> 2.	Hive org.apache.hadoop.hive.jdbc.ResultSet.java updated and extended (org.apache.hadoop.hive.jdbc.ExtendedHiveResultSet.java) to support additional JDBC metadata 
> 3.	Methods of org.apache.hadoop.hive.jdbc. HiveResultSetMetaData are updated.
> 4.	Methods of  org.apache.hadoop.hive.jdbc. HiveConnection are updated.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (HIVE-1368) Hive JDBC Integration with SQuirrel SQL Client support Enhanced

Posted by "Sunil Kumar (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-1368?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sunil Kumar updated HIVE-1368:
------------------------------

    Attachment: Hive JDBC Integration with SQuirrel SQL Client support Enhanced.doc

Examination and Screen shots of SQuirrel SQL Client After this change

> Hive JDBC Integration with SQuirrel SQL Client support Enhanced
> ---------------------------------------------------------------
>
>                 Key: HIVE-1368
>                 URL: https://issues.apache.org/jira/browse/HIVE-1368
>             Project: Hadoop Hive
>          Issue Type: Improvement
>          Components: Clients
>    Affects Versions: 0.5.0
>         Environment: ubuntu8.04, jdk-6,hive-0.5.0, hadoop-0.20.1 
>            Reporter: Sunil Kumar
>             Fix For: 0.5.0
>
>         Attachments: Hive JDBC Integration with SQuirrel SQL Client support Enhanced.doc
>
>
> Hive JDBC Integration with SQuirrel SQL Client support Enhanced:-
> Hive JDBC Client enhanced to browse hive default schema tables through Squirrel SQL Client.
> This enhancement help to browse the hive table's structure i.e. table's column and their data type in the Squirrel SQL client interface and SQL query can be also performed on the tables through Squirrel SQL client.
> To enable this following Hive JDBC Java files are modified and added:-
> 1.	Methods of org.apache.hadoop.hive.jdbc.HiveDatabaseMetaData.java are updated.
> 2.	Hive org.apache.hadoop.hive.jdbc.ResultSet.java updated and extended (org.apache.hadoop.hive.jdbc.ExtendedHiveResultSet.java) to support additional JDBC metadata 
> 3.	Methods of org.apache.hadoop.hive.jdbc. HiveResultSetMetaData are updated.
> 4.	Methods of  org.apache.hadoop.hive.jdbc. HiveConnection are updated.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Issue Comment Edited: (HIVE-1368) Hive JDBC Integration with SQuirrel SQL Client support Enhanced

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-1368?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12876893#action_12876893 ] 

Namit Jain edited comment on HIVE-1368 at 6/8/10 8:10 PM:
----------------------------------------------------------

Duplicate of https://issues.apache.org/jira/browse/HIVE-1126

      was (Author: namit):
    Duplicate of https://issues.apache.org/jira/browse/HIVE-1268
  
> Hive JDBC Integration with SQuirrel SQL Client support Enhanced
> ---------------------------------------------------------------
>
>                 Key: HIVE-1368
>                 URL: https://issues.apache.org/jira/browse/HIVE-1368
>             Project: Hadoop Hive
>          Issue Type: Improvement
>          Components: Clients
>    Affects Versions: 0.5.0
>         Environment: ubuntu8.04, jdk-6,hive-0.5.0, hadoop-0.20.1 
>            Reporter: Sunil Kumar
>            Assignee: Sunil Kumar
>             Fix For: 0.5.0
>
>         Attachments: Hive JDBC Integration with SQuirrel SQL Client support Enhanced.doc, HIVE-1368.patch, SQLClient_support.patch
>
>
> Hive JDBC Integration with SQuirrel SQL Client support Enhanced:-
> Hive JDBC Client enhanced to browse hive default schema tables through Squirrel SQL Client.
> This enhancement help to browse the hive table's structure i.e. table's column and their data type in the Squirrel SQL client interface and SQL query can be also performed on the tables through Squirrel SQL client.
> To enable this following Hive JDBC Java files are modified and added:-
> 1.	Methods of org.apache.hadoop.hive.jdbc.HiveDatabaseMetaData.java are updated.
> 2.	Hive org.apache.hadoop.hive.jdbc.ResultSet.java updated and extended (org.apache.hadoop.hive.jdbc.ExtendedHiveResultSet.java) to support additional JDBC metadata 
> 3.	Methods of org.apache.hadoop.hive.jdbc. HiveResultSetMetaData are updated.
> 4.	Methods of  org.apache.hadoop.hive.jdbc. HiveConnection are updated.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (HIVE-1368) Hive JDBC Integration with SQuirrel SQL Client support Enhanced

Posted by "Sunil Kumar (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-1368?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12872959#action_12872959 ] 

Sunil Kumar commented on HIVE-1368:
-----------------------------------

Seem like this work is already completed as part of HIVE-1126. However this patch is for release version 0.5.0. and we are already using it. Please suggest whether this jira is still needed.

> Hive JDBC Integration with SQuirrel SQL Client support Enhanced
> ---------------------------------------------------------------
>
>                 Key: HIVE-1368
>                 URL: https://issues.apache.org/jira/browse/HIVE-1368
>             Project: Hadoop Hive
>          Issue Type: Improvement
>          Components: Clients
>    Affects Versions: 0.5.0
>         Environment: ubuntu8.04, jdk-6,hive-0.5.0, hadoop-0.20.1 
>            Reporter: Sunil Kumar
>             Fix For: 0.5.0
>
>         Attachments: Hive JDBC Integration with SQuirrel SQL Client support Enhanced.doc, SQLClient_support.patch
>
>
> Hive JDBC Integration with SQuirrel SQL Client support Enhanced:-
> Hive JDBC Client enhanced to browse hive default schema tables through Squirrel SQL Client.
> This enhancement help to browse the hive table's structure i.e. table's column and their data type in the Squirrel SQL client interface and SQL query can be also performed on the tables through Squirrel SQL client.
> To enable this following Hive JDBC Java files are modified and added:-
> 1.	Methods of org.apache.hadoop.hive.jdbc.HiveDatabaseMetaData.java are updated.
> 2.	Hive org.apache.hadoop.hive.jdbc.ResultSet.java updated and extended (org.apache.hadoop.hive.jdbc.ExtendedHiveResultSet.java) to support additional JDBC metadata 
> 3.	Methods of org.apache.hadoop.hive.jdbc. HiveResultSetMetaData are updated.
> 4.	Methods of  org.apache.hadoop.hive.jdbc. HiveConnection are updated.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (HIVE-1368) Hive JDBC Integration with SQuirrel SQL Client support Enhanced

Posted by "Sunil Kumar (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-1368?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sunil Kumar updated HIVE-1368:
------------------------------

           Status: Patch Available  (was: Open)
     Release Note: Hive JDBC Integration with SQuirrel SQL Client support Enhanced
    Fix Version/s: 0.5.0

Hive JDBC Integration with SQuirrel SQL Client support Enhanced

> Hive JDBC Integration with SQuirrel SQL Client support Enhanced
> ---------------------------------------------------------------
>
>                 Key: HIVE-1368
>                 URL: https://issues.apache.org/jira/browse/HIVE-1368
>             Project: Hadoop Hive
>          Issue Type: Improvement
>          Components: Clients
>    Affects Versions: 0.5.0
>         Environment: ubuntu8.04, jdk-6,hive-0.5.0, hadoop-0.20.1 
>            Reporter: Sunil Kumar
>             Fix For: 0.5.0
>
>         Attachments: Hive JDBC Integration with SQuirrel SQL Client support Enhanced.doc
>
>
> Hive JDBC Integration with SQuirrel SQL Client support Enhanced:-
> Hive JDBC Client enhanced to browse hive default schema tables through Squirrel SQL Client.
> This enhancement help to browse the hive table's structure i.e. table's column and their data type in the Squirrel SQL client interface and SQL query can be also performed on the tables through Squirrel SQL client.
> To enable this following Hive JDBC Java files are modified and added:-
> 1.	Methods of org.apache.hadoop.hive.jdbc.HiveDatabaseMetaData.java are updated.
> 2.	Hive org.apache.hadoop.hive.jdbc.ResultSet.java updated and extended (org.apache.hadoop.hive.jdbc.ExtendedHiveResultSet.java) to support additional JDBC metadata 
> 3.	Methods of org.apache.hadoop.hive.jdbc. HiveResultSetMetaData are updated.
> 4.	Methods of  org.apache.hadoop.hive.jdbc. HiveConnection are updated.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Assigned: (HIVE-1368) Hive JDBC Integration with SQuirrel SQL Client support Enhanced

Posted by "Ashish Thusoo (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-1368?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ashish Thusoo reassigned HIVE-1368:
-----------------------------------

    Assignee: Sunil Kumar

Sunil, I have added you as a contributor so you can assign JIRAs to yourself.

> Hive JDBC Integration with SQuirrel SQL Client support Enhanced
> ---------------------------------------------------------------
>
>                 Key: HIVE-1368
>                 URL: https://issues.apache.org/jira/browse/HIVE-1368
>             Project: Hadoop Hive
>          Issue Type: Improvement
>          Components: Clients
>    Affects Versions: 0.5.0
>         Environment: ubuntu8.04, jdk-6,hive-0.5.0, hadoop-0.20.1 
>            Reporter: Sunil Kumar
>            Assignee: Sunil Kumar
>             Fix For: 0.5.0
>
>         Attachments: Hive JDBC Integration with SQuirrel SQL Client support Enhanced.doc, SQLClient_support.patch
>
>
> Hive JDBC Integration with SQuirrel SQL Client support Enhanced:-
> Hive JDBC Client enhanced to browse hive default schema tables through Squirrel SQL Client.
> This enhancement help to browse the hive table's structure i.e. table's column and their data type in the Squirrel SQL client interface and SQL query can be also performed on the tables through Squirrel SQL client.
> To enable this following Hive JDBC Java files are modified and added:-
> 1.	Methods of org.apache.hadoop.hive.jdbc.HiveDatabaseMetaData.java are updated.
> 2.	Hive org.apache.hadoop.hive.jdbc.ResultSet.java updated and extended (org.apache.hadoop.hive.jdbc.ExtendedHiveResultSet.java) to support additional JDBC metadata 
> 3.	Methods of org.apache.hadoop.hive.jdbc. HiveResultSetMetaData are updated.
> 4.	Methods of  org.apache.hadoop.hive.jdbc. HiveConnection are updated.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (HIVE-1368) Hive JDBC Integration with SQuirrel SQL Client support Enhanced

Posted by "Sunil Kumar (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-1368?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sunil Kumar updated HIVE-1368:
------------------------------

    Attachment: HIVE-1368.patch

Please use this patch(HIVE-1368.patch) this created from Hive _Trunk 0.5.0

> Hive JDBC Integration with SQuirrel SQL Client support Enhanced
> ---------------------------------------------------------------
>
>                 Key: HIVE-1368
>                 URL: https://issues.apache.org/jira/browse/HIVE-1368
>             Project: Hadoop Hive
>          Issue Type: Improvement
>          Components: Clients
>    Affects Versions: 0.5.0
>         Environment: ubuntu8.04, jdk-6,hive-0.5.0, hadoop-0.20.1 
>            Reporter: Sunil Kumar
>            Assignee: Sunil Kumar
>             Fix For: 0.5.0
>
>         Attachments: Hive JDBC Integration with SQuirrel SQL Client support Enhanced.doc, HIVE-1368.patch, SQLClient_support.patch
>
>
> Hive JDBC Integration with SQuirrel SQL Client support Enhanced:-
> Hive JDBC Client enhanced to browse hive default schema tables through Squirrel SQL Client.
> This enhancement help to browse the hive table's structure i.e. table's column and their data type in the Squirrel SQL client interface and SQL query can be also performed on the tables through Squirrel SQL client.
> To enable this following Hive JDBC Java files are modified and added:-
> 1.	Methods of org.apache.hadoop.hive.jdbc.HiveDatabaseMetaData.java are updated.
> 2.	Hive org.apache.hadoop.hive.jdbc.ResultSet.java updated and extended (org.apache.hadoop.hive.jdbc.ExtendedHiveResultSet.java) to support additional JDBC metadata 
> 3.	Methods of org.apache.hadoop.hive.jdbc. HiveResultSetMetaData are updated.
> 4.	Methods of  org.apache.hadoop.hive.jdbc. HiveConnection are updated.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (HIVE-1368) Hive JDBC Integration with SQuirrel SQL Client support Enhanced

Posted by "Sunil Kumar (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-1368?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sunil Kumar updated HIVE-1368:
------------------------------

    Attachment: SQLClient_support.patch

Hive JDBC Integration with SQuirrel SQL Client support Enhanced

> Hive JDBC Integration with SQuirrel SQL Client support Enhanced
> ---------------------------------------------------------------
>
>                 Key: HIVE-1368
>                 URL: https://issues.apache.org/jira/browse/HIVE-1368
>             Project: Hadoop Hive
>          Issue Type: Improvement
>          Components: Clients
>    Affects Versions: 0.5.0
>         Environment: ubuntu8.04, jdk-6,hive-0.5.0, hadoop-0.20.1 
>            Reporter: Sunil Kumar
>             Fix For: 0.5.0
>
>         Attachments: Hive JDBC Integration with SQuirrel SQL Client support Enhanced.doc, SQLClient_support.patch
>
>
> Hive JDBC Integration with SQuirrel SQL Client support Enhanced:-
> Hive JDBC Client enhanced to browse hive default schema tables through Squirrel SQL Client.
> This enhancement help to browse the hive table's structure i.e. table's column and their data type in the Squirrel SQL client interface and SQL query can be also performed on the tables through Squirrel SQL client.
> To enable this following Hive JDBC Java files are modified and added:-
> 1.	Methods of org.apache.hadoop.hive.jdbc.HiveDatabaseMetaData.java are updated.
> 2.	Hive org.apache.hadoop.hive.jdbc.ResultSet.java updated and extended (org.apache.hadoop.hive.jdbc.ExtendedHiveResultSet.java) to support additional JDBC metadata 
> 3.	Methods of org.apache.hadoop.hive.jdbc. HiveResultSetMetaData are updated.
> 4.	Methods of  org.apache.hadoop.hive.jdbc. HiveConnection are updated.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.