Sponsored Content
Top Forums Shell Programming and Scripting Read CSV file and delete hdfs, hive and hbase tables Post 303004880 by shivamayam on Tuesday 10th of October 2017 10:05:31 AM
Old 10-10-2017
Read CSV file and delete hdfs, hive and hbase tables

I have a CSV file with hdfs directories, hive tables and hbase tables.

1. first column - hdfs directories
2. second column - hive tables
3. third column - hbase tables

I have to check the csv file and look for the first column and delete the hdfs directory from the hdfs path, now search for the second column and delete the hive table, after that look for third column and delete the hbase table.

appreciate your help.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

[HELP] - Delete rows on a CSV file

Hello to all members, I am very new in unix stuff (shell scripting), but a want to learn a lot. I am a ex windows user but now i am absolutely Linux super user... :D So i am tryng to made a function to do this: I have two csv files only with numbers, the first one a have: 1 2 3 4 5... (6 Replies)
Discussion started by: Sadarrab
6 Replies

2. Shell Programming and Scripting

Read Csv file

Hi All, I need to check if a csv file is empty, leaving the first line as the first line is header pls help Thanks (3 Replies)
Discussion started by: gwrm
3 Replies

3. UNIX and Linux Applications

Does anybody know how to store my tables to a csv file?

Hi I'm using an oracle database... Lets call it databasename My username and password are the same .... lets all that andrea/andrea So I want to write a script to copy all the data from my table called tablename and store that data to a csv file called filename. I cant seem to get... (2 Replies)
Discussion started by: ladyAnne
2 Replies

4. Shell Programming and Scripting

read .csv file

Need UNIX script read below .csv file and print the line only records where type = TRN. Srno,Type,InputFileName,NewColumnData 1,TRN,File1.dat,11 2,TRN,File2.dat,12 3,TRN,File3.dat,13 4,REF,File4.dat, 5,REF,File5.dat, regards, santosh (4 Replies)
Discussion started by: santosh2k2
4 Replies

5. UNIX for Dummies Questions & Answers

When reading a csv file, counter to read 20 lines and wait for minute then read next 20 till end

Hello All, i am a newbie and need some help when reading a csv file in a bourne shell script. I want to read 10 lines, then wait for a minute and then do a reading of another 10 lines and so on in the same way. I want to do this till the end of file. Any inputs are appreciated ... (3 Replies)
Discussion started by: victor.s
3 Replies

6. Shell Programming and Scripting

Read .csv file

Hello, this is my very first comment on this forum and i hope i don't mess it up. If i do, please forgive me (also for any language mistakes you may wanna know that i'm not native speaking). As i just started doing a bigger paper for my studies i got a bunch of data in seperate csv-files... (1 Reply)
Discussion started by: FabianDe
1 Replies

7. Shell Programming and Scripting

Writing Hbase and pig scripts in the bash script file

Hi, I have a script file where i'm validatig the input file and storing the validated records on HDFS. I wanted to load data from HDFS to HBASE using pig script. So for that i have created a HBASE table and written pig script to load data from HDFS to HBASE which is working fine. Now i wanted... (0 Replies)
Discussion started by: shree11
0 Replies

8. Shell Programming and Scripting

Splitting csv into 3 tables in html file

I have the data in csv in 3 tables. how can I output the same into 3 tables in html.also how can I set the width. tried multiple options . attached is the format. #!/bin/ksh awk 'BEGIN{ FS="," print "<HTML><BODY><TABLE border = '1' cellpadding=10 width=100>" print... (7 Replies)
Discussion started by: archana25
7 Replies

9. Programming

How to arhive hive external tables?

Hi Guys, Is there a way to check hive external tables which are created 90 days before and drop those tables along with underlying hdfs data. Can this be achieved in unix script? (10 Replies)
Discussion started by: Master_Mind
10 Replies

10. UNIX for Beginners Questions & Answers

Shell Script to read hive table and send email

HI Team, I am working on reading hive table and send email in email body using shell script, can you please help on fixing the errors: I have 6 columns in my hive table and trying to send the email in the mail body. below script: #!/bin/bash hive -e 'SELECT count(*) from db.table' >... (4 Replies)
Discussion started by: Mi4304
4 Replies
DTIF(5) 							File Formats Manual							   DTIF(5)

Name
       DTIF - Digital Table Interchange Format

Description
       Digital	Table Interchange Format (DTIF) is the standard format for the storage and interchange of documents that contain data tables, for-
       mulas, and spreadsheets. You can use DTIF to store and retrieve database information, interchange spreadsheets, and reference table data in
       compound documents.

       DTIF defines the logical structure and physical layout of a data table, the values within the table (absolute data and/or expressions), and
       presentation attributes (formatting) to be used when displaying or printing the table. DTIF works with Digital Document Interchange  Format
       (DDIF) so that you can store or reference DTIF tables in DDIF-encoded compound documents.

       A  DTIF	document  can  contain	a sequence of one or more tables and is uniquely identified by a product name, a version number, and other
       descriptive information such as the document's title and creation date.	Each DTIF table is a 2-dimensional display of  data  values  orga-
       nized in columns and rows that has its own structure and table data stored in cells.

       In  DTIF  documents,  attributes  specify  the  type  and format of information pertaining to the data stored in a table. Column attributes
       describe information for all the cells in a particular column, whereas generic column attributes can be applied to any column in any  table
       that  references  them. Format attributes define the printed and displayed presentation of data stored in the table.  Format attributes can
       also be redefined at the window, column, or cell level.

See Also
       CDA(5), DDIF(5), DTIF(5)
       Compound Document Architecture Manual

																	   DTIF(5)
All times are GMT -4. The time now is 06:11 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy