How to Add Backtick Columns in TDBInput & TMap instead of select *

sakura99 — Sat, 16 Nov 2024 01:11:09 GMT

Hi all, i have to transfer data from mysql to hive.

The structure and job looks are attached. My questions are:

1.Why I cant choose column with the backticks sign ( ` xx ` ) (instead of select * when I am in tdbinput?) Ialready trying ' ' and " " but the tdbinput schema & tmap refuse it (the columns gives the red sign)

2.How to add or set autoincrement in certain columns?

topic How to Add Backtick Columns in TDBInput & TMap instead of select * in Talend Studio

How to Add Backtick Columns in TDBInput & TMap instead of select *