Re: [teiid-users] SQL on dynamically created CSV files (dynamic number of columns)
by Steven Hawkins
Hi Markos,
6.2 adds a dynamic vdb feature that creates the metadata for vdbs at runtime, see http://www.jboss.org/community/wiki/QuickStartExampleUsingConnectorsuppli... for a quick start. The only issue you may have is controlling the recreation of the vdb. Currently we support cached for the lifetime of Teiid and cached until deleted. If you need more runtime control, please create a JIRA issue.
Steve
----- Original Message -----
From: "Markos FRAGKAKIS" <markos.fragkakis(a)agilis-sa.gr>
To: teiid-users(a)lists.jboss.org
Sent: Wednesday, September 16, 2009 3:26:10 AM GMT -06:00 US/Canada Central
Subject: [teiid-users] SQL on dynamically created CSV files (dynamic number of columns)
Hi all,
I need my Java application to dynamically create CSV files (the number
of columns that are required is determined at runtime).
Can I use Teiid to apply SQL on these CSV files? In the documentation I
read in the Quickstart Guide that I need a VB, and that I need the
Designer for this. Can I not create a VB at runtime?
Cheers,
Markos
_______________________________________________
teiid-users mailing list
teiid-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/teiid-users
12 years, 11 months
SQL on dynamically created CSV files (dynamic number of columns)
by Markos FRAGKAKIS
Hi all,
I need my Java application to dynamically create CSV files (the number
of columns that are required is determined at runtime).
Can I use Teiid to apply SQL on these CSV files? In the documentation I
read in the Quickstart Guide that I need a VB, and that I need the
Designer for this. Can I not create a VB at runtime?
Cheers,
Markos
12 years, 11 months
6.2 RC1 is now available
by Steven Hawkins
Hello all,
Have a look at the latest RC1 kit. All has been going well with Designer integration so far, so the release may be a soon as the end of the week.
The Teiid Team
12 years, 11 months
unexpected query results against XML data source
by Mike Mascari
Hello. I've downloaded and installed the snapshot as of today (8/31/2009) and, using the designer:
1. Used Import->XML Schema as Relational Source Model
2. Selected Document over HTTP with no request parameters
3. Selected No Catalog
4. Chose "File System" as source of XML Schema (inlined below)
5. Chose "client" (I've tried w/"clients" as well) as the root element and "Finish"
6. Create a "purchasing" View Model and, with "purchasing" selected, created an "example" BaseTable. I then drag-and-drop "client" from clients.xmi Source Model into SOURCES pane. (This View abstraction turns out not to be the problem -- I query the Source via the Execute'd VDB with the same outcome.)
7. Created a "billing" vdb, cleaned, built, and synchronized.
8. Then, with this data served up by apache:
<?xml version="1.0" encoding="UTF-8"?>
<clients>
<client>
<name>acme</name>
<rate>15</rate>
</client>
<client>
<name>toolwerks</name>
<rate>20</rate>
</client>
</clients>
I issued the following query:
select * from clients.client
and received the expected result:
null;acme;15
null;toolwerks;20
9. Then I did this:
select * from clients.client where name = 'acme'
and received *two rows*:
null;acme;15
null;toolwerks;20
10. So I did this:
select * from clients.client where name != 'acme'
and received the expected one row:
null;toolwerks;20
???
Is there something goofy with the equality operator against XML data? Is there flag that needs flipped on these attributes? I went with the "string" mapping on the 'XML Schema as Relational Source Model' dialog wizard (pane 4 IIRC). Oughtn't I have? I also changed XML node names that might have been SQL keywords ('name' -> 'fullname') but no dice...
Thoughts?
- Mike
Schema:
<?xml version="1.0"?>
<!-- our client database -->
<xs:element name="clients">
<xs:complexType>
<xs:sequence>
<!-- the client -->
<xs:element name="client" minOccurs="1" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<!-- client name -->
<xs:element name="name" type="xs:string" minOccurs="1" maxOccurs="1"/>
<!-- bill rate -->
<xs:element name="rate" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:decimal">
<xs:minInclusive value="50"/>
<xs:maxInclusive value="250"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
12 years, 11 months
