Questions tagged [apache-metamodel]

The Apache Metamodel project provides a common interface for discovery, exploration of metadata and querying of different types of data sources.

Project Homepage: https://metamodel.apache.org/

47 questions
1
vote
1 answer

What are feature not supported by Apache Metamodel Salesforce conenctor

I had gone through the API provided by Apache metamodel to connect Salesforce.com, most of API are there which can help perform CURD operation. But, i am unable to find the features which are not supported by Apache metamodel API's. Is there any…
Afgan
  • 1,022
  • 10
  • 32
1
vote
1 answer

Apache Metamodel How to add foreign keys while creating tables

I've written a code to create some tables by apache metamodel: dataContext.executeUpdate(new UpdateScript() { @Override public void run(UpdateCallback updateCallback) { updateCallback.createTable(schema,…
1
vote
0 answers

How to cast result of a query containing an aggregate function using apache metamodel

I am new to apache metamodel. And I need to run following query using apache metamodel. "select sum(cast(columnName as decimal)) from table;" I know that a query containing simple sum function looks like the one given below: Query query =…
TGiri
  • 131
  • 6
1
vote
1 answer

Apache metamodel is throwing exception when trying to get sum of very large number of numeric data

I am new to apache metamodel. I am using it for getting sum of any numeric column in a database table using following code: Object object = null; long sum = 0; String columnName = table.getColumn(iColumnNumber).getName(); …
TGiri
  • 131
  • 6
1
vote
1 answer

Insert UUID data type values in Cassandra Database Using Apache Metamodel

I want to insert UUID type values in Cassandra database using Apache Metamodel. For text data type I am using like .values("ColName", value) How can I insert UUID type values?
deen
  • 2,185
  • 7
  • 29
  • 53
1
vote
0 answers

Timestamp to complete date format

We are working on oracle 11g enterprises edition. We are facing issue in getting value of date for type TIMESTAMPTZ and TIMESTAMPLTZ. We are storing those dates into one csv file using apache metamodel. We are fetching date from database using : …
Neelam Sharma
  • 2,745
  • 4
  • 32
  • 73
1
vote
0 answers

how I get view data using DataContext of apache meta modal?

I have create sample program using DataContext class for get all information of tables and write into csv file.Can I use DataContext or any other options in java for getting information of all views? My sample code for getting table and write into…
santosh
  • 435
  • 1
  • 7
  • 24
1
vote
1 answer

Apache MetaModel select by id from MongoDB

I am validating Apache MetaModel as a storage abstraction layer and experienced problem with primary key lookup in MongoDB. As we know every document in mongo has unique _id column with ROWID type, and using metamodel I can't even to run query…
mishadoff
  • 10,719
  • 2
  • 33
  • 55
1
vote
1 answer

Is Apache metamodel thread safe?

I am using Apache metamodel to access information stored in CSV and Excel files. I am only performing read operations. I am wondering if it is safe to create only a single instance of DataContext for each file and reuse it across multiple threads. I…
Dan Corneanu
  • 336
  • 2
  • 11
1
vote
0 answers

apache metamodel -where on non-string columns in files

I need your help, I'm using org.apache.metamodel in order to read DataSet of files (excel, csv..), while doing so I've noticed that all the returned columns are classified as "String", my problem is that I'm trying to filter columns values using…
0
votes
0 answers

apache metamodel not giving column constraint name , Table create time / update time

I am exploring apache metamodel to my next project to fetch database metadata from db table and found apache metamodel but while testing I see a few columns are not available in apache metamodel like TABLE_ROWS from…
Danny M
  • 92
  • 8
0
votes
1 answer

How to represent Self join in Apache Metamodel using JdbcContext?

Consider I have an employee table which has the following fields id, name, email, phone, joining_date, manager, department. Now in this table manager field can be used to create a self join and arrive at a result set which says employee e1 reports…
0
votes
1 answer

Execute select query in Apache metamodel

I am using Apache meta model with postgres database. I want to execute a simple SQL select query. Can some one please help me how to achieve this functionality ??
Subhradip Bose
  • 3,065
  • 2
  • 13
  • 17
0
votes
1 answer

Modify the metamodel's schema to change/rename column names

I am using Apache MetaModel to get the schema information. There is one use case, where I need to create CsvDataContext object for csv file with no header. I have column names in a separate data structure (List colNames). The context object…
Praful Surve
  • 788
  • 1
  • 10
  • 22
0
votes
0 answers

Can we use zookeeper to store offset in kafka apache metamodel

Apache MetaModel kafka consumer not working for zookeepers offset storage. I am using Apache MetaModel 5.1 and kafka version 0.10.2.1. I am facing issue with kafka consumer(metamodel internal consumer) as its not consuming any messages from topic my…
Shraddha
  • 154
  • 1
  • 11