gistfile1.txt

14:37:23,844 INFO  [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50026 VDB "PREVIEW_52c7d282-cfd7-4c28-a988-504563c0e148_ExampleCSV_ViewModel.1[ViewModel{}]" undeployed.
14:37:23,847 INFO  [org.teiid.RUNTIME] (MSC service thread 1-7) TEIID50026 VDB "PREVIEW_52c7d282-cfd7-4c28-a988-504563c0e148_ExampleCSV_project.1[]" undeployed.
14:37:23,848 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-1) JBAS015877: Stopped deployment PREVIEW_52c7d282-cfd7-4c28-a988-504563c0e148_ExampleCSV_ViewModel.vdb (runtime-name: PREVIEW_52c7d282-cfd7-4c28-a988-504563c0e148_ExampleCSV_ViewModel.vdb) in 5ms
14:37:23,850 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015876: Starting deployment of "PREVIEW_52c7d282-cfd7-4c28-a988-504563c0e148_ExampleCSV_ViewModel.vdb" (runtime-name: "PREVIEW_52c7d282-cfd7-4c28-a988-504563c0e148_ExampleCSV_ViewModel.vdb")
14:37:23,868 INFO  [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50029 VDB PREVIEW_52c7d282-cfd7-4c28-a988-504563c0e148_ExampleCSV_ViewModel.1 model "ViewModel" metadata is currently being loaded. Start Time: 17/06/15 14:37
14:37:23,870 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID50030 VDB PREVIEW_52c7d282-cfd7-4c28-a988-504563c0e148_ExampleCSV_ViewModel.1 model "ViewModel" metadata loaded. End Time: 17/06/15 14:37
14:37:23,879 WARN  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 1) TEIID31080 ViewModel.StatesView validation error: TEIID30352 SOURCEMODEL.GETTEXTFILES does not exist.
14:37:23,879 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID40073 The metadata for the VDB PREVIEW_52c7d282-cfd7-4c28-a988-504563c0e148_ExampleCSV_ViewModel.1 is loaded, however it is not valid. Check models for errors. Correct the metadata and re-deploy.
14:37:23,879 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID40003 VDB PREVIEW_52c7d282-cfd7-4c28-a988-504563c0e148_ExampleCSV_ViewModel.1 is set to ACTIVE
14:37:23,900 INFO  [org.jboss.as.server] (management-handler-thread - 35) JBAS018565: Replaced deployment "PREVIEW_52c7d282-cfd7-4c28-a988-504563c0e148_ExampleCSV_ViewModel.vdb" with deployment "PREVIEW_52c7d282-cfd7-4c28-a988-504563c0e148_ExampleCSV_ViewModel.vdb"
14:37:24,498 INFO  [org.jboss.as.repository] (management-handler-thread - 34) JBAS014900: Content added at location /opt/jboss-7.1/standalone/data/content/75/427dee4230bf6cdb9ec78ca61ecaa48808d54d/content
14:37:24,503 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015877: Stopped deployment PREVIEW_52c7d282-cfd7-4c28-a988-504563c0e148_ExampleCSV_project.vdb (runtime-name: PREVIEW_52c7d282-cfd7-4c28-a988-504563c0e148_ExampleCSV_project.vdb) in 4ms
14:37:24,504 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-5) JBAS015876: Starting deployment of "PREVIEW_52c7d282-cfd7-4c28-a988-504563c0e148_ExampleCSV_project.vdb" (runtime-name: "PREVIEW_52c7d282-cfd7-4c28-a988-504563c0e148_ExampleCSV_project.vdb")
14:37:24,521 INFO  [org.teiid.RUNTIME] (MSC service thread 1-8) TEIID40003 VDB PREVIEW_52c7d282-cfd7-4c28-a988-504563c0e148_ExampleCSV_project.1 is set to ACTIVE
14:37:24,545 INFO  [org.jboss.as.server] (management-handler-thread - 34) JBAS018565: Replaced deployment "PREVIEW_52c7d282-cfd7-4c28-a988-504563c0e148_ExampleCSV_project.vdb" with deployment "PREVIEW_52c7d282-cfd7-4c28-a988-504563c0e148_ExampleCSV_project.vdb"
14:37:24,546 INFO  [org.jboss.as.repository] (management-handler-thread - 34) JBAS014901: Content removed from location /opt/jboss-7.1/standalone/data/content/b0/eb58196561558624a627903bf063594ea6d0fc/content
14:37:25,594 INFO  [org.teiid.PLANNER] (Worker8_QueryProcessorQueue65) 
============================================================================
USER COMMAND:
SELECT ViewModel.StatesView.State, ViewModel.StatesView.Acronym, ViewModel.StatesView.Founded, ViewModel.StatesView.Capital FROM ViewModel.StatesView

----------------------------------------------------------------------------
OPTIMIZE: 
SELECT ViewModel.StatesView.State, ViewModel.StatesView.Acronym, ViewModel.StatesView.Founded, ViewModel.StatesView.Capital FROM ViewModel.StatesView

----------------------------------------------------------------------------
GENERATE CANONICAL: 
SELECT ViewModel.StatesView.State, ViewModel.StatesView.Acronym, ViewModel.StatesView.Founded, ViewModel.StatesView.Capital FROM ViewModel.StatesView

CANONICAL PLAN: 
Project(groups=[ViewModel.StatesView], props={PROJECT_COLS=[ViewModel.StatesView.State, ViewModel.StatesView.Acronym, ViewModel.StatesView.Founded, ViewModel.StatesView.Capital]})
  Source(groups=[ViewModel.StatesView], props={NESTED_COMMAND=SELECT A.State, A.Acronym, A.Founded, A.Capital FROM (EXEC SourceModel.getTextFiles('usstates.csv')) AS f CROSS JOIN TEXTTABLE(f.file COLUMNS State string, Acronym string, Founded string, Capital string ESCAPE '

============================================================================
EXECUTING PlaceAccess

AFTER: 
Project(groups=[ViewModel.StatesView], props={PROJECT_COLS=[ViewModel.StatesView.State, ViewModel.StatesView.Acronym, ViewModel.StatesView.Founded, ViewModel.StatesView.Capital]})
  Source(groups=[ViewModel.StatesView], props={NESTED_COMMAND=SELECT A.State, A.Acronym, A.Founded, A.Capital FROM (EXEC SourceModel.getTextFiles('usstates.csv')) AS f CROSS JOIN TEXTTABLE(f.file COLUMNS State string, Acronym string, Founded string, Capital string ESCAPE '

SELECT
A.State, A.Acronym, A.Founded, A.Capital
FROM
(EXEC SourceModel.getTextFiles('usstates.csv')) AS f, TEXTTABLE(f.file COLUMNS State string, Acronym string, Founded string, Capital string ESCAPE '\u0000' HEADER) AS A