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

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

TestJdbcDriver is not passing: one failure and one error.

 <testcase classname="org.apache.hadoop.hive.jdbc.TestJdbcDriver" 
name="testMetaDataGetTables" time="0.977">                                      
                                                       
    <failure message="expected:&lt;src&gt; but 
was:&lt;testhivedriverpartitionedtable&gt;" 
type="junit.framework.AssertionFailedError">junit.framework.AssertionFailedError:
 expected:&lt;src&gt; but was\
:&lt;testhivedriverpartitionedtable&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(TestJdbcDriver.java:334)
                                                                                
                      
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)          
                                                                                
                                          
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)   
                                                                                
                               
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.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(JUnitTestRunner.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(JUnitTestRunner.java:785)
                                                                                
                    
</failure>                                                                      
                                                                                
                                          
  </testcase>                                                                   
                                                                                
                                          
  <testcase classname="org.apache.hadoop.hive.jdbc.TestJdbcDriver" 
name="testMetaDataGetCatalogs" time="0.819" />                                  
                                                       
  <testcase classname="org.apache.hadoop.hive.jdbc.TestJdbcDriver" 
name="testMetaDataGetTableTypes" time="0.753" />                                
                                                       
  <testcase classname="org.apache.hadoop.hive.jdbc.TestJdbcDriver" 
name="testMetaDataGetColumns" time="0.967">                                     
                                                       
    <error message="Unrecognized column type: array&lt;int&gt;" 
type="java.sql.SQLException">java.sql.SQLException: Unrecognized column type: 
array&lt;int&gt;                                            
        at 
org.apache.hadoop.hive.jdbc.HiveResultSetMetaData.hiveTypeToSqlType(HiveResultSetMetaData.java:119)
                                                                                
            
        at 
org.apache.hadoop.hive.jdbc.JdbcColumn.getSqlType(JdbcColumn.java:61)           
                                                                                
                               
        at 
org.apache.hadoop.hive.jdbc.HiveDatabaseMetaData$2.next(HiveDatabaseMetaData.java:198)
                                                                                
                         
        at 
org.apache.hadoop.hive.jdbc.TestJdbcDriver.testMetaDataGetColumns(TestJdbcDriver.java:411)
                                                                                
                     
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)          
                                                                                
                                          
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)   
                                                                                
                               
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.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)                  
                                                                                
                                          
   

> 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.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.

Reply via email to