You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Mythili Gopalakrishnan (JIRA)" <ji...@apache.org> on 2011/07/27 18:48:09 UTC
[jira] [Created] (HIVE-2315) DatabaseMetadata.getColumns() does not
return partition column names for a table
DatabaseMetadata.getColumns() does not return partition column names for a table
--------------------------------------------------------------------------------
Key: HIVE-2315
URL: https://issues.apache.org/jira/browse/HIVE-2315
Project: Hive
Issue Type: Bug
Components: JDBC
Affects Versions: 0.7.1
Reporter: Mythili Gopalakrishnan
Priority: Critical
Fix For: 0.8.0
getColumns() method of DatabaseMetadata for HIVE JDBC Driver does not return the partition column names. Where as from HIVE CLI, if you do a 'describe tablename' you get all columns including the partition columns. It would be nice if getColumns() method returns all columns.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2315) DatabaseMetadata.getColumns() does
not return partition column names for a table
Posted by "Mythili Gopalakrishnan (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2315?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13080900#comment-13080900 ]
Mythili Gopalakrishnan commented on HIVE-2315:
----------------------------------------------
- I applied this patch and confirm that it fixes this issue HIVE-2315.
- However it does NOT fix issue HIVE-1573. When I do a select * from a partitioned column, I don't see the partition columns as part of the resultset.
> DatabaseMetadata.getColumns() does not return partition column names for a table
> --------------------------------------------------------------------------------
>
> Key: HIVE-2315
> URL: https://issues.apache.org/jira/browse/HIVE-2315
> Project: Hive
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 0.7.1
> Reporter: Mythili Gopalakrishnan
> Assignee: Patrick Hunt
> Priority: Critical
> Fix For: 0.8.0
>
> Attachments: HIVE-2315.patch
>
>
> getColumns() method of DatabaseMetadata for HIVE JDBC Driver does not return the partition column names. Where as from HIVE CLI, if you do a 'describe tablename' you get all columns including the partition columns. It would be nice if getColumns() method returns all columns.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2315) DatabaseMetadata.getColumns() does not
return partition column names for a table
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2315?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-2315:
---------------------------------
Resolution: Fixed
Hadoop Flags: [Reviewed]
Status: Resolved (was: Patch Available)
Committed to trunk. Thanks Patrick!
> DatabaseMetadata.getColumns() does not return partition column names for a table
> --------------------------------------------------------------------------------
>
> Key: HIVE-2315
> URL: https://issues.apache.org/jira/browse/HIVE-2315
> Project: Hive
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 0.7.1
> Reporter: Mythili Gopalakrishnan
> Assignee: Patrick Hunt
> Priority: Critical
> Fix For: 0.8.0
>
> Attachments: HIVE-2315.patch, HIVE-2315.patch
>
>
> getColumns() method of DatabaseMetadata for HIVE JDBC Driver does not return the partition column names. Where as from HIVE CLI, if you do a 'describe tablename' you get all columns including the partition columns. It would be nice if getColumns() method returns all columns.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2315) DatabaseMetadata.getColumns() does
not return partition column names for a table
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2315?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13086019#comment-13086019 ]
Carl Steinbach commented on HIVE-2315:
--------------------------------------
+1. Will commit if tests pass.
> DatabaseMetadata.getColumns() does not return partition column names for a table
> --------------------------------------------------------------------------------
>
> Key: HIVE-2315
> URL: https://issues.apache.org/jira/browse/HIVE-2315
> Project: Hive
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 0.7.1
> Reporter: Mythili Gopalakrishnan
> Assignee: Patrick Hunt
> Priority: Critical
> Fix For: 0.8.0
>
> Attachments: HIVE-2315.patch, HIVE-2315.patch
>
>
> getColumns() method of DatabaseMetadata for HIVE JDBC Driver does not return the partition column names. Where as from HIVE CLI, if you do a 'describe tablename' you get all columns including the partition columns. It would be nice if getColumns() method returns all columns.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2315) DatabaseMetadata.getColumns() does
not return partition column names for a table
Posted by "Patrick Hunt (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2315?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13081117#comment-13081117 ]
Patrick Hunt commented on HIVE-2315:
------------------------------------
Mythili, please take a look at the HIVE-2315_part2.patch file I just attached to this jira. The existing tests were not strongly verifying that "select * from table" was returning the partition column as part of the result set. I updated the test to do so. However subsequently the test is still passing (I verified in the debugger that this code is being executed).
Please take a look at this test:
org.apache.hadoop.hive.jdbc.TestJdbcDriver.doTestSelectAll(String, int, int)
called from here:
org.apache.hadoop.hive.jdbc.TestJdbcDriver.testSelectAllPartioned()
So, afaict, we are returning the partition column as part of the result set. (I'm also seeing this in squirrel as I mentioned).
Can you take a look at your setup again? Perhaps there is another issue somewhere in the Hive JDBC driver that's causing DBVizualizer to display this problem while Squirrel is fine?
> DatabaseMetadata.getColumns() does not return partition column names for a table
> --------------------------------------------------------------------------------
>
> Key: HIVE-2315
> URL: https://issues.apache.org/jira/browse/HIVE-2315
> Project: Hive
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 0.7.1
> Reporter: Mythili Gopalakrishnan
> Assignee: Patrick Hunt
> Priority: Critical
> Fix For: 0.8.0
>
> Attachments: HIVE-2315.patch, HIVE-2315_part2.patch
>
>
> getColumns() method of DatabaseMetadata for HIVE JDBC Driver does not return the partition column names. Where as from HIVE CLI, if you do a 'describe tablename' you get all columns including the partition columns. It would be nice if getColumns() method returns all columns.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Assigned] (HIVE-2315) DatabaseMetadata.getColumns() does
not return partition column names for a table
Posted by "Patrick Hunt (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2315?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Patrick Hunt reassigned HIVE-2315:
----------------------------------
Assignee: Patrick Hunt
> DatabaseMetadata.getColumns() does not return partition column names for a table
> --------------------------------------------------------------------------------
>
> Key: HIVE-2315
> URL: https://issues.apache.org/jira/browse/HIVE-2315
> Project: Hive
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 0.7.1
> Reporter: Mythili Gopalakrishnan
> Assignee: Patrick Hunt
> Priority: Critical
> Fix For: 0.8.0
>
>
> getColumns() method of DatabaseMetadata for HIVE JDBC Driver does not return the partition column names. Where as from HIVE CLI, if you do a 'describe tablename' you get all columns including the partition columns. It would be nice if getColumns() method returns all columns.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2315) DatabaseMetadata.getColumns() does not
return partition column names for a table
Posted by "Patrick Hunt (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2315?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Patrick Hunt updated HIVE-2315:
-------------------------------
Status: Open (was: Patch Available)
waiting for feedback from Mythili.
> DatabaseMetadata.getColumns() does not return partition column names for a table
> --------------------------------------------------------------------------------
>
> Key: HIVE-2315
> URL: https://issues.apache.org/jira/browse/HIVE-2315
> Project: Hive
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 0.7.1
> Reporter: Mythili Gopalakrishnan
> Assignee: Patrick Hunt
> Priority: Critical
> Fix For: 0.8.0
>
> Attachments: HIVE-2315.patch
>
>
> getColumns() method of DatabaseMetadata for HIVE JDBC Driver does not return the partition column names. Where as from HIVE CLI, if you do a 'describe tablename' you get all columns including the partition columns. It would be nice if getColumns() method returns all columns.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2315) DatabaseMetadata.getColumns() does not
return partition column names for a table
Posted by "Patrick Hunt (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2315?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Patrick Hunt updated HIVE-2315:
-------------------------------
Attachment: HIVE-2315_part2.patch
Updated test to explicitly verify that JDBC result set contains the partition column on a "select * from t". Otw the code is unchanged.
> DatabaseMetadata.getColumns() does not return partition column names for a table
> --------------------------------------------------------------------------------
>
> Key: HIVE-2315
> URL: https://issues.apache.org/jira/browse/HIVE-2315
> Project: Hive
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 0.7.1
> Reporter: Mythili Gopalakrishnan
> Assignee: Patrick Hunt
> Priority: Critical
> Fix For: 0.8.0
>
> Attachments: HIVE-2315.patch, HIVE-2315_part2.patch
>
>
> getColumns() method of DatabaseMetadata for HIVE JDBC Driver does not return the partition column names. Where as from HIVE CLI, if you do a 'describe tablename' you get all columns including the partition columns. It would be nice if getColumns() method returns all columns.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2315) DatabaseMetadata.getColumns() does not
return partition column names for a table
Posted by "Patrick Hunt (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2315?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Patrick Hunt updated HIVE-2315:
-------------------------------
Attachment: (was: HIVE-2315_part2.patch)
> DatabaseMetadata.getColumns() does not return partition column names for a table
> --------------------------------------------------------------------------------
>
> Key: HIVE-2315
> URL: https://issues.apache.org/jira/browse/HIVE-2315
> Project: Hive
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 0.7.1
> Reporter: Mythili Gopalakrishnan
> Assignee: Patrick Hunt
> Priority: Critical
> Fix For: 0.8.0
>
> Attachments: HIVE-2315.patch
>
>
> getColumns() method of DatabaseMetadata for HIVE JDBC Driver does not return the partition column names. Where as from HIVE CLI, if you do a 'describe tablename' you get all columns including the partition columns. It would be nice if getColumns() method returns all columns.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2315) DatabaseMetadata.getColumns() does
not return partition column names for a table
Posted by "Doug Sedlak (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2315?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13149933#comment-13149933 ]
Doug Sedlak commented on HIVE-2315:
-----------------------------------
For an 'int' partition column, the 'getColumnTypeName' metadata call is returning type 'string'. However, a DESCRIBE correctly returns type 'int'. Seems like a bug if it replicates for others? I have the patched code in place on both client and server. Thanks!
Sample table is:
create EXTERNAL table partition_by_int (str_val string) PARTITIONED BY (int_col INT) ROW FORMAT delimited fields terminated by ',' STORED AS TEXTFILE;
And (shortened) JDBC code is:
res = stmt.executeQuery("select * from partition_by_int");
ResultSetMetaData metaData = res.getMetaData();
for (int i = 0; i < metaData.getColumnCount(); i++) {
System.out.print(metaData.getColumnName(i + 1) + " \t");
System.out.print(metaData.getColumnDisplaySize(i + 1) + "\t");
System.out.println(metaData.getColumnTypeName(i + 1));
}
With output:
str_val 2147483647 string
int_col 2147483647 string
In contrast, DESCRIBE partition_by_int generates:
str_val string
int_col int
> DatabaseMetadata.getColumns() does not return partition column names for a table
> --------------------------------------------------------------------------------
>
> Key: HIVE-2315
> URL: https://issues.apache.org/jira/browse/HIVE-2315
> Project: Hive
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 0.7.1
> Reporter: Mythili Gopalakrishnan
> Assignee: Patrick Hunt
> Priority: Critical
> Fix For: 0.8.0
>
> Attachments: HIVE-2315.patch, HIVE-2315.patch
>
>
> getColumns() method of DatabaseMetadata for HIVE JDBC Driver does not return the partition column names. Where as from HIVE CLI, if you do a 'describe tablename' you get all columns including the partition columns. It would be nice if getColumns() method returns all columns.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2315) DatabaseMetadata.getColumns() does not
return partition column names for a table
Posted by "Patrick Hunt (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2315?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Patrick Hunt updated HIVE-2315:
-------------------------------
Attachment: HIVE-2315.patch
use get_schema rather than get_fields. Verified via unit test as well as via squirrel.
> DatabaseMetadata.getColumns() does not return partition column names for a table
> --------------------------------------------------------------------------------
>
> Key: HIVE-2315
> URL: https://issues.apache.org/jira/browse/HIVE-2315
> Project: Hive
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 0.7.1
> Reporter: Mythili Gopalakrishnan
> Assignee: Patrick Hunt
> Priority: Critical
> Fix For: 0.8.0
>
> Attachments: HIVE-2315.patch
>
>
> getColumns() method of DatabaseMetadata for HIVE JDBC Driver does not return the partition column names. Where as from HIVE CLI, if you do a 'describe tablename' you get all columns including the partition columns. It would be nice if getColumns() method returns all columns.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2315) DatabaseMetadata.getColumns() does
not return partition column names for a table
Posted by "Patrick Hunt (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2315?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13081056#comment-13081056 ]
Patrick Hunt commented on HIVE-2315:
------------------------------------
Hi Mythili can you give an example of the query you are running? i.e. steps how to reproduce.
When I run the following from hive:
{noformat}
create table foo2 (a string, b string, c string) partitioned by (dt string) row format delimited fields terminated by '\t';
load data local inpath './data.txt' overwrite into table foo2 partition (dt='8');
load data local inpath './data.txt' overwrite into table foo2 partition (dt='9');
select * from foo2;
{noformat}
I see dt in the output (hive cli).
When I run "select * from foo2" from Squirrel I also see dt in the output after applying this patch (I also see dt in the metadata reported by Squirrel for the table).
> DatabaseMetadata.getColumns() does not return partition column names for a table
> --------------------------------------------------------------------------------
>
> Key: HIVE-2315
> URL: https://issues.apache.org/jira/browse/HIVE-2315
> Project: Hive
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 0.7.1
> Reporter: Mythili Gopalakrishnan
> Assignee: Patrick Hunt
> Priority: Critical
> Fix For: 0.8.0
>
> Attachments: HIVE-2315.patch
>
>
> getColumns() method of DatabaseMetadata for HIVE JDBC Driver does not return the partition column names. Where as from HIVE CLI, if you do a 'describe tablename' you get all columns including the partition columns. It would be nice if getColumns() method returns all columns.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2315) DatabaseMetadata.getColumns() does not
return partition column names for a table
Posted by "Patrick Hunt (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2315?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Patrick Hunt updated HIVE-2315:
-------------------------------
Attachment: HIVE-2315.patch
Updated to a single patch with fix and both sets of tests.
> DatabaseMetadata.getColumns() does not return partition column names for a table
> --------------------------------------------------------------------------------
>
> Key: HIVE-2315
> URL: https://issues.apache.org/jira/browse/HIVE-2315
> Project: Hive
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 0.7.1
> Reporter: Mythili Gopalakrishnan
> Assignee: Patrick Hunt
> Priority: Critical
> Fix For: 0.8.0
>
> Attachments: HIVE-2315.patch, HIVE-2315.patch
>
>
> getColumns() method of DatabaseMetadata for HIVE JDBC Driver does not return the partition column names. Where as from HIVE CLI, if you do a 'describe tablename' you get all columns including the partition columns. It would be nice if getColumns() method returns all columns.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2315) DatabaseMetadata.getColumns() does
not return partition column names for a table
Posted by "Mythili Gopalakrishnan (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2315?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13082973#comment-13082973 ]
Mythili Gopalakrishnan commented on HIVE-2315:
----------------------------------------------
Patrick, it is my fault, I forgot to update the jars on the server side. Once I did that, I see the partition columns when I do a select * from foo2. This issue is fixed.
> DatabaseMetadata.getColumns() does not return partition column names for a table
> --------------------------------------------------------------------------------
>
> Key: HIVE-2315
> URL: https://issues.apache.org/jira/browse/HIVE-2315
> Project: Hive
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 0.7.1
> Reporter: Mythili Gopalakrishnan
> Assignee: Patrick Hunt
> Priority: Critical
> Fix For: 0.8.0
>
> Attachments: HIVE-2315.patch, HIVE-2315_part2.patch
>
>
> getColumns() method of DatabaseMetadata for HIVE JDBC Driver does not return the partition column names. Where as from HIVE CLI, if you do a 'describe tablename' you get all columns including the partition columns. It would be nice if getColumns() method returns all columns.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2315) DatabaseMetadata.getColumns() does not
return partition column names for a table
Posted by "Patrick Hunt (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2315?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Patrick Hunt updated HIVE-2315:
-------------------------------
Status: Patch Available (was: Open)
> DatabaseMetadata.getColumns() does not return partition column names for a table
> --------------------------------------------------------------------------------
>
> Key: HIVE-2315
> URL: https://issues.apache.org/jira/browse/HIVE-2315
> Project: Hive
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 0.7.1
> Reporter: Mythili Gopalakrishnan
> Assignee: Patrick Hunt
> Priority: Critical
> Fix For: 0.8.0
>
> Attachments: HIVE-2315.patch
>
>
> getColumns() method of DatabaseMetadata for HIVE JDBC Driver does not return the partition column names. Where as from HIVE CLI, if you do a 'describe tablename' you get all columns including the partition columns. It would be nice if getColumns() method returns all columns.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2315) DatabaseMetadata.getColumns() does
not return partition column names for a table
Posted by "jiraposter@reviews.apache.org (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2315?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13083257#comment-13083257 ]
jiraposter@reviews.apache.org commented on HIVE-2315:
-----------------------------------------------------
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/1468/
-----------------------------------------------------------
Review request for hive and Carl Steinbach.
Summary
-------
This patch fixes the problem and adds a couple of tests.
This addresses bug HIVE-2315.
https://issues.apache.org/jira/browse/HIVE-2315
Diffs
-----
jdbc/src/java/org/apache/hadoop/hive/jdbc/HiveDatabaseMetaData.java d570fca
jdbc/src/test/org/apache/hadoop/hive/jdbc/TestJdbcDriver.java d72cf43
Diff: https://reviews.apache.org/r/1468/diff
Testing
-------
units pass, a user also verified it fixed the issue they were seeing.
Thanks,
Patrick
> DatabaseMetadata.getColumns() does not return partition column names for a table
> --------------------------------------------------------------------------------
>
> Key: HIVE-2315
> URL: https://issues.apache.org/jira/browse/HIVE-2315
> Project: Hive
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 0.7.1
> Reporter: Mythili Gopalakrishnan
> Assignee: Patrick Hunt
> Priority: Critical
> Fix For: 0.8.0
>
> Attachments: HIVE-2315.patch, HIVE-2315.patch
>
>
> getColumns() method of DatabaseMetadata for HIVE JDBC Driver does not return the partition column names. Where as from HIVE CLI, if you do a 'describe tablename' you get all columns including the partition columns. It would be nice if getColumns() method returns all columns.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2315) DatabaseMetadata.getColumns() does
not return partition column names for a table
Posted by "Mythili Gopalakrishnan (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2315?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13081067#comment-13081067 ]
Mythili Gopalakrishnan commented on HIVE-2315:
----------------------------------------------
Patrick
This is exactly what I have done as well. I use a tool called DBVizualizer, very similar to Squirrel. When I click on foo2, I see the partition columns, but when I do a select *, I don't see the partition columns.
One thing I noticed (please pardon my ignorance as I have not had a chance to look deep into the HIVE JDBC driver source code) is that the patch listed only 2 files to patch, HiveDatabaseMetaData.java and TestJdbcDriver.java. Is it missing some other file that would have included the changes for the query part?
Thanks,
Mythili
> DatabaseMetadata.getColumns() does not return partition column names for a table
> --------------------------------------------------------------------------------
>
> Key: HIVE-2315
> URL: https://issues.apache.org/jira/browse/HIVE-2315
> Project: Hive
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 0.7.1
> Reporter: Mythili Gopalakrishnan
> Assignee: Patrick Hunt
> Priority: Critical
> Fix For: 0.8.0
>
> Attachments: HIVE-2315.patch
>
>
> getColumns() method of DatabaseMetadata for HIVE JDBC Driver does not return the partition column names. Where as from HIVE CLI, if you do a 'describe tablename' you get all columns including the partition columns. It would be nice if getColumns() method returns all columns.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2315) DatabaseMetadata.getColumns() does
not return partition column names for a table
Posted by "Hudson (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2315?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13087473#comment-13087473 ]
Hudson commented on HIVE-2315:
------------------------------
Integrated in Hive-trunk-h0.21 #903 (See [https://builds.apache.org/job/Hive-trunk-h0.21/903/])
HIVE-2315. DatabaseMetadata.getColumns() does not return partition column names for a table (Patrick Hunt via cws)
cws : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1159423
Files :
* /hive/trunk/jdbc/src/java/org/apache/hadoop/hive/jdbc/HiveDatabaseMetaData.java
* /hive/trunk/jdbc/src/test/org/apache/hadoop/hive/jdbc/TestJdbcDriver.java
> DatabaseMetadata.getColumns() does not return partition column names for a table
> --------------------------------------------------------------------------------
>
> Key: HIVE-2315
> URL: https://issues.apache.org/jira/browse/HIVE-2315
> Project: Hive
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 0.7.1
> Reporter: Mythili Gopalakrishnan
> Assignee: Patrick Hunt
> Priority: Critical
> Fix For: 0.8.0
>
> Attachments: HIVE-2315.patch, HIVE-2315.patch
>
>
> getColumns() method of DatabaseMetadata for HIVE JDBC Driver does not return the partition column names. Where as from HIVE CLI, if you do a 'describe tablename' you get all columns including the partition columns. It would be nice if getColumns() method returns all columns.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2315) DatabaseMetadata.getColumns() does not
return partition column names for a table
Posted by "Patrick Hunt (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2315?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Patrick Hunt updated HIVE-2315:
-------------------------------
Status: Patch Available (was: Open)
> DatabaseMetadata.getColumns() does not return partition column names for a table
> --------------------------------------------------------------------------------
>
> Key: HIVE-2315
> URL: https://issues.apache.org/jira/browse/HIVE-2315
> Project: Hive
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 0.7.1
> Reporter: Mythili Gopalakrishnan
> Assignee: Patrick Hunt
> Priority: Critical
> Fix For: 0.8.0
>
> Attachments: HIVE-2315.patch, HIVE-2315.patch
>
>
> getColumns() method of DatabaseMetadata for HIVE JDBC Driver does not return the partition column names. Where as from HIVE CLI, if you do a 'describe tablename' you get all columns including the partition columns. It would be nice if getColumns() method returns all columns.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira