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

Bulk Load to HBase: ERROR : java.lang.ClassCastException: org.apache.hadoop.io.FloatWritable cannot be cast to org.apache.hadoop.hbase.Cell

In Java I've to import with MapReduce some data from a tsv file (ca 21*10^6 of rows) into an HBase table. Every row is: XYZ|XZS   YSY|SDS|XDA|JKX|SDS   0.XXXXXXXXX The HTable has 5 column family : A,B,C,D,E The first couple of everyline of the…
AbE
  • 1
  • 2
0
votes
1 answer

SAS with BULKLOAD=Yes: ERROR: BCP initialize error: Unable to retrieve error message

Has anyone encountered the error when trying to run in any of the bulk modes (not just bulkload=yes, but also insertbuff=xxx etc). The related odbcbcp.dll is present in the System32 directory, so this is not the case of being unable to find it. Runs…
access_granted
  • 1,807
  • 20
  • 25
0
votes
1 answer

elasticsearch bulk dump hundreds of thousands documents

https://www.elastic.co/guide/en/elasticsearch/client/php-api/current/_indexing_documents.html Based on Elasticsearch API document To bulk dump data to elasticsearch for($i = 0; $i < 100; $i++) { $params['body'][] = [ 'index' => [ …
searain
  • 3,143
  • 6
  • 28
  • 60
0
votes
1 answer

Regarding downloading bulk data through Python in Excel

Basically, I have created an Excel addon which connects to Odoo ERP server using xmlrpc and gets an array object. Everything is working well except when number of records are huge, it fails and throws memory error. Could someone suggest a better…
Anis Ghee
  • 121
  • 2
  • 4
0
votes
1 answer

Inserting a file into table in sql server using Stored Procedure Giving error

declare @path nvarchar(max) set @path='C:\a\SQLQuery1.sql' SELECT * FROM OPENROWSET(BULK '@path',SINGLE_BLOB) as res I am trying to execute this particular block in SQL server but its throwing error saying that Can not bulk load ,@path does…
Debashish Saha
  • 11
  • 4
0
votes
1 answer

Apache Phoenix Bulk Data Loading - Can't use table name by small letter

i have existing Phoenix table abc i wanna Bulk Data Loading via MapReduce And then used the following command to load the csv file hadoop jar /root/Phoenix/apache-phoenix-4.8.0-HBase-0.98-bin/phoenix-4.8.0-HBase-0.98-client.jar…
judid
  • 1
  • 1
0
votes
2 answers

Last Reducer is running from last 24 hour for 200 gb of data set

Hi i have one mapreduce apllication that bulk loads data into HBase . I have total 142 text files of total size 200gb. My mapper gets completed within 5 minutes and all reducer also but last one is stuck at 100%. Its taking very long time and…
Sudarshan kumar
  • 1,503
  • 4
  • 36
  • 83
0
votes
1 answer

SQL Server 2005 - Bulk Insert Problems

I am getting the following error message from a bulk load in sql server 2005, and was after ideas I can try to solve this problem. Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 2, column 4…
GordyII
  • 7,067
  • 16
  • 51
  • 69
0
votes
0 answers

Find Bulk Loader jobs in SAP BODS

Is there a straight forward way to find out through the metadata whether any BODS job is using the 'Bulk Loader Option' in its target table objects. I wanted to find all the jobs in my repository which use the Teradata Multiload option as a Bulk…
user3055262
  • 405
  • 3
  • 9
  • 20
0
votes
0 answers

bulk insert sql server

When using the T-SQL Bulk insert command from SQL Server Management Stuidio, I am getting this error randomly. Not everytime. Sometimes it would work completely fine and sometimes it throws me the below error. Error: Cannot bulk load because the…
Rob
  • 9
  • 1
  • 1
  • 3
0
votes
1 answer

Oracle destination in SSIS data flow is failing with Error- ORA-01405: fetched column value is NULL

I have one SSIS package in which there is one DFT. In DFT, I have one Oracle source and one Oracle destination. In Oracle destination I am using Data Access Mode as 'Table Name - Fast Load (Using Direct Path)' There is one strange issue with that.…
Ashok Chauhan
  • 1
  • 2
0
votes
0 answers

SQL Server Credentials not allowing bulk load to access xml file on server

I have an XML file on one of our servers which contains work data from one of our contractors. I need to be able to read the fields in this file via Geomedia Smart Client using SQL, so it will populate the Smart Client form with these values. The…
user3882865
  • 73
  • 9
0
votes
2 answers

New-ADUser is not working properly when bulk loading via .csv file

I'm running into an error where this is not picking up the password field at all... I ran the import command manually to make sure it was grabbing all of the correct data, but it errors out on the password and group info... $Users = Import-Csv -Path…
Shane Johnson
  • 157
  • 6
  • 15
0
votes
1 answer

what is the @param in elasticsearch bulk load

I am following the tutorial in https://www.elastic.co/guide/en/kibana/current/getting-started.html I downloaded the sample json files and put it in /mydirectory/data/accounts.json according to the documentation, you would type curl…
bhomass
  • 3,414
  • 8
  • 45
  • 75
0
votes
2 answers

AppEngine Bulk Upload List Property

I have a model with a list property. I have a csv that has each list data that looks like this. [u'1234567'] The list has only one item each. My bulkloader.yaml has configured import_transform: transform.none_if_empty(list). It uploads the above…
Albert
  • 3,611
  • 3
  • 28
  • 52
1 2 3
…
23 24