One Star

Unknown column 'cbal.status' in 'field list'

MysqlInput_1:
"select u.id, cbal.status as gateway_status, ...
I start the job:
Exception in component tMysqlInput_1
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'cbal.status' in 'field list'
2 REPLIES
Seventeen Stars

Re: Unknown column 'cbal.status' in 'field list'

We cannot help you if you do not post the whole select statement. Obviously a table with the alias cbal has no column status or the alias is wrong. In the first place this problem is not caused by Talend Studio, it is your query which does not work.
Seventeen Stars

Re: Unknown column 'cbal.status' in 'field list'

hi,
the error tell you the reason :
cbal.status is unknown column

check spelling of that column (some uppercase ?)
regards
laurent