Skip to content

Tag: sql

Arguments mismatch using where IN clause in query

I have column in hive table like below Now I want to get the distinct values as a variable so I can use in another query. I have done like below when I do I get below error what the the mistake I am doing? What is the correct way of achieving my result? Note: I know I can use

How to use a sql DB for ssh?

I have a webapplication and I would like to provide the users with a feature to be able to ssh to the linux server without having to add all the users’ credentials from the Psql DB to the linux server. Instead I would like to use the credentials directly for ssh. I think that this is possible using linu…