To bulk load means to import a data file in a user-specified format into a database table or view.
Questions tagged [bulk-load]
351 questions
-1
votes
1 answer
ORA-01555 error when updating 200 million rows with BULK COLLECT
I have the following PL/SQL code, which updates one column of each row in a table with about 200 million rows. I use BULK COLLECT to repeatedly fetch 150,000 rows from the table and update the rows. I do a commit after 50,000 updates.
DECLARE
…
Said Savci
- 818
- 4
- 14
- 28
-1
votes
2 answers
How to perform bulk upload in mongoose (node.js)
I am trying to perform bulk upload in node js and mongodb is my db,can anyone suggest me some best articles regarding this.Thanks in advance.
MMR
- 2,869
- 13
- 56
- 110
-1
votes
1 answer
Bulk import/load csv to sqlite using Python
i have searched for a method to do a bulk import of a csv to sqlite using python script.
Currently i am using an insert which runs for every row of the csv:
with open('file_name.csv','rb') as fin:
Read_csv = csv.DictReader(fin) # comma is…
user1474157
- 1,379
- 2
- 11
- 13
-2
votes
1 answer
Flowfile absolute path Nifi
I'm trying to load the flow files into MySQL database using bulk load option. Below is the query I'm using as part of the UpdateAttribute processor and passing that query to PutSQL after updating the parameters to do bulk load.
LOAD DATA INFILE…
data_addict
- 816
- 3
- 15
- 32
-3
votes
1 answer
Insert data from Excel sheet with multiple tabs into SQL Server into multiple tables
Suppose there are 5 worksheets for 5 tables in SQL Server, how do I write a single code to insert bulk data from this 5 sheets to 5 tables in SQL Server.
Souvik Pal
- 21
- 3
-3
votes
1 answer
Migration/copy of files (mostly pdf, but some jpeg, doc, excel, html ..) from Unix to Azure.
Migration/copy of files (mostly pdf, but some jpeg, doc, excel, html ..) from Unix to Azure.
Total size – 9-12 TB
1 in 1,000 files are larger than 25 MB
Biggest file found is 720 MB
Over 30 million documents with thousands of directories
70-90%…
yogesh
- 23
- 3