Stack Overflow
Stack Overflow

Questions tagged [bigsql]

IBM® Big SQL is one of two connection environments to query data that is stored on an InfoSphere® BigInsights™ Hadoop cluster.

IBM® Db2® Big SQL is a hybrid SQL engine for Hadoop that delivers data querying for the enterprise. Use a single database connection or query to connect to disparate sources such as HDFS, RDMS, NoSQL databases, object stores and WebHDFS.

47 questions
0
votes
1 answer

How to force file content to be processed sequenctially?

I got a requirement to process the file as it is means the file content should be processed as it appears in the file. For Example: I have a file and size is 700MBs. How we can make sure the file will be processed as it appears since it depends on…
Mohammed Niaz
  • 386
  • 1
  • 5
  • 17
0
votes
1 answer

BigSQL-HBase Integration

I am newbie to BigSQL. I came to know that HBase can be integrated with BigSQL. I had tried to execute the BigSQL-HBase create commands after and before creating the HBase tables but I am getting the error which is mentioned below. SQL1: CREATE…
user3792699
  • 339
  • 3
  • 7
  • 17
0
votes
0 answers

How to load data into Hbase table from BIGSQL table?

I am new to Hadoop Development. In our company, we are using IBM BigInsights cluster and we are working on an HBASE project. We have a requirement to load data from HDFS to HBASE. To do that, I am familiar with 3 ways: 1. Load data from HDFS into…
LazyBones
  • 113
  • 6
0
votes
1 answer

Load hadoop with sql query option - failing

I am trying to use LOAD HADOOP command to copy data from teradata source. LOAD HADOOP USING JDBC CONNECTION URL 'jdbc:teradata://<>/database=EDW01_V_LV_BASE' WITH PARAMETERS ('user' = 'USR1','password'='pass1') FROM SQL QUERY 'SELECT…
Koushik Chandra
  • 1,565
  • 12
  • 37
  • 73
0
votes
1 answer

Bluemix Analytics for Apache Hadoop Big SQL - How to access logs for debug?

I am using Big SQL from Analytics for Apache Hadoop in Bluemix and would like to look into logs in order to debug (e.g. map reduce job log - usually available under http://my-mapreduce-server.com:19888/jobhistory, bigsql.log from the Big SQL worker…
HLeu
  • 13
  • 2
0
votes
3 answers

How to copy data inside BIGSQL table to .txt

this might be very silly question but I am getting a hard time to figure out a way to copy data inside my BIGSQL table to a .txt in local file system.
LazyBones
  • 113
  • 6
0
votes
1 answer

LOAD HADOOP fails while pulling from Teradata

I am using IBM BigInsights version 4.1.0. I used the below command to pull data from teradata. LOAD HADOOP USING JDBC CONNECTION URL 'jdbc:teradata://<>/database=<>' WITH PARAMETERS ('user' =…
Koushik Chandra
  • 1,565
  • 12
  • 37
  • 73
0
votes
3 answers

Bigsql like predicate error

I am writing sql query for bigsql. If it looks like this select t.city from table t where t.city like 'A%' It works ok, but next one fails: select t.city from table t where t.city like 'A%' escape '\' I only add escape expression and it give…
user2281439
  • 673
  • 2
  • 11
  • 19
0
votes
1 answer

permission issue between hive and bigsql

I am using BigInsights version 3.0. I have created a table in bigsql and inserting into that table from hive. But the process is failing at the end when trying to move the file Failed with exception Unable to move…
Koushik Chandra
  • 1,565
  • 12
  • 37
  • 73
0
votes
1 answer

How to truncate or delete partition from db2 using bigsql?

I have table in db2 (using bigsql) that is partitioned as per date on IBM BigInsights table_name_abc 20150810 data corresponding to partition 20150811 data corresponding to partition .... what I want is to delete particular…
Raunak Kathuria
  • 3,185
  • 1
  • 18
  • 27
0
votes
1 answer

How can we create procedure in BigSQL?

I am trying to create procedure in BigSQL. where i got some syntax error since i used db2 systax.Could you please tell me. what is the systax for procedure creation in BigSQL.
rayan
  • 11
0
votes
1 answer

Can't connect to Big SQL from Analytics for Apache Hadoop on IBM Bluemix

I am using the newest version 'Analytics for Apache Hadoop' on IBM Bluemix. I am following the tutorial to config the ODBC driver.…
Lily D
  • 11
  • 2
0
votes
1 answer

INSERT INTO in BigSQL exception

I am creating a table (say table1) in Big SQL, and loading the data from HDFS into table1. Now from this table1, I need to to load data to another table say table2, based on certain conditions and on daily basis append more data into this table2.…
Raunak Kathuria
  • 3,185
  • 1
  • 18
  • 27
0
votes
1 answer

Nested Concatenation in BigSQL

I'm attempting to concatenate three fields in BigSQL. I can successfully concatenate two fields with SELECT CONCAT(column1, column2) FROM table; but I am unable to concatenate three fields with that (only accepts two arguments). I have attempted a…
Robert Wertz
  • 186
  • 2
  • 14
-1
votes
1 answer

How to find rows that have a DBCException: SQL Error: CharConversionExcetion in DB2?

I am trying to find rows in a table, that seems to have a DBCException in the cell value. I cannot seem to find a quick way to figure out the unique rows that have this exception. Error stored in the cell: DBCException: SQL Error:…
Daenerys
  • 462
  • 4
  • 8
1 2
3
4