[
https://issues.apache.org/jira/browse/AMBARI-23604?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16478782#comment-16478782
]
Hudson commented on AMBARI-23604:
---------------------------------
FAILURE: Integrated in Jenkins build Ambari-branch-2.6 #686 (See
[https://builds.apache.org/job/Ambari-branch-2.6/686/])
AMBARI-23604 : Hive View : handled table buckets specification in upload
(github:
[https://gitbox.apache.org/repos/asf?p=ambari.git&a=commit&h=0b1f8c18f14c196bf0304a4a273361be2aa051d4])
* (edit)
contrib/views/hive20/src/main/java/org/apache/ambari/view/hive20/internal/query/generators/InsertFromQueryGenerator.java
* (edit) contrib/views/pig/pom.xml
* (edit)
contrib/views/hive20/src/main/resources/ui/app/routes/databases/database/tables/upload-table.js
* (edit)
contrib/views/hive20/src/main/java/org/apache/ambari/view/hive20/resources/jobs/JobService.java
> 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
>
> Time Spent: 40m
> Remaining Estimate: 0h
>
> *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)
