Groups keyboard shortcuts have been updated
Dismiss
See shortcuts

Re: Wildcard as variable in Templates

23 views
Skip to first unread message
Message has been deleted

Rajat Venkatesh

unread,
Mar 1, 2016, 8:09:24 PM3/1/16
to ekim...@gmail.com, Qubole Public Forum
Try %$XYZ$% instead. Then the input from the user will be inserted between the wildcard operators.
On Tue, 1 Mar 2016 at 23:55, <ekim...@gmail.com> wrote:
Hi all,

Is it possible to have a wildcard as a variable when creating a template? The template creator wont recognize this as a variable, "where Field like $%XYZ%$". 


--
You received this message because you are subscribed to the Google Groups "Qubole Public Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to qubole-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/qubole-users/63cd93a3-8a1b-4aee-9788-c8217d9e80ec%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Rajat Venkatesh

unread,
Mar 24, 2016, 5:13:36 AM3/24/16
to Eugene Kim, Qubole Public Forum
+Qubole users

Unfortunately there is no clean way. The only solution I can think of is to write the query as

Where ... employee_id in ($list$)

One concern I have is that you may get stuck in escaping the quotes.

On Wed, 23 Mar 2016 at 01:45, Eugene Kim <ekim...@gmail.com> wrote:
Hi Rajat!

Template question again. Is there a way to write the template to be able to accept one or multiple inputs?

How would I write the line where it does this:
where employee_id in ('12345')
and/or 
where employee_id in ('12345, '54321', '24689')

Thank you!
Eugene

On Wed, Mar 2, 2016 at 11:17 AM, Eugene Kim <ekim...@gmail.com> wrote:
Thank you!

Rajat Venkatesh

unread,
May 16, 2016, 8:42:37 PM5/16/16
to Eugene Kim, qubole...@googlegroups.com
+Qubole Public Forum 
Hi Eugene,
Adding qubole-users to this thread again. I was traveling and couldn't respond faster. You'll get much more prompt help if you send your queries to the forum. 

How long was the string approximately ? We should be able to handle very very long queries. This just maybe a UI artifact and with a reproducer (a command id), we can report to the engg. team.

On Thu, May 12, 2016 at 8:17 AM Eugene Kim <ekim...@gmail.com> wrote:
Hi again Rajat,

Is there a character limit for input variables? I noticed that when I put a long list of numbers within a where clause that are surrounded by ticks e.g. '1', '2, '3' etc, most of them were red text and the rest were black text.

Thanks!
Eugene
Reply all
Reply to author
Forward
0 new messages