With undoing the delimiter effect on the cut command?

Asked

Viewed 23 times

0

Good morning, everyone.

I am using a component in my work, which receives a csv to parameterize data ingestion between sql server and Hive (Hadoop).

I can only authenticate to sql server if you specify the domain in the jdbc url:

jdbc:jtds:sqlserver://${SERVER_NAME}:1433;useNTLMv2=true;domain=${DOMAIN};databaseName=${DB}

However, csv delimiter is a ; it is also the delimiter of jdbc url.

Analyzing the component code, it makes a cut-d";" ie, it makes the split by ;

I can’t update the component delimiter, because it already has several parameterized inputs in production, and all that are already in production, only go to the port part in jdbc, but as it is windows authentication, it does not work without specifying the domain.

Have some way to swap the jdbc delimiter or undo the effect of the cut command inside the url?

  • It would be feasible to use another tool to extract the URL, such as awk or sed?

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.