10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Guys,
I am having below file which holds data like this
file.txt
name,id,flag
apple,1,Y
apple,2,N
mango,1,Y
mango,2,Y
I need to read the above file and frame a query like this
hive -s -e "create apple_view as select 1 from main_table;"
hive -s -e "create mango_view as select... (11 Replies)
Discussion started by: rohit_shinez
11 Replies
2. Shell Programming and Scripting
On my linux box, I have a file say dump.txt.
I then need to move to another seperte folder and need to find only one file with extension *.tar that has the closest timestamp after / next to the timestamp of the dump.txt. (2 Replies)
Discussion started by: mohtashims
2 Replies
3. Shell Programming and Scripting
I need help with a regexp to find out the ip address which can possibly be present in a URL.
The URLs can be in any of the following form
<domain>?a=12345&d=somestring1
<domain>?c=10.10.10.100&d=somestring1
<domain>?a=12345&b=somestring1&c=10.1.2.4d=somestring2... (3 Replies)
Discussion started by: ampak
3 Replies
4. Shell Programming and Scripting
when i search for a file using find i want to be able to cd to the directory of the file
simple find i'm using is
find . -name <filename> the output is the full path to the file, i want to use the output to cd into the directory... I need to add this into a script
Any ideas pls (2 Replies)
Discussion started by: duckeggs01
2 Replies
5. UNIX for Dummies Questions & Answers
I have a file with 3 columns as below
column1 column2 column3
1, corporate,unix, 2300
2, business,unix, 23000
I need to replace "," with "|" as delimiter but the problem is the second column already has comma which is also getting replaced. I need... (4 Replies)
Discussion started by: praviper
4 Replies
6. Shell Programming and Scripting
I am coding shell script.
I need to connect to different databases like DB2, Oracle and Sybase.
I would then need to query tables where it has all the groups, users for that database.
I would also need who has what kind of permissions.
EG: I know for DB2 some TABAUTH table needs to be... (0 Replies)
Discussion started by: pinnacle
0 Replies
7. Shell Programming and Scripting
i have a script that performes an update operation. I just wanted to know whether that update statement is successfull or not.
Below the script:
#!/bin/ksh
. $HOME/conf/systemProperties/EnvSetup.properties
sqlplus -silent sie/da@edn.world <<END
set pagesize 0 feedback off verify off... (3 Replies)
Discussion started by: ali560045
3 Replies
8. UNIX for Dummies Questions & Answers
Hello everyone,
I have got two queries:
1) I want to do some work on files that were last modified yesterday.
Will find ... -mtime -2 be correct or -mtime-1?
2)What about finding files that were modified today? Will it be -mtime -0 or -mtime -1?
Thanks. (1 Reply)
Discussion started by: Rajat
1 Replies
9. UNIX for Advanced & Expert Users
Hi,
i have query about "find" command. Do I need to put the command after -exec in single quotes? Why?
For ex. see output of these three find commands.
Any explanations?
cheers,
-Ashish (2 Replies)
Discussion started by: shriashishpatil
2 Replies
10. UNIX for Dummies Questions & Answers
I was going through a find tutorial and just couldn't get it...can someone explain it like he/she would explain a brain damaged dodo?
"find allows you to specify a pattern that can be bit-wise ANDed with the permissions of the file. Simply put a minus sign before the octal value. The group write... (1 Reply)
Discussion started by: napolayan
1 Replies