Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Cannot recognize input near..


Copy link to this message
-
Re: Cannot recognize input near..
Hi,

I think you are missing the word "table" after "overwrite".
Syntax-
insert overwrite table month_tbl select ....

https://cwiki.apache.org/confluence/display/Hive/GettingStarted

Thanks,
Aniket

On Fri, Dec 23, 2011 at 9:10 AM, Periya.Data <[EMAIL PROTECTED]> wrote:

> Hi,
>      I am trying to run a simple query in my JDBC-Client java code:
>
> ============================================================> // create mon_tbl - Monthly aggregated data
>     String mon_tblName = "month_tbl";
>     sql = "DROP TABLE IF EXISTS " + mon_tblName;
>     res = stmt.executeQuery(sql);
>     res = stmt.executeQuery("CREATE TABLE " + mon_tblName + " (ServerIP
> STRING, Month INT, BytesSent BIGINT) ROW FORMAT DELIMITED FIELDS TERMINATED
> BY ','");
>
>     sql = "INSERT OVERWRITE " + mon_tblName + " SELECT ServerIP,
> month(StartTime), SUM(BytesSent) from " + totallogs_tbl + " GROUP BY
> ServerIP, month(StartTime)";
>
>     res = stmt.executeQuery(sql);
> ============================================================>
> *ERROR Message:*
>
> Exception in thread "main" java.sql.SQLException: Query returned non-zero
> code: 11, cause: FAILED: Parse Error: line 1:17 cannot recognize input near
> 'month_tbl' 'SELECT' 'ServerIP' in destination specification
>
>     at
> org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:189)
>     at jtv_jdbc_client.main(jtv_jdbc_client.java:72)
> root@ip-10-12-97-109:/home/users/jtv/hive_jdbc#
> ====================================================================>
> I checked the field-names, made sure there are commas between the
> attributes. spell-check etc. Can we have built-in aggregate funcitons (like
> SUM) and date functions (like month(StartTime)).? To use them, should I do
> anything special? I do not understand the error statement.
>
> Please advise.
>
> Thanks,
> PD.
>

--
"...:::Aniket:::... Quetzalco@tl"
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB