You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ambari.apache.org by "Hadoop QA (JIRA)" <ji...@apache.org> on 2017/03/13 14:08:41 UTC
[jira] [Commented] (AMBARI-20409) Hue Migration View Giving error
while migrating Pig Jobs in Postgres DB
[ https://issues.apache.org/jira/browse/AMBARI-20409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15907516#comment-15907516 ]
Hadoop QA commented on AMBARI-20409:
------------------------------------
{color:red}-1 overall{color}. Here are the results of testing the latest attachment
http://issues.apache.org/jira/secure/attachment/12857539/AMBARI-20409.patch
against trunk revision .
{color:green}+1 @author{color}. The patch does not contain any @author tags.
{color:red}-1 tests included{color}. The patch doesn't appear to include any new or modified tests.
Please justify why no new tests are needed for this patch.
Also please list what manual steps were performed to verify this patch.
{color:green}+1 javac{color}. The applied patch does not increase the total number of javac compiler warnings.
{color:green}+1 release audit{color}. The applied patch does not increase the total number of release audit warnings.
{color:green}+1 core tests{color}. The patch passed unit tests in contrib/views/hueambarimigration.
Test results: https://builds.apache.org/job/Ambari-trunk-test-patch/10992//testReport/
Console output: https://builds.apache.org/job/Ambari-trunk-test-patch/10992//console
This message is automatically generated.
> Hue Migration View Giving error while migrating Pig Jobs in Postgres DB
> -----------------------------------------------------------------------
>
> Key: AMBARI-20409
> URL: https://issues.apache.org/jira/browse/AMBARI-20409
> Project: Ambari
> Issue Type: Bug
> Components: ambari-views
> Reporter: Ishan Bhatt
> Assignee: Ishan Bhatt
> Fix For: trunk, 2.5.0
>
> Attachments: AMBARI-20409.patch
>
>
> While Migrating pig Job
> Error displayed:-
> {code}
> SQL Exception: ERROR: column "ds_inprogress" is of type boolean but expression is of type integer Hint: You will need to rewrite or cast the expression. Position: 46
> {code}
> Log:-
> {code}
> 0 Mar 2017 12:00:38,477 INFO [Thread-64] PigJobMigrationUtility:139 - Loop No.1
> 10 Mar 2017 12:00:38,477 INFO [Thread-64] PigJobMigrationUtility:140 - ________________
> 10 Mar 2017 12:00:38,477 INFO [Thread-64] PigJobMigrationUtility:141 - the title of script describeSchema
> 10 Mar 2017 12:00:38,501 ERROR [Thread-64] PigJobMigrationUtility:191 - sql exception in ambari database:
> org.postgresql.util.PSQLException: ERROR: column "ds_inprogress" is of type boolean but expression is of type integer
> Hint: You will need to rewrite or cast the expression.
> Position: 46
> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
> at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
> at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
> at org.apache.ambari.view.huetoambarimigration.migration.pig.pigjob.PigJobMigrationImplementation.insertRowPigJob(PigJobMigrationImplementation.java:204)
> at org.apache.ambari.view.huetoambarimigration.migration.pig.pigjob.PigJobMigrationUtility.pigJobMigration(PigJobMigrationUtility.java:155)
> at org.apache.ambari.view.huetoambarimigration.migration.pig.pigjob.PigJobStartJob.run(PigJobStartJob.java:59)
> 10 Mar 2017 12:00:38,503 INFO [Thread-64] PigJobMigrationUtility:195 - roll back done
> 10 Mar 2017 12:00:38,510 INFO [Thread-64] PigJobMigrationUtility:225 - ------------------------------
> 10 Mar 2017 12:00:38,510 INFO [Thread-64] PigJobMigrationUtility:226 - pig Job Migration End
> 10 Mar 2017 12:00:38,510 INFO [Thread-64] PigJobMigrationUtility:227 - ------------------------------
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)