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] [Updated] (AMBARI-20409) Hue Migration View Giving error while migrating Pig Jobs in Postgres DB
Date Mon, 13 Mar 2017 00:21:04 GMT

     [ https://issues.apache.org/jira/browse/AMBARI-20409?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Ishan Bhatt updated AMBARI-20409:
---------------------------------
    Attachment: AMBARI-20409.patch

> 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)

Mime
View raw message