helicalinsight/helicalinsight

Helical Insight software is world’s first Open Source Business Intelligence framework which helps you to make sense out of your data and make well informed decisions.

helicalinsight's Issues

Build Error

When trying to build app from source downloaded from git, getting the below issue.

Please help me resolve the issue.

Failed to execute goal org.apache.maven.plugins:maven-war-plugin:3.0.0:war (default-war)

Any plans to HI CE 3.0 in Github?

I have noticed HI EE 3.0 is available for demos, Any plans to HI CE 3.0 in Github?

SQL querry in mongoDB

Hi all,
I'm stating using HelicalInsight for a company,
I'm using commercial version of HelicalInsight to connect to my Mongo Database,
I able to connect, but I'm not able to get even one column in the collection.
My mongo database name is scrapy and the collection in which I want retrieve only the column news is feeds. The result of this query is a table in which all the raw are set to null.

Can someone help me to find the error in this configuration or tell me the way? The guide in the website is not so explicit for me.
Thank you so much @helicalinsight .

inline: {
version: '1.0',
defaultSchema: 'mongo',
schemas: [
{
type: 'custom',
name: 'mongo_raw',
factory: 'org.apache.calcite.adapter.mongodb.MongoSchemaFactory',
operand: {
host: '127.0.0.1:27017',
database: 'scrapy'
}
},
{
name: 'feeds',
tables: [
{
name: 'feeds',
type: 'view',
sql: 'select cast(_MAP['news'] AS VARCHAR(30)) AS "news" \nfrom "scrapy"."feeds"'
}
]
}
]
}

hi ce 2.0.0 build from source guide too simple

Hello, I am interested in your hi as a big data bi tool.
But I cannot build hi 2.0.0 ce from master branch.
I followed your README.md :

1. create db hice in MySQL
   exec the db.sql in */helicalinsight/db-dump/
2. config */helicalinsight/hi-ce/pom.xml at production node

systemDirectory  -  */helicalinsight/hi-repository
logLocation
dbUser
dbPassword

3. mvn clean package -Denv=production
4. copy */helicalinsight/hi-ce/target/hi-ce.war to tomcat/webapps
5. visit localhost:8080/hice/hi.html or localhost:8080/hice/*
   HTTP status 404
   When I download binary from your website, it's hi 1.0.0, not what I want.
   Where have I made a mistake as above? Can you give me any suggestion for build it myself?

as mention in the quickstart 2.2 , there is no INSTALLATIONPATH\hi-ce\hi-repository under my */helicalinsight/hi-ce/ directory

is the INSTALLATIONPATH my source code path?
when I build from source,
hi-repository
Third Party Licenses
db-dump
is in */helicalinsight/
hi-ce.war is in */helicalinsight/hi-ce/target/

Open Source?

You advertise Helical Insight as open source. Where is the source code?

do you have a hadoop spark tool to explain

understandably observably please , api

hikaricp and tomcat-jdbc dependency

Is there any reason Hikaricp and tomcat-jdbc dependency needs manually deployed instead of getting it from maven. Following versions seems to work to compile. Is that has to be 2.4.7-hi? #4

    <java7.hikaricp.version>2.7.9</java7.hikaricp.version>
    <tomcat.jdbc.version>7.0.92</tomcat.jdbc.version>

Automated installer

Hi all,

I noticed that there were a lot of issues in the installers instructions. For example, missing instructions regarding database user, database name, issues in the db.sql dump. Instead of correcting them, I thought I'd try to re-make the installation experience by automating it in Ansible for Linux at least.

At the end, I'll end up with a simple yaml file alá
setting: value-x
setting2: value-y

I'm pretty far gone atm and hope to be done in the coming week or sooner. Please note that this makes the installer omnipotent as well, meaning you can re-run it without problems. Also, this fixes that db.sql contains statement for setting the root user password and allows the user to encrypt database / hi-ce user passwords using an Ansible vault.

Anyways. This turns the complete installations into editing the yaml settings file and running three commands:

[root@ip-172-31-24-100 ansible-installer]# yum -y install python-pip && pip install ansible
[root@ip-172-31-24-100 ansible-installer]# vi vars/settings.yml
[root@ip-172-31-24-100 ansible-installer]# ansible-playbook -i hosts install_helical.yml

PLAY [localhost] *****************************************************************************************************************************************

TASK [Enable EPEL] ***************************************************************************************************************************************
ok: [localhost]

TASK [Register to RHN and auto-subscribe to available content.] ******************************************************************************************
ok: [localhost]

TASK [Enable RHSM repositories (extras, optional)] *******************************************************************************************************
ok: [localhost] => (item=rhel-7-server-extras-rpms)
ok: [localhost] => (item=rhel-7-server-optional-rpms)

TASK [Install prerequisites] *****************************************************************************************************************************
[WARNING]: Consider using the yum module rather than running 'yum'. If you need to use command because yum is insufficient you can add 'warn: false' to
this command task or set 'command_warnings=False' in ansible.cfg to get rid of this message.

changed: [localhost]

TASK [Enable MariaDB service] ****************************************************************************************************************************
ok: [localhost]

TASK [Create the Helical database user] ******************************************************************************************************************
ok: [localhost]

TASK [Import sample report to Helical database] **********************************************************************************************************
changed: [localhost]

TASK [Set hi-repository path] ****************************************************************************************************************************
ok: [localhost]

TASK [Set BaseURL to listen to] **************************************************************************************************************************
ok: [localhost]

TASK [Configure app with correct helical database user] **************************************************************************************************
ok: [localhost]

TASK [Configure app with correct helical database password] **********************************************************************************************
ok: [localhost]

TASK [Configure app with correct helical database source] ************************************************************************************************
ok: [localhost]

TASK [Deploy hi-ce war file] *****************************************************************************************************************************
changed: [localhost]

TASK [Restart tomcat] ************************************************************************************************************************************
changed: [localhost]

TASK [Print BaseURL] *************************************************************************************************************************************
ok: [localhost] => {
"msg": "Helical Insights will be reachable at: http://35.157.136.233:8080/hi-ce/hi.html"
}

PLAY RECAP ***********************************************************************************************************************************************
localhost : ok=15 changed=4 unreachable=0 failed=0

support elasticsearch

any plan for support elasticsearch?

MongoDB in HelicalInsight

Hi all,

How can I configure MongoDB on HelicalInsight on my Linux installation?

I saw one guide on http://helicalinsight.com/database-support/connect-helical-insight-mongodb/ but it is only for integrating MongoDB on Windows installation of HelicalInsight.

Thank you for your help.

Where can i create the reports?

I have built and deployed the helicalinsight 2.0.0-CE succsesfully. But i cann't find the place to create my reports, just see some guides on the Reports page. Please tell me where can i create the reports. THX.

building errors

hello all,
When I followed steps givn to build source code , some errors came to me. Some message like these:
[WARNING] The POM for com.helicalinsight:hi-vf-plugin:jar:2.0.0.0-CE is missing, no dependency information available
[INFO] ------------------------------------------------------------------------
[INFO] Reactor Summary:
[INFO]
[INFO] parent ............................................. SUCCESS [ 0.125 s]
[INFO] hi-core ............................................ SUCCESS [ 5.733 s]
[INFO] hi-cache ........................................... SUCCESS [ 0.713 s]
[INFO] hi-validation ...................................... SUCCESS [ 0.630 s]
[INFO] hi-export .......................................... SUCCESS [ 0.659 s]
[INFO] hi-externalauth .................................... SUCCESS [ 1.072 s]
[INFO] hi-hwf ............................................. SUCCESS [ 0.707 s]
[INFO] hi-scheduling ...................................... SUCCESS [ 0.769 s]
[INFO] hi-ce .............................................. FAILURE [ 0.160 s]
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 10.795 s
[INFO] Finished at: 2017-10-27T22:14:53+08:00
[INFO] Final Memory: 52M/721M
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal on project hi-ce: Could not resolve dependencies for project com.helicalinsight:hi-ce:war:2.0.0.0-CE: Failure to find com.helicalinsight:hi-vf-plugin:jar:2.0.0.0-CE in https://repo.maven.apache.org/maven2 was cached in the local repository, resolution will not be reattempted until the update interval of central has elapsed or updates are forced -> [Help 1]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/DependencyResolutionException
[ERROR]
[ERROR] After correcting the problems, you can resume the build with the command
[ERROR] mvn -rf :hi-ce

Did I miss some steps for building?
Or there is a jar file (maybe a module) which is missed?

provide a docker image

pls provide a docker image

Pom file hikaricp version

Please update hikaricp version in pom.xml file to 2.4.7 there is not version 2.4.7-hi.