<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>question How can I get warning from impala from JDBC? in Support Questions</title>
    <link>https://community.cloudera.com/t5/Support-Questions/How-can-I-get-warning-from-impala-from-JDBC/m-p/306712#M222974</link>
    <description>&lt;P&gt;Hello, everyone!&lt;BR /&gt;&lt;BR /&gt;I have encountered an issue with obtaining warning from query from my app.&lt;BR /&gt;&lt;BR /&gt;Let's say I have a table in impala with DDL like this:&lt;/P&gt;&lt;PRE&gt;CREATE TABLE db1.t1 (&lt;BR /&gt;    id &lt;SPAN&gt;int&lt;/SPAN&gt;, &lt;BR /&gt;    name string&lt;BR /&gt;) &lt;BR /&gt;ROW FORMAT DELIMITED FIELDS TERMINATED BY &lt;SPAN&gt;"," &lt;BR /&gt;&lt;/SPAN&gt;STORED AS TEXTFILE &lt;BR /&gt;LOCATION &lt;SPAN&gt;'/db1/t1'&lt;/SPAN&gt;;&lt;/PRE&gt;&lt;P&gt;Than I put CSV file below in table directory:&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;1&lt;/SPAN&gt;,sdf&lt;BR /&gt;dasd,&lt;SPAN&gt;2&lt;/SPAN&gt;&lt;/PRE&gt;&lt;P&gt;&lt;BR /&gt;After &amp;nbsp;I &amp;nbsp;do "INVALIDATE METADATA" and "SELECT * FROM db1.t1", I got several warnings:&lt;/P&gt;&lt;PRE&gt;WARNINGS&lt;SPAN&gt;: &lt;/SPAN&gt;Error converting column&lt;SPAN&gt;: &lt;/SPAN&gt;&lt;SPAN&gt;0 &lt;/SPAN&gt;to INT&lt;BR /&gt;Error parsing row&lt;SPAN&gt;: &lt;/SPAN&gt;file&lt;SPAN&gt;: &lt;/SPAN&gt;hdfs&lt;SPAN&gt;:&lt;/SPAN&gt;&lt;SPAN&gt;//hdpmigr.gaz.ru:8020/db1/t1/t1.csv, before offset: 21&lt;/SPAN&gt;&lt;/PRE&gt;&lt;P&gt;&lt;SPAN&gt;I want to get these warnings from my app using JDBC driver.&amp;nbsp;&lt;BR /&gt;Here is a simple class, where I want to print warnings above:&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;import &lt;/SPAN&gt;&lt;SPAN&gt;java.sql.&lt;/SPAN&gt;&lt;SPAN&gt;*&lt;/SPAN&gt;;&lt;BR /&gt;&lt;SPAN&gt;public class &lt;/SPAN&gt;&lt;SPAN&gt;Tst &lt;/SPAN&gt;{&lt;BR /&gt;    &lt;SPAN&gt;public static void &lt;/SPAN&gt;&lt;SPAN&gt;main&lt;/SPAN&gt;(&lt;SPAN&gt;String&lt;/SPAN&gt;[] &lt;SPAN&gt;args&lt;/SPAN&gt;) {&lt;BR /&gt;        &lt;SPAN&gt;try&lt;/SPAN&gt;(&lt;SPAN&gt;Connection &lt;/SPAN&gt;conn &lt;SPAN&gt;= &lt;/SPAN&gt;&lt;SPAN&gt;DriverManager&lt;/SPAN&gt;.&lt;SPAN&gt;getConnection&lt;/SPAN&gt;(&lt;SPAN&gt;"jdbc:impala://127.0.0.1:21050"&lt;/SPAN&gt;);&lt;BR /&gt;        &lt;SPAN&gt;Statement &lt;/SPAN&gt;stmt &lt;SPAN&gt;= &lt;/SPAN&gt;conn.&lt;SPAN&gt;createStatement&lt;/SPAN&gt;();&lt;BR /&gt;            &lt;SPAN&gt;ResultSet &lt;/SPAN&gt;rs &lt;SPAN&gt;= &lt;/SPAN&gt;stmt.&lt;SPAN&gt;executeQuery&lt;/SPAN&gt;(&lt;SPAN&gt;"select * from db1.t1"&lt;/SPAN&gt;)) {&lt;BR /&gt;            &lt;SPAN&gt;System&lt;/SPAN&gt;.&lt;SPAN&gt;out&lt;/SPAN&gt;.&lt;SPAN&gt;println&lt;/SPAN&gt;(conn.&lt;SPAN&gt;getWarnings&lt;/SPAN&gt;());&lt;BR /&gt;            &lt;SPAN&gt;System&lt;/SPAN&gt;.&lt;SPAN&gt;out&lt;/SPAN&gt;.&lt;SPAN&gt;println&lt;/SPAN&gt;(stmt.&lt;SPAN&gt;getWarnings&lt;/SPAN&gt;());&lt;BR /&gt;            &lt;SPAN&gt;System&lt;/SPAN&gt;.&lt;SPAN&gt;out&lt;/SPAN&gt;.&lt;SPAN&gt;println&lt;/SPAN&gt;(rs.&lt;SPAN&gt;getWarnings&lt;/SPAN&gt;());&lt;BR /&gt;            &lt;SPAN&gt;while&lt;/SPAN&gt;(rs.&lt;SPAN&gt;next&lt;/SPAN&gt;())&lt;BR /&gt;                &lt;SPAN&gt;System&lt;/SPAN&gt;.&lt;SPAN&gt;out&lt;/SPAN&gt;.&lt;SPAN&gt;println&lt;/SPAN&gt;(rs.&lt;SPAN&gt;getInt&lt;/SPAN&gt;(&lt;SPAN&gt;"id"&lt;/SPAN&gt;));&lt;BR /&gt;        } &lt;SPAN&gt;catch &lt;/SPAN&gt;(&lt;SPAN&gt;SQLException &lt;/SPAN&gt;&lt;SPAN&gt;throwables&lt;/SPAN&gt;) {&lt;BR /&gt;            &lt;SPAN&gt;throwables&lt;/SPAN&gt;.&lt;SPAN&gt;printStackTrace&lt;/SPAN&gt;();&lt;BR /&gt;        }&lt;BR /&gt;    }&lt;BR /&gt;}&lt;/PRE&gt;&lt;P&gt;&lt;SPAN&gt;All three getWarnings print "null". The question is can I somehow get warnings which I&amp;nbsp;&lt;/SPAN&gt;receive from impala-shell?&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;</description>
    <pubDate>Wed, 02 Dec 2020 11:21:57 GMT</pubDate>
    <dc:creator>Pavel_kostyukov</dc:creator>
    <dc:date>2020-12-02T11:21:57Z</dc:date>
  </channel>
</rss>

