[jira] Commented: (HIVE-1126) Missing some Jdbc functionality like getTables getColumns and HiveResultSet.get* methods based on column name.

[John Sichi (JIRA)]

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

John Sichi commented on HIVE-1126:
----------------------------------

I am still getting a failure in TestJdbcDriver when run as part of the full ant 
test (below).

Also, note that the failure message is confusing because when you use 
Assert.assertEquals(x, y), x is supposed to be the expected (correct) value and 
y is supposed to be the actual value produced by the test, but the code has 
them reversed here.


{noformat}
   <failure message="expected:&lt;testhivedrivertable&gt; but was:&lt;testhive\
jdbcdriverpartitionedtable&gt;" type="junit.framework.AssertionFailedError">jun\
it.framework.AssertionFailedError: expected:&lt;testhivedrivertable&gt; but was\
:&lt;testhivejdbcdriverpartitionedtable&gt;                                     
        at junit.framework.Assert.fail(Assert.java:47)                          
        at junit.framework.Assert.failNotEquals(Assert.java:282)                
        at junit.framework.Assert.assertEquals(Assert.java:64)                  
        at junit.framework.Assert.assertEquals(Assert.java:71)                  
        at org.apache.hadoop.hive.jdbc.TestJdbcDriver.testMetaDataGetTables(Tes\
tJdbcDriver.java:331)                                                           
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)          
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl\
.java:39)                                                                       
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcce\
ssorImpl.java:25)                                                               
        at java.lang.reflect.Method.invoke(Method.java:597)                     
        at junit.framework.TestCase.runTest(TestCase.java:154)                  
        at junit.framework.TestCase.runBare(TestCase.java:127)                  
        at junit.framework.TestResult$1.protect(TestResult.java:106)            
        at junit.framework.TestResult.runProtected(TestResult.java:124)         
        at junit.framework.TestResult.run(TestResult.java:109)                  
        at junit.framework.TestCase.run(TestCase.java:118)                      
        at junit.framework.TestSuite.runTest(TestSuite.java:208)                
        at junit.framework.TestSuite.run(TestSuite.java:203)                    
        at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUn\
itTestRunner.java:422)                                                          
        at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.launch(\
JUnitTestRunner.java:931)                                                       
        at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(JU\
nitTestRunner.java:785)                                                         
</failure>                                                                      
{noformat}


> Missing some Jdbc functionality like getTables getColumns and 
> HiveResultSet.get* methods based on column name.
> --------------------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-1126
>                 URL: https://issues.apache.org/jira/browse/HIVE-1126
>             Project: Hadoop Hive
>          Issue Type: Improvement
>          Components: Clients
>    Affects Versions: 0.7.0
>            Reporter: Bennie Schut
>            Assignee: Bennie Schut
>             Fix For: 0.7.0
>
>         Attachments: HIVE-1126-1.patch, HIVE-1126-2.patch, HIVE-1126-3.patch, 
> HIVE-1126-4.patch, HIVE-1126-5.patch, HIVE-1126-6.patch, HIVE-1126.patch, 
> HIVE-1126_patch(0.5.0_source).patch
>
>
> I've been using the hive jdbc driver more and more and was missing some 
> functionality which I added
> HiveDatabaseMetaData.getTables
> Using "show tables" to get the info from hive.
> HiveDatabaseMetaData.getColumns
> Using "describe tablename" to get the columns.
> This makes using something like SQuirreL a lot nicer since you have the list 
> of tables and just click on the content tab to see what's in the table.
> I also implemented
> HiveResultSet.getObject(String columnName) so you call most get* methods 
> based on the column name.

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