The proper syntax for the split is $col$

2 followers
0
Avatar

Hi,

I am creating an import job and I am getting error in data details tabs as below 

"The proper syntax for the split is $col$"

My query is bit complex. I am working in oracle11 database. 

Please help me to resolve the issue.


Also, Please confirm is it mandatory to start query with select. Because I am using source table and my query starts like 

WITH
source_table as (
select..........

How to create job for this type of query.

 

Saurabh Jain

8 comments

  • Avatar
    Konsta Danyliuk

    Hello Saurabh,

    • Could you please let me know what Datameer version do you use?
    • Please provide full custom query you are trying set in ImportJob wizard?
    0
  • Avatar
    Saurabh Jain

    Hello,

    Datameer Version - 5.11.17

    Could you please provide email so that I can share my query as well.

     

     

    0
  • Avatar
    Konsta Danyliuk

    Hello Saurabh,

    I've made quick research on your question,could you let me know the following, please:

    • Do you have any $ symbols in your query?

    • Would it be possible for you to leverage the next workaround - create a View based on required query and then choose this view in Datameer ImportJob to avoid custom query usage?

    Thank you in advance.

    0
  • Avatar
    Saurabh Jain

    Hi,

    1. Yes, I do have $ symbol in my query but it is just to show currency in $. I have removed it but still getting error " query should start from select".

    2. About the workaround -- I don't have access to create view in database. Is there any way so I can create view in datameer ?

    Thank you.

    0
  • Avatar
    Konsta Danyliuk

    Hello Saurabh,

    • This is known limitation to custom queries that have $ symbol, as it's used (as the service one) for enabling parallel import for such jobs.

    • Another mandatary requirement is to start a custom query with SELECT statement.

    >> Is there any way so I can create view in datameer?

    Roughly speaking, Datameer considers a database View and a table. This options allows you prepare data before ingest it into Datameer. 

    In case you are unable to create a View, I might import whole table into Datameer and then transform data as needed in a Workbook. 

    You may try to use Datalink instead of ImportJob to decrease amount of imported data, as a DataLink just points to the dataset. 

     

     

     

    0
  • Avatar
    Saurabh Jain

    Hello.

    I have removed the $ from query and made some changes as per the datameer standard. It worked for me. I am able to connect to data source using job.

    Thank you !!

    0
  • Avatar
    Saurabh Jain

    Hello,

    I need one more help.

    1. I am able to create the workbook with my import job . Now I want to send this report/workbook to multiple people via email. How can I send. ( data is small cab be send over email). This is a job which run every hour and email should go every hour.

    2. Also, I want to create the visualization of the same in tabular format but when I am not able to add data to widget ( I am selecting Table widgets from others)

    0
  • Avatar
    Konsta Danyliuk

    Hello Saurabh,

    I'm glad to hear that you were able move forward with your custom query.

    Regarding to your next questions about the Workbook, may I ask you to create a new post, to keep different questions in separate threads, it's more convenient for search and track purposes.

    Please provide the next details in this new post.

    • What exactly do you need to send - final sheet with calculation's results or workbook configuration?

    • What exactly problems do you face when trying to create an infographic?

     

    0
Please sign in to leave a comment.