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
0
votes
1 answer
how to populate "ID" field in appengine when using bulkloader?
Updated: see below
I have figured out how to get the Key Name field filled in for my dataset so that I have now reduced the write ops by 2 (down from 8). But I still have this extra empty column "ID". I have tried various configurations of the…
slashdottir
- 7,835
- 7
- 55
- 71
0
votes
1 answer
SQLXMLBulkLoad: COMExecption was caught, error connecting to the data source
I'm running into this error when trying to do a SQLXMLBulkLoad. Here's the configuration for the object:
Public Shared objbl As New SQLXMLBULKLOADLib.SQLXMLBulkLoad4
objbl.ConnectionString = ReadVariables("Data Source=localhost;Initial…
JJ.
- 9,580
- 37
- 116
- 189
0
votes
1 answer
Cannot create Active X Object
I'm running into an error and I cannot figure out what's wrong with the code. It happens when I try to create an object (objbl = CreateObject("SQLXMLBulkLoad.SQLXMLBulkload.4.0")).
Am I missing anything?
Try
objbl =…
JJ.
- 9,580
- 37
- 116
- 189
0
votes
2 answers
ORACLE 10G DELETE USING FORALL
I have a txn table which is having 2 million rows every month i am loading data into that using stored procedure. I need to delete the transactions using the following if it failed during my process and i used to load again .
Table TXN…
YesYeeYen
- 55
- 2
- 5
0
votes
1 answer
bulk-load: don't import duplicate values
I need to import everyday a file containing the yesterday's snapshot of a database. To import I use the following command in the shell:
./bin/hbase org.apache.hadoop.hbase.mapreduce.ImportTsv \
'-Dimporttsv.separator=|' \
…
nmc
- 43
- 4
0
votes
1 answer
Bulk Insert with large static data in Oracle
I have a simple table with one column of numbers. I want to load about 3000 numbers in it. I want to do that in memory, without using SQL*Loader. I tried
INSERT ALL
INTO t_table (code) VALUES (n1)
INTO t_table (code) VALUES (n2)
...
...
…
Baptiste Pernet
- 3,318
- 22
- 47
0
votes
2 answers
Trouble executing bulk load
I'm getting an error when trying to upload a .csv to my sql server using asp.net uploadfile tool. The application is on the localhost and the SQL Server is NOT located on the same machine. It creates the table inside the database with the proper…
vadim
- 211
- 1
- 5
- 19
0
votes
1 answer
Using SQLXMLBulkLoad, getting exception because column does not accept NULL values
I am trying to bulk insert XML Data into SQL Server 2005 Express with the SQLXMLBulkLoad Object Model in VB.NET using Visual Studio 2010.
When the loader gets to an element in my .xml file which does not hold a value, it throws an error because the…
Josh McKearin
- 742
- 4
- 19
- 42
0
votes
1 answer
SQLXMLBulkLoad Schema Validation Issue (Easy)
I have a huge XML file full of employees and information, and have a question.
Example of XML File:
blah
blah
blah
…
Josh McKearin
- 742
- 4
- 19
- 42
0
votes
1 answer
SQL Server 2008 / XML Bulk Load Mapping Schema / Lookup Foreign Key ID
I am trying to create an XML mapping schema for SQL Server 2008 XML bulk upload. My XML data file contains data that will populate multiple tables in my database. So far, I am able to create a mapping schema that will populate multiple tables. …
HydroPowerDeveloper
- 3,302
- 7
- 31
- 38
0
votes
1 answer
Bulk loading HTTP requests into JMeter
I am trying to write a JMeter test plan for testing a REST server. The server currently supports about 80 GET requests (plus several POST and PUT requests). Is there any easy way to create HTTP request samplers for all of the GET requests without…
Ralph
- 31,584
- 38
- 145
- 282
-1
votes
1 answer
Oracle Bulk Load takes the schema of the current connection
Oracle Bulk Load takes the schema of the current connection, is there a way to prevent it from doing so? Just in case I can't create such a synonym, I just post. That is to say that when loading the bulk load it does not take any scheme.
public…
Mario Luna
- 1
- 1
-1
votes
1 answer
MySql insert speed too slow
I am working on a project which is receiving information from GitHub API and analyze them. The problem is when ı try to insert this kind of huge data (for example in files I insert a list of lists as seen below which has 19k item in it) it takes a…
tosicann
- 13
- 3
-1
votes
1 answer
GCP MS SQL Server 2017 how to bulk load csvs from local machine
I have a Microsoft SQL Server 2017 database on Google Cloud. I'm trying to bulk load CSV files from my local machine to the database, using the following command
BULK INSERT umls.mrxw_spa
FROM 'C:\data\umls\2020AA\META\MRXW_SPA.RRF'
WITH…
yardena
- 1
-1
votes
1 answer
Java JDBC Postgres copyIn not recognizing end of line and padding double quotes
I am trying to load data from Oracle to Greenplum using Java. I store the result set as comma separated values in to byte array input stream and then load it using copy in.
import java.sql.*;
import au.com.bytecode.opencsv.CSVWriter;
import…
CuriP
- 83
- 10