[
https://issues.apache.org/jira/browse/AMBARI-20409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15927908#comment-15927908
]
Hudson commented on AMBARI-20409:
---------------------------------
SUCCESS: Integrated in Jenkins build Ambari-branch-2.5 #1272 (See
[https://builds.apache.org/job/Ambari-branch-2.5/1272/])
AMBARI-20409. Hue Migration View Giving error while migrating Pig Jobs
(pallavkul:
[http://git-wip-us.apache.org/repos/asf?p=ambari.git&a=commit&h=d65fc9be03982cd1aadcfbdc378955f0e26a656b])
* (edit)
contrib/views/hueambarimigration/src/main/java/org/apache/ambari/view/huetoambarimigration/datasource/queryset/huequeryset/pig/savedscriptqueryset/PostgressQuerySetHueDb.java
* (edit)
contrib/views/hueambarimigration/src/main/java/org/apache/ambari/view/huetoambarimigration/datasource/queryset/ambariqueryset/pig/jobqueryset/QuerySetAmbariDB.java
* (edit)
contrib/views/hueambarimigration/src/main/java/org/apache/ambari/view/huetoambarimigration/datasource/queryset/ambariqueryset/pig/savedscriptqueryset/QuerySetAmbariDB.java
> 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)
