You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ambari.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2018/05/17 05:52:00 UTC
[jira] [Updated] (AMBARI-23604) ParseException line 1:116
mismatched input 'ROW' expecting INTO near ')' in table buckets
specification when uploading table using Hive view 2.0.
[ https://issues.apache.org/jira/browse/AMBARI-23604?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASF GitHub Bot updated AMBARI-23604:
------------------------------------
Labels: pull-request-available (was: )
> ParseException line 1:116 mismatched input 'ROW' expecting INTO near ')' in table buckets specification when uploading table using Hive view 2.0.
> -------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: AMBARI-23604
> URL: https://issues.apache.org/jira/browse/AMBARI-23604
> Project: Ambari
> Issue Type: Bug
> Components: ambari-views
> Affects Versions: 2.6.1
> Environment: HDP 2.6.3
> Ambari 2.6.1
> Reporter: Sindhu Subhas
> Assignee: Nitiraj Singh Rathore
> Priority: Critical
> Labels: pull-request-available
> Attachments: test_csv.csv
>
>
> *Problem:*
> When uploading table using CSV file as transactional table, below is the error see:
> {code:java}
> java.lang.Exception: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:116 mismatched input 'ROW' expecting INTO near ')' in table buckets specification
> java.lang.Exception: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:116 mismatched input 'ROW' expecting INTO near ')' in table buckets specification
> at org.apache.ambari.view.hive20.resources.jobs.JobService.getOne(JobService.java:147)
> at sun.reflect.GeneratedMethodAccessor831.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
> at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205)
> at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
> at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
> at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
> at com.sun.jersey.server.impl.uri.rules.SubLocatorRule.accept(SubLocatorRule.java:137)
> at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
> at com.sun.jersey.server.impl.uri.rules.SubLocatorRule.accept(SubLocatorRule.java:137)
> at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
> at com.sun.jersey.server.impl.uri.rules.SubLocatorRule.accept(SubLocatorRule.java:137)
> at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
> at com.sun.jersey.server.impl.uri.rules.SubLocatorRule.accept(SubLocatorRule.java:137)
> at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
> at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
> at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
> at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
> at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542)
> at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473)
> at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419)
> {code}
> *Steps to replicate:*
> 1. Upload the attached file.
> 2. Select any of the columns as 'clustered'.
> 3. Under Advanced options, enable transactional and buckets=4.
> 4. Click on create table.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)