ambari-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ishan Bhatt (JIRA)" <j...@apache.org>
Subject [jira] [Created] (AMBARI-20409) Hue Migration View Giving error while migrating Pig Jobs in Postgres DB
Date Sun, 12 Mar 2017 19:59:04 GMT
Ishan Bhatt created AMBARI-20409:
------------------------------------

             Summary: 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


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)

Mime
View raw message