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
3
votes
2 answers
SQLXMLBulkLoad via VBScript
I'm running the following code:
Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")
objBL.ConnectionString = "provider=SQLOLEDB.1;data
source=mySQLServer;database=myDB;uid=SA;pwd=myPword"
objBL.ErrorLogFile = "c:\error.log"
…
Dexter
- 795
- 2
- 13
- 27
3
votes
1 answer
How to set schema for janusgraph for batch-loading using python
I am trying to bulk-load data into a janusgraph 0.2 over HBase. I am using gremlinpython library of python. For bulk-loading, I set storage.batch-loading to true, and now have to define the schema for the graph.
I found documentation to set schema…
Tushar Aggarwal
- 827
- 1
- 10
- 26
3
votes
1 answer
Load S3 data into Aurora MySQL instance
I'm trying to load the data in S3 into Aurora MySQL instance. I did it using PySpark and the performance of that is at 4 GB per hour.
current_df.write.format('jdbc').options(
url=url,
driver=jdbc_driver,
…
data_addict
- 816
- 3
- 15
- 32
3
votes
3 answers
Bulk Load Data Conversion Error - Can't Find Answer
For some reason I keep receiving the following error when trying to bulk insert a CSV file into SQL Express:
Bulk load data conversion error (type mismatch or invalid character for the
specified codepage) for row 2, column 75 (Delta_SM_RR).
Msg…
ls101
- 177
- 5
- 17
3
votes
1 answer
IF ELSE Condition inside FORALL Oracle
Can you guys share with how to do IF ELSE Inside a FORALL?
This is my current code that working fine.
FOR DECLARATION;
TYPE t_column1 IS TABLE OF USERS.column1%TYPE;
TYPE t_column2 IS TABLE OF USERS.column1%TYPE;
arr_column1 …
shukor
- 33
- 1
- 3
3
votes
1 answer
Creating XML Schema for Bulk Load to SQL Server - Child Element Describes Parent
I have an XML document that I'm working to build a schema for in order to bulk load these documents into a SQL Server table. The XML I'm focusing on looks like this:
BI
BI
…
B. Hanson
- 31
- 1
3
votes
2 answers
why hbase KeyValueSortReducer need to sort all KeyValue
I am learning Phoenix CSV Bulk Load recently and I found that the source code of org.apache.phoenix.mapreduce.CsvToKeyValueReducer will cause OOM ( java heap out of memory ) when columns are large in one row (In my case, 44 columns in one row and…
CrazyPig
- 137
- 12
3
votes
2 answers
Read XML file into SQL Server database
I'm trying to read an XML file into a database table that already exists.
The problem is that the XML tags and the database columns don't have the same name although they have the same datatype. Therefore I'd like to "translate" the XML tags into…
Simon.S
- 107
- 1
- 1
- 9
3
votes
2 answers
MonetDB bulk load with auto increment
I am trying to load csv files into monetdb table(s) with auto increment PK/Id columns using copy into from file....
table has auto increment PK column.
table has more columns than incoming csv files.
csv file doesnt have Pk/Id column.
Is…
