Questions tagged [biginsights]

IBM InfoSphere BigInsights brings the power of Hadoop to the enterprise. Apache Hadoop is the open source software framework, used to reliably manage large volumes of structured and unstructured data.

IBM InfoSphere BigInsights

103 questions
1
vote
2 answers

Any update on a replacement for IBM Analytics for Hadoop on Bluemix?

Is there any update on a replacement service for IBM Analytics for Hadoop on Bluemix? I understand the service was decommissioned in February and a beta for a replacement is in the works. I am a member of the IBM Academic Initiative who was planning…
1
vote
1 answer

MySQL issue with NULL values

I have a table with fields: country_code, short_name, currency_unit, a2010, a2011, a2012, a2013, a2014, a2015. a2010-a2015 fields are type of double. How do I make a query which orders the results by average of fields a2010-a2015, keeping in mind…
user4666255
1
vote
0 answers

can flume 1.5 handle/transfer compressed file to hdfs sink

can flume 1.5 handle/transfer compressed file to hdfs sink. i tried with blobdeserializer and compressedstream and codec as gzip. config options i used are as follows agent1.sources.c1.deserializer…
1
vote
1 answer

Sqoop eval is working but sqoop import is giving error

When i run sqoop eval its give me output. But when i do sqoop import its giving following error Error: java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLException: The Network Adapter could not establish the connection at…
Mars
  • 153
  • 2
  • 3
  • 13
1
vote
1 answer

PigLatin mismatched input ';' expecting LEFT_PAREN (IBM BIGINSIGHTS)

Sorry for a naive question. I am a newbie. I have a Pig script and getting below error: ERROR [main] org.apache.pig.tools.grunt.Grunt - ERROR 1200: mismatched input ';' expecting LEFT_PAREN This is how…
1
vote
2 answers

Creating a dashboard page using NODE-RED in IBM Bluemix

I am trying to create some charts in NODE-RED by extracting the tweets through twitter node and then generating the visualisation in IBM Big sheets.I could achieve this and able to view the charts/workbook in IBM analytics for hadoop service but I…
Balaji
  • 65
  • 3
1
vote
3 answers

Dump is not working

I am using IBM BigInsights. When I execute the DUMP command in Pig Grunt shell, I am not getting any result. Sample Input…
Ananth Francis
  • 141
  • 1
  • 4
  • 12
1
vote
1 answer

Eclipse Class not found Exception even when jars are included in classpath

Running java mapreduce program on Biginsights server from Eclipse gives com.mysql.jdbc.Driver ClassNotFoundException even though jars are included in classpath Error : The system encountered the following error while it was submitting the…
1
vote
0 answers

Can't run command create wrapper federation

I'm trying to setup BigInsights Federation to Netezza following this guideline. But when I execute command create wrapper, I got an error: [C2-BIGDATA-BIGINS-MGTNODE.VMS2.COM.VN][bigsql] 1> create wrapper nz library 'libdb2rcodbc.so' OPTIONS(MODULE…
lknguyen
  • 23
  • 6
1
vote
0 answers

HTTP/1.1 401 Access to the HttpFS server is restricted

bivm:/home/biadmin/Desktop # curl -i "http://bivm.ibm.com:14000/webhdfs/v1/tmp/newfile?op=OPEN" HTTP/1.1 401 Access to the HttpFS server is restricted. Please obtain proper credential from the BigInsights Console first. Content-Type:…
Sridhar
  • 11
  • 1
1
vote
2 answers

BigInsights Federation for Netezza

When trying to setup BigInsights Federation to Netezza following the guideline http://www.ibm.com/developerworks/library/ba-federation-biginsights/index.html After setting up all the env vars, when trying to create a wrapper to Netezza, I get the…
peterlandis
  • 645
  • 1
  • 7
  • 17
1
vote
3 answers

install IBM Big insights 3.0.0.0, the Big SQL component error and can not start

When I install IBM Big Insights Quick Start Editor 3.0.0.0, other components are correct except the Big SQL component that has an error: can not start the Big SQL Head Node and Big SQL Scheduler Nodes . When I run ./start.sh bigsql in…
huiwenhan
  • 127
  • 8
1
vote
1 answer

Hadoop Namenode without HDFS storage

I have installed a hadoop cluster with total 3 machines, with 2 nodes acting as datanodes and 1 node acting as Namenode and as well as a Datanode. I wanted to clear certain doubts regarding hadoop cluster installation and architecture. Here is a…
CodeReaper
  • 377
  • 4
  • 18
1
vote
1 answer

Filter is not working

We are trying to filter the hdfs data using Pig query.We have data enclosed within double quotes.Eg: "AAA","BBB","YYY".In which we are trying to filter YYY We tried the following ways of filter, FILTER a BY XXX == 'YYY'; FILTER a BY XXX ==…
1
vote
2 answers

How to display Information Schema using Hive?

Is there any way by which we can implement information_schema using Hive? Also, What is the process to do data profiling in Hive? Example in SQL we use Information_Schema like this : SELECT * FROM INFORMATION_SCHEMA.TABLES;
rachel
  • 225
  • 2
  • 5
  • 16