Stack Overflow
Stack Overflow

Questions tagged [bulk-load]

To bulk load means to import a data file in a user-specified format into a database table or view.

351 questions
0
votes
1 answer

SQL read file, access denied error

I have the following SQL procedure: DECLARE @stament as nvarchar(max) set @stament='SELECT BulkColumn FROM OPENROWSET (BULK '''+ @Path+''', SINGLE_BLOB) MyFile ' EXECUTE sp_executesql @stament when I execute it, an error occurs: Cannot…
Hassan Shouman
  • 275
  • 4
  • 13
0
votes
0 answers

What are the main issues you are likely to face when migrating from a bespoke system to JIRA?

It seems relatively straightforward from the documentation here Prepare SQL query to extract data to that format in CSV Run Wizard Profit However there must be some gotchas and oversights that people have experienced when performing this…
adolf garlic
  • 3,034
  • 7
  • 39
  • 54
0
votes
1 answer

mysql importing data locally basics

currently learning mysql and hit a wall when it comes to importing data locally. I think I'm missing something. The data I want to import is from a notepad, I'm going to guess it wont be possible from a notepad? if anyone could give me some brief…
Jonathan Clark
  • 47
  • 1
  • 10
0
votes
3 answers

Mapr-Db bulkloading is failing at reducer end

Bulkload failed while processing the reducer with following error. We are running the mapreduce on M5 cluster trying to update a m7 table. java.io.IOException: bulkLoaderClose() on '/home/test/account122' failed with error: Function not implemented…
Abhiram
  • 362
  • 1
  • 2
  • 14
0
votes
1 answer

DB2 Import with modified timestamp format for time with EDT/EST attached to it

I have a file import_file.csv with the below mentioned timestamp format. Oct/21/2013 09:45:01 AM EDT Dec/04/2013 04:41:01 PM EST I created a table in IBM DB2 v9.7 create table table_import_timestamp ( my_timestamp timestamp ) And then tried…
Abhi
  • 314
  • 1
  • 7
  • 23
0
votes
0 answers

Bulk load in multiple MapR table

I have a map reduce job which will do a bulk load in MapR table one at time. If i have to load another Mapr DB table then i will have to write another job for doing bulk load.Is there any way to do bulk load in single map reduce job? Thanks in…
Shashi
  • 2,686
  • 7
  • 35
  • 67
0
votes
1 answer

Why BULK INSERT/BCP includes Sort operator although I have done everything to avoid that? (SQL Server 2012)

I have a problem with BULK INSERT/BCP process that includes sort operator although I have done everything to avoid that. Firstly, I have exported the data to file with BCP (native format) using queryout and with "ORDER BY Id ASC, Created ASC"…
LSZ
  • 21
  • 2
  • 7
0
votes
1 answer

Hbase BulkLoad without mapreduce

I'm wondering if it is possibile to write a java program that do a BulkLoad on HBase. I'm on a hadoop cluster but I don't need to write a MapReduce Job for some reason. Thanks
Pennywise83
  • 1,784
  • 5
  • 31
  • 44
0
votes
2 answers

Exception : org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.AccessControlException): Permission denied: user=hbase, access=EXECUTE

I am trying to perform BulkLoad into Hbase. The input to map reduce is hdfs file(from Hive). Using the below code in Tool(Job) class to initiate the bulk loading process HFileOutputFormat.configureIncrementalLoad(job, new HTable(config,…
Ramzy
  • 6,948
  • 6
  • 18
  • 30
0
votes
1 answer

XSD validation issue when doing xmlbulkload into sql server 2008

I'm using vbscript to perform an XMLBulkLoad into SQL Server 2008. My upload is triggered by the following: objBL.execute "schedules.xsd", "scheduletest.xml" This is triggering correctly. However, when I try to upload with my schema as is, I get…
BishNaboB
  • 1,047
  • 1
  • 12
  • 25
0
votes
1 answer

sstableloader of cassandra - java.lang.OutOfMemoryError

I tried to use bulk load by sstableloader, and following "www.datastax.com/dev/blog/using-the-cassandra-bulk-loader-updated r" and "github.com/yukim/cassandra-bulkload-example/". but got error when use sstableloader to load data, as below: command:…
chio
  • 11
  • 2
0
votes
2 answers

Using XML output from API to bulk upload to SQL server

I'm looking for a way to use XML Bulk Load (or an other method, I'm open to alternatives) to load data from an XML file generated from an API request into a SQL database. I can see how I would use XML Bulk Load to load the saved XML files into the…
BishNaboB
  • 1,047
  • 1
  • 12
  • 25
0
votes
2 answers

monetdb bulk copy | bulk copy with python

Am facing issue with file loading for bulk import in monetdb table. provided below are details for re creation of issue: I have installed monetdb version 11.19.9 and python client for monetdb is 11.19.9 too. Created dbform and it's working fine, I…
sharafjaffri
  • 2,134
  • 3
  • 30
  • 47
0
votes
2 answers

NHibernate bulk loading child objects for multiple parents

Let's say we have a Category table and Product table. And each Product references Category. So each Category has many Products. I want to load many Categories without Products(to decrease DB access time) then check what Categories we actually need…
Serhiy
  • 4,357
  • 5
  • 37
  • 53
0
votes
1 answer

SQLXML Bulk Load connection string

I use SQLXML Bulk Load to import data from xml to DB. With MS Sql Server 2008 works great. SQLXMLBULKLOADLib.SQLXMLBulkLoad4 objBL = new SQLXMLBULKLOADLib.SQLXMLBulkLoad4(); objBL.ConnectionString =…
e1s
  • 335
  • 4
  • 22
1 2 3
…
23 24