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
Tag: linux
Add Providers MSSQL Linux
i want add a new linked server in my SQL Server (14.3026.27) Linux Red Hat Enterprise 7.5, before i add a linked server to other SQL Database, but now when i want add a linked server to MySQL i cant. I check my SQl Server linux and i found that i not had any provider in the section “Server Objects”…
How to reliably read data from a file which is being continuously written by another process?
So, I am in the situation where one process is continuously (after each few seconds) writing data to a file (not appending). The data is in the form of json. Now another process has to read this file at regular intervals. Now it could be that the reading process reads it while the writing process is writing t…
I want to output ” Killed ~” to logfile when it kill -9
I want to output this message /usr/local/ex1.sh: line xxx: <PID> Killed ex2.sh >> $LOG_FILE 2>&1 to logfile. however The “ex1.sh” output /usr/local/ex1.sh: line xxx: <PID> Killed ex2.sh >> $LOG_FILE 2>&1 to console when I executed ex1.sh in console. The result…
file descriptor unable to read 1 byte
I’m a beginner in Unix/Linux, just a question on file descriptor, my textbooks asks a question: In most Unix systems, typing ctrl-d indicates EOF on standard input. What happens if you type ctrl-d to the program in Figure 12.6(just a program that use select()) to while it is blocked in the call to selec…
All https requests from my linux vm (Centos) fail due to invalid certificate
I have been searching the web a long time to find the answer to my problem, so I’ll post this question and answer it myself. A note about the comment below that this question doesn’t belong here: In PHP (Drupal) all my curl requests to the Mandrill API suddenly stopped working. It took me a long t…
[unixODBC][Driver Manager]Can’t open lib ‘/usr/lib/x86_64-linux-gnu/odbc/psqlodbca.so’ : file not found
I have installed Postgresql 9.4 on Ubuntu 16.04, and installed postgresql ODBC and Unix ODBC drivers. When I test the ODBC connection with isql it works fine. Also, I am able to connect to the databases using pgadmin III from local and remote locations. But, when I am trying to install a software which will c…
How to fix “curl (56) Recv failure: Connection reset by peer” error when doing a port mapping from docker container to host machine?
I have a Angular Project running in a docker container at port 4200. I have done a port mapping from docker container’s 4200 port to my localhost 4200. I am running this on Ubuntu 16.04. When doing netstat -nltp, I get output tcp6 0 0 :::4200 :::* LISTEN My Dockerfile looks like : I expected when runnin…
How create build .net with MSBuild in Jenkins on Server Linux
I tried to configure jenkins that is mounted on a server with linux, is it possible to install msbuild.exe to compile a .NET application? or is it necessary for Jenkins to be on a windows server? Answer It depends on what purpose. If it is to study, I recommend installing Jenkins on a Windows Server, then ins…
Does tar exit code 123 always mean empty archive?
The tar man page only documents return codes 0, 1, and 2 but explains further: If a subprocess that had been invoked by tar exited with a nonzero exit code, tar itself exits with that code as well. This can happen, for example, if a compression option (e.g. -z) was used and the external compressor program fai…