How to write query string in bash?

Asked Jun 04 '20 at 00:42

Active Jun 04 '20 at 00:48

Viewed 21 times

I am trying to build a query string in bash to execute in a sqoop command.

Here is what I have so far:

  d1=$(date +'%Y%m')
  STR="Select * from Table1 where dtmn = "
  Query=$STR$d1

Now if I use this it will select * from my directory vs build this as a string. If I use \ to escape then when I call it using echo I get:

  d1=$(date +'%Y%m')
  STR="Select \* from Table1 where dtmn = "
  Query=$STR$d1
  echo $Query

  ['Select \\* from Table1 where dtmn = 202006']

This breaks in my sqoop command as soon as it gets to the \.

What do I need to do to dynamically build this query string in bash based on the date, and execute it in a sqoop command?

edited Jun 04 '20 at 00:48

asked Jun 04 '20 at 00:42

user3486773

You can't have spaces around `=` in bash assignments. – Barmar Jun 04 '20 at 00:44
Always quote your variables: `echo "$Query"` – Barmar Jun 04 '20 at 00:45
The spaces are not in the code and mistakenly typed out when posting the question. I think I fixed in in the question though. – user3486773 Jun 04 '20 at 00:47
As an aside, you can put the entire query in the argument to `date`: `Query=$(date +'select * from table1 where dtmn = %Y%m')`. – chepner Jun 04 '20 at 00:56

0 Answers0