You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pig.apache.org by ga...@apache.org on 2010/04/16 01:56:50 UTC
svn commit: r934649 [3/24] - in /hadoop/pig/trunk/contrib: ./ owl/ owl/bin/
owl/ci/ owl/ci/test_results/ owl/ci/test_scripts/ owl/docs/ owl/ivy/
owl/java/ owl/java/lib/ owl/java/main/ owl/java/main/META-INF/
owl/java/main/org/ owl/java/main/org/apache/...
Added: hadoop/pig/trunk/contrib/owl/ci/test_results/operatorTest.exp
URL: http://svn.apache.org/viewvc/hadoop/pig/trunk/contrib/owl/ci/test_results/operatorTest.exp?rev=934649&view=auto
==============================================================================
--- hadoop/pig/trunk/contrib/owl/ci/test_results/operatorTest.exp (added)
+++ hadoop/pig/trunk/contrib/owl/ci/test_results/operatorTest.exp Thu Apr 15 23:56:44 2010
@@ -0,0 +1,174 @@
+<COMMAND> drop owltable testOwlTable within owldatabase testOwldatabase
+<IGNORE>
+<COMMAND> drop owltable testOwlTable1 within owldatabase testOwldatabase
+<IGNORE>
+<COMMAND> drop owltable testOwlTable2 within owldatabase testOwldatabase
+<IGNORE>
+<COMMAND> drop owldatabase testOwldatabase
+<IGNORE>
+<COMMAND> create owldatabase testOwldatabase identified by storage directory "hdfs://namenode:8080/data/testowldatabase"
+<SUCCESS>
+<COMMAND> select owldatabase objects where owldatabase in (testOwldatabase)
+<RESULT> OwlDatabase 1
+{"creationTime":0,"modificationTime":0,"name":"testowldatabase","storageLocation":"hdfs://namenode:8080/data/testowldatabase"}
+<COMMAND> create owltable type basic testOwlTable within owldatabase testOwldatabase define property key retention:INTEGER partitioned by LIST with partition key year:INTEGER define property key month:INTEGER, date:INTEGER schema "test1:int"
+<SUCCESS>
+<COMMAND> create owltable type basic testOwlTable1 within owldatabase testOwldatabase define property key retention:INTEGER partitioned by LIST with partition key year:INTEGER define property key month:INTEGER, date:INTEGER schema "test1:int"
+<SUCCESS>
+<COMMAND> create owltable type basic testOwlTable2 within owldatabase testOwldatabase define property key domain:STRING partitioned by LIST with partition key country:STRING define property key climate:STRING, date:INTEGER schema "test1:int"
+<SUCCESS>
+<COMMAND> publish dataelement to owltable testOwlTable within owldatabase testOwldatabase partition (year = 2009) property (retention = 1, month = 8, date = 1) schema "c1:collection(r1:record(f1:int, f2:int))" delocation "http"
+<SUCCESS>
+<COMMAND> publish dataelement to owltable testOwlTable within owldatabase testOwldatabase partition (year = 2008) property (retention = 0, month = 7, date = 0) schema "c1:collection(r1:record(f1:int, f2:int))" delocation "http2"
+<SUCCESS>
+<COMMAND> publish dataelement to owltable testOwlTable within owldatabase testOwldatabase partition (year = 2010) property (retention = 2, month = 9, date = 2) schema "c1:collection(r1:record(f1:int, f2:int))" delocation "http3"
+<SUCCESS>
+<COMMAND> publish dataelement to owltable testOwlTable1 within owldatabase testOwldatabase partition (year = 2009) property (retention = 1, month = 8, date = 1) schema "c1:collection(r1:record(f1:int, f2:int))" delocation "http4"
+<SUCCESS>
+<COMMAND> publish dataelement to owltable testOwlTable1 within owldatabase testOwldatabase partition (year = 2008) property (retention = 0, month = 7, date = 0) schema "c1:collection(r1:reocrd(f1:int, f2:int))" delocation "http5"
+<EXCEPTION> org.apache.hadoop.owl.common.OwlException : 6002 : Error occurred while processing schema string. Cause : Encountered " <IDENTIFIER> "reocrd "" at line 1, column 18.
+<COMMAND> publish dataelement to owltable testOwlTable1 within owldatabase testOwldatabase partition (year = 2010) property (retention = 2, month = 9, date = 2) schema "c1:collection(r1:record(f1:int, f2:int))" delocation "http6"
+<SUCCESS>
+<COMMAND> publish dataelement to owltable testOwlTable2 within owldatabase testOwldatabase partition (country = "usa") property (domain = "us", climate = "windy", date = 1) schema "c1:collection(r1:record(f1:int, f2:int))" delocation "http7"
+<SUCCESS>
+<COMMAND> publish dataelement to owltable testOwlTable2 within owldatabase testOwldatabase partition (country = "india") property (domain = "asia", climate = "sunny", date = 10) schema "c1:collection(r1:record(f1:int, f2:int))" delocation "http8"
+<SUCCESS>
+<COMMAND> publish dataelement to owltable testOwlTable2 within owldatabase testOwldatabase partition (country = "london") property (domain = "uk", climate = "rainy", date = 11) schema "c1:collection(r1:record(f1:int, f2:int))" delocation "http9"
+<SUCCESS>
+<COMMAND> select dataelement objects from owltable testOwlTable within owldatabase testOwldatabase with partition ( year >= 2009) property ( month >= 8, date >= 1)
+<RESULT> OwlDataElement 2
+{"creationTime":0,"keyValues":[{"dataType":"INT","intValue":2009,"keyName":"year","keyType":"PARTITION"},{"dataType":"INT","intValue":8,"keyName":"month","keyType":"PROPERTY"},{"dataType":"INT","intValue":1,"keyName":"retention","keyType":"PROPERTY"},{"dataType":"INT","intValue":1,"keyName":"date","keyType":"PROPERTY"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","schema":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"f1","type":"INT"},{"columnNumber":1,"name":"f2","type":"INT"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"storageLocation":"http"}
+{"creationTime":0,"keyValues":[{"dataType":"INT","intValue":2010,"keyName":"year","keyType":"PARTITION"},{"dataType":"INT","intValue":9,"keyName":"month","keyType":"PROPERTY"},{"dataType":"INT","intValue":2,"keyName":"retention","keyType":"PROPERTY"},{"dataType":"INT","intValue":2,"keyName":"date","keyType":"PROPERTY"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","schema":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"f1","type":"INT"},{"columnNumber":1,"name":"f2","type":"INT"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"storageLocation":"http3"}
+<COMMAND> select dataelement objects from owltable testOwlTable within owldatabase testOwldatabase with partition ( year = 2009) property ( month = 8, date = 1)
+<RESULT> OwlDataElement 1
+{"creationTime":0,"keyValues":[{"dataType":"INT","intValue":2009,"keyName":"year","keyType":"PARTITION"},{"dataType":"INT","intValue":8,"keyName":"month","keyType":"PROPERTY"},{"dataType":"INT","intValue":1,"keyName":"retention","keyType":"PROPERTY"},{"dataType":"INT","intValue":1,"keyName":"date","keyType":"PROPERTY"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","schema":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"f1","type":"INT"},{"columnNumber":1,"name":"f2","type":"INT"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"storageLocation":"http"}
+<COMMAND> select dataelement objects from owltable testOwlTable within owldatabase testOwldatabase with partition ( year <= 2009) property ( month <= 8, date <= 1)
+<RESULT> OwlDataElement 2
+{"creationTime":0,"keyValues":[{"dataType":"INT","intValue":2009,"keyName":"year","keyType":"PARTITION"},{"dataType":"INT","intValue":8,"keyName":"month","keyType":"PROPERTY"},{"dataType":"INT","intValue":1,"keyName":"retention","keyType":"PROPERTY"},{"dataType":"INT","intValue":1,"keyName":"date","keyType":"PROPERTY"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","schema":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"f1","type":"INT"},{"columnNumber":1,"name":"f2","type":"INT"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"storageLocation":"http"}
+{"creationTime":0,"keyValues":[{"dataType":"INT","intValue":2008,"keyName":"year","keyType":"PARTITION"},{"dataType":"INT","intValue":7,"keyName":"month","keyType":"PROPERTY"},{"dataType":"INT","intValue":0,"keyName":"retention","keyType":"PROPERTY"},{"dataType":"INT","intValue":0,"keyName":"date","keyType":"PROPERTY"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","schema":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"f1","type":"INT"},{"columnNumber":1,"name":"f2","type":"INT"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"storageLocation":"http2"}
+<COMMAND> select dataelement objects from owltable testOwlTable within owldatabase testOwldatabase with partition ( year < 2009) property ( month < 8, date < 1)
+<RESULT> OwlDataElement 1
+{"creationTime":0,"keyValues":[{"dataType":"INT","intValue":2008,"keyName":"year","keyType":"PARTITION"},{"dataType":"INT","intValue":7,"keyName":"month","keyType":"PROPERTY"},{"dataType":"INT","intValue":0,"keyName":"retention","keyType":"PROPERTY"},{"dataType":"INT","intValue":0,"keyName":"date","keyType":"PROPERTY"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","schema":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"f1","type":"INT"},{"columnNumber":1,"name":"f2","type":"INT"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"storageLocation":"http2"}
+<COMMAND> select dataelement objects from owltable testOwlTable within owldatabase testOwldatabase with partition ( year > 2009) property ( month > 8, date > 1)
+<RESULT> OwlDataElement 1
+{"creationTime":0,"keyValues":[{"dataType":"INT","intValue":2010,"keyName":"year","keyType":"PARTITION"},{"dataType":"INT","intValue":9,"keyName":"month","keyType":"PROPERTY"},{"dataType":"INT","intValue":2,"keyName":"retention","keyType":"PROPERTY"},{"dataType":"INT","intValue":2,"keyName":"date","keyType":"PROPERTY"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","schema":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"f1","type":"INT"},{"columnNumber":1,"name":"f2","type":"INT"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"storageLocation":"http3"}
+<COMMAND> select dataelement objects from owltable testOwlTable within owldatabase testOwldatabase with partition ( year > 2011) property ( month > 8, date > 1)
+<SUCCESS>
+<COMMAND> select dataelement objects from owltable testOwlTable within owldatabase testOwldatabase with partition ( year < 2007) property ( month < 8, date < 1)
+<SUCCESS>
+<COMMAND> select dataelement objects from owltable testOwlTable within owldatabase testOwldatabase with partition ( year > 2009) property ( month < 8, date < 1)
+<SUCCESS>
+<COMMAND> select dataelement objects from owltable testOwlTable within owldatabase testOwldatabase with partition ( year < 2009) property ( month > 8, date > 1)
+<SUCCESS>
+<COMMAND> select dataelement objects from owltable testOwlTable within owldatabase testOwldatabase with partition ( year < 2009) property ( month >= 8, date >= 1)
+<SUCCESS>
+<COMMAND> select dataelement objects from owltable testOwlTable1 within owldatabase testOwldatabase with partition ( year >= 2009) property ( month >= 8, date >= 1)
+<RESULT> OwlDataElement 2
+{"creationTime":0,"keyValues":[{"dataType":"INT","intValue":2009,"keyName":"year","keyType":"PARTITION"},{"dataType":"INT","intValue":8,"keyName":"month","keyType":"PROPERTY"},{"dataType":"INT","intValue":1,"keyName":"retention","keyType":"PROPERTY"},{"dataType":"INT","intValue":1,"keyName":"date","keyType":"PROPERTY"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","schema":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"f1","type":"INT"},{"columnNumber":1,"name":"f2","type":"INT"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"storageLocation":"http4"}
+{"creationTime":0,"keyValues":[{"dataType":"INT","intValue":2010,"keyName":"year","keyType":"PARTITION"},{"dataType":"INT","intValue":9,"keyName":"month","keyType":"PROPERTY"},{"dataType":"INT","intValue":2,"keyName":"retention","keyType":"PROPERTY"},{"dataType":"INT","intValue":2,"keyName":"date","keyType":"PROPERTY"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","schema":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"f1","type":"INT"},{"columnNumber":1,"name":"f2","type":"INT"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"storageLocation":"http6"}
+<COMMAND> select dataelement objects from owltable testOwlTable1 within owldatabase testOwldatabase with partition ( year = 2009) property ( month = 8, date = 1)
+<RESULT> OwlDataElement 1
+{"creationTime":0,"keyValues":[{"dataType":"INT","intValue":2009,"keyName":"year","keyType":"PARTITION"},{"dataType":"INT","intValue":8,"keyName":"month","keyType":"PROPERTY"},{"dataType":"INT","intValue":1,"keyName":"retention","keyType":"PROPERTY"},{"dataType":"INT","intValue":1,"keyName":"date","keyType":"PROPERTY"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","schema":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"f1","type":"INT"},{"columnNumber":1,"name":"f2","type":"INT"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"storageLocation":"http4"}
+<COMMAND> select dataelement objects from owltable testOwlTable1 within owldatabase testOwldatabase with partition ( year <= 2009) property ( month <= 8, date <= 1)
+<RESULT> OwlDataElement 1
+{"creationTime":0,"keyValues":[{"dataType":"INT","intValue":2009,"keyName":"year","keyType":"PARTITION"},{"dataType":"INT","intValue":8,"keyName":"month","keyType":"PROPERTY"},{"dataType":"INT","intValue":1,"keyName":"retention","keyType":"PROPERTY"},{"dataType":"INT","intValue":1,"keyName":"date","keyType":"PROPERTY"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","schema":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"f1","type":"INT"},{"columnNumber":1,"name":"f2","type":"INT"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"storageLocation":"http4"}
+<COMMAND> select dataelement objects from owltable testOwlTable1 within owldatabase testOwldatabase with partition ( year < 2009) property ( month < 8, date < 1)
+<SUCCESS>
+<COMMAND> select dataelement objects from owltable testOwlTable1 within owldatabase testOwldatabase with partition ( year > 2009) property ( month > 8, date > 1)
+<RESULT> OwlDataElement 1
+{"creationTime":0,"keyValues":[{"dataType":"INT","intValue":2010,"keyName":"year","keyType":"PARTITION"},{"dataType":"INT","intValue":9,"keyName":"month","keyType":"PROPERTY"},{"dataType":"INT","intValue":2,"keyName":"retention","keyType":"PROPERTY"},{"dataType":"INT","intValue":2,"keyName":"date","keyType":"PROPERTY"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","schema":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"f1","type":"INT"},{"columnNumber":1,"name":"f2","type":"INT"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"storageLocation":"http6"}
+<COMMAND> select dataelement objects from owltable testOwlTable1 within owldatabase testOwldatabase with partition ( year > 2011) property ( month > 8, date > 1)
+<SUCCESS>
+<COMMAND> select dataelement objects from owltable testOwlTable1 within owldatabase testOwldatabase with partition ( year < 2007) property ( month < 8, date < 1)
+<SUCCESS>
+<COMMAND> select dataelement objects from owltable testOwlTable1 within owldatabase testOwldatabase with partition ( year > 2009) property ( month < 8, date < 1)
+<SUCCESS>
+<COMMAND> select dataelement objects from owltable testOwlTable1 within owldatabase testOwldatabase with partition ( year < 2009) property ( month > 8, date > 1)
+<SUCCESS>
+<COMMAND> select dataelement objects from owltable testOwlTable1 within owldatabase testOwldatabase with partition ( year < 2009) property ( month >= 8, date >= 1)
+<SUCCESS>
+<COMMAND> select dataelement objects from owltable testOwlTable2 within owldatabase testOwldatabase with partition ( country LIKE "%us%") property ( climate LIKE "%dy%")
+<RESULT> OwlDataElement 1
+{"creationTime":0,"keyValues":[{"dataType":"STRING","keyName":"country","keyType":"PARTITION","stringValue":"usa"},{"dataType":"STRING","keyName":"domain","keyType":"PROPERTY","stringValue":"us"},{"dataType":"INT","intValue":1,"keyName":"date","keyType":"PROPERTY"},{"dataType":"STRING","keyName":"climate","keyType":"PROPERTY","stringValue":"windy"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","schema":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"f1","type":"INT"},{"columnNumber":1,"name":"f2","type":"INT"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"storageLocation":"http7"}
+<COMMAND> select dataelement objects from owltable testOwlTable2 within owldatabase testOwldatabase with partition ( country LIKE "%us%") property ( climate LIKE "%dy%", date > 2)
+<SUCCESS>
+<COMMAND> select dataelement objects from owltable testOwlTable2 within owldatabase testOwldatabase with partition ( country LIKE "%us%") property ( climate LIKE "%dy%", date >= 2)
+<SUCCESS>
+<COMMAND> select dataelement objects from owltable testOwlTable2 within owldatabase testOwldatabase with partition ( country LIKE "%in%") property ( climate LIKE "%dy%", date >= 2)
+<SUCCESS>
+<COMMAND> select dataelement objects from owltable testOwlTable2 within owldatabase testOwldatabase with partition ( country LIKE "%in%") property ( climate LIKE "%y%", date >= 2)
+<RESULT> OwlDataElement 1
+{"creationTime":0,"keyValues":[{"dataType":"STRING","keyName":"country","keyType":"PARTITION","stringValue":"india"},{"dataType":"STRING","keyName":"domain","keyType":"PROPERTY","stringValue":"asia"},{"dataType":"INT","intValue":10,"keyName":"date","keyType":"PROPERTY"},{"dataType":"STRING","keyName":"climate","keyType":"PROPERTY","stringValue":"sunny"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","schema":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"f1","type":"INT"},{"columnNumber":1,"name":"f2","type":"INT"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"storageLocation":"http8"}
+<COMMAND> select dataelement objects from owltable testOwlTable2 within owldatabase testOwldatabase with partition ( country LIKE "%l%") property ( climate LIKE "%%", date >= 2)
+<RESULT> OwlDataElement 1
+{"creationTime":0,"keyValues":[{"dataType":"STRING","keyName":"country","keyType":"PARTITION","stringValue":"london"},{"dataType":"STRING","keyName":"domain","keyType":"PROPERTY","stringValue":"uk"},{"dataType":"INT","intValue":11,"keyName":"date","keyType":"PROPERTY"},{"dataType":"STRING","keyName":"climate","keyType":"PROPERTY","stringValue":"rainy"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","schema":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"f1","type":"INT"},{"columnNumber":1,"name":"f2","type":"INT"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"storageLocation":"http9"}
+<COMMAND> select dataelement objects from owltable testOwlTable2 within owldatabase testOwldatabase with partition ( country LIKE "%%") property ( climate LIKE "%%", date >= 2)
+<RESULT> OwlDataElement 2
+{"creationTime":0,"keyValues":[{"dataType":"STRING","keyName":"country","keyType":"PARTITION","stringValue":"india"},{"dataType":"STRING","keyName":"domain","keyType":"PROPERTY","stringValue":"asia"},{"dataType":"INT","intValue":10,"keyName":"date","keyType":"PROPERTY"},{"dataType":"STRING","keyName":"climate","keyType":"PROPERTY","stringValue":"sunny"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","schema":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"f1","type":"INT"},{"columnNumber":1,"name":"f2","type":"INT"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"storageLocation":"http8"}
+{"creationTime":0,"keyValues":[{"dataType":"STRING","keyName":"country","keyType":"PARTITION","stringValue":"london"},{"dataType":"STRING","keyName":"domain","keyType":"PROPERTY","stringValue":"uk"},{"dataType":"INT","intValue":11,"keyName":"date","keyType":"PROPERTY"},{"dataType":"STRING","keyName":"climate","keyType":"PROPERTY","stringValue":"rainy"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","schema":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"f1","type":"INT"},{"columnNumber":1,"name":"f2","type":"INT"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"storageLocation":"http9"}
+<COMMAND> select dataelement objects from owltable testOwlTable2 within owldatabase testOwldatabase with partition ( country LIKE "%%") property ( climate LIKE "%%", date <= 2)
+<RESULT> OwlDataElement 1
+{"creationTime":0,"keyValues":[{"dataType":"STRING","keyName":"country","keyType":"PARTITION","stringValue":"usa"},{"dataType":"STRING","keyName":"domain","keyType":"PROPERTY","stringValue":"us"},{"dataType":"INT","intValue":1,"keyName":"date","keyType":"PROPERTY"},{"dataType":"STRING","keyName":"climate","keyType":"PROPERTY","stringValue":"windy"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","schema":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"f1","type":"INT"},{"columnNumber":1,"name":"f2","type":"INT"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"storageLocation":"http7"}
+<COMMAND> select dataelement objects from owltable testOwlTable2 within owldatabase testOwldatabase with partition ( country LIKE "%%") property ( climate LIKE "%%")
+<RESULT> OwlDataElement 3
+{"creationTime":0,"keyValues":[{"dataType":"STRING","keyName":"country","keyType":"PARTITION","stringValue":"usa"},{"dataType":"STRING","keyName":"domain","keyType":"PROPERTY","stringValue":"us"},{"dataType":"INT","intValue":1,"keyName":"date","keyType":"PROPERTY"},{"dataType":"STRING","keyName":"climate","keyType":"PROPERTY","stringValue":"windy"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","schema":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"f1","type":"INT"},{"columnNumber":1,"name":"f2","type":"INT"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"storageLocation":"http7"}
+{"creationTime":0,"keyValues":[{"dataType":"STRING","keyName":"country","keyType":"PARTITION","stringValue":"india"},{"dataType":"STRING","keyName":"domain","keyType":"PROPERTY","stringValue":"asia"},{"dataType":"INT","intValue":10,"keyName":"date","keyType":"PROPERTY"},{"dataType":"STRING","keyName":"climate","keyType":"PROPERTY","stringValue":"sunny"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","schema":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"f1","type":"INT"},{"columnNumber":1,"name":"f2","type":"INT"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"storageLocation":"http8"}
+{"creationTime":0,"keyValues":[{"dataType":"STRING","keyName":"country","keyType":"PARTITION","stringValue":"london"},{"dataType":"STRING","keyName":"domain","keyType":"PROPERTY","stringValue":"uk"},{"dataType":"INT","intValue":11,"keyName":"date","keyType":"PROPERTY"},{"dataType":"STRING","keyName":"climate","keyType":"PROPERTY","stringValue":"rainy"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","schema":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"f1","type":"INT"},{"columnNumber":1,"name":"f2","type":"INT"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"storageLocation":"http9"}
+<COMMAND> select dataelement objects from owltable testOwlTable2 within owldatabase testOwldatabase with partition ( country LIKE "%a%") property ( climate LIKE "%%")
+<RESULT> OwlDataElement 2
+{"creationTime":0,"keyValues":[{"dataType":"STRING","keyName":"country","keyType":"PARTITION","stringValue":"usa"},{"dataType":"STRING","keyName":"domain","keyType":"PROPERTY","stringValue":"us"},{"dataType":"INT","intValue":1,"keyName":"date","keyType":"PROPERTY"},{"dataType":"STRING","keyName":"climate","keyType":"PROPERTY","stringValue":"windy"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","schema":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"f1","type":"INT"},{"columnNumber":1,"name":"f2","type":"INT"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"storageLocation":"http7"}
+{"creationTime":0,"keyValues":[{"dataType":"STRING","keyName":"country","keyType":"PARTITION","stringValue":"india"},{"dataType":"STRING","keyName":"domain","keyType":"PROPERTY","stringValue":"asia"},{"dataType":"INT","intValue":10,"keyName":"date","keyType":"PROPERTY"},{"dataType":"STRING","keyName":"climate","keyType":"PROPERTY","stringValue":"sunny"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","schema":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"f1","type":"INT"},{"columnNumber":1,"name":"f2","type":"INT"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"storageLocation":"http8"}
+<COMMAND> select dataelement objects from owltable testOwlTable2 within owldatabase testOwldatabase with partition ( country = "%a%") property ( climate LIKE "%%")
+<SUCCESS>
+<COMMAND> select partitionproperty objects from owltable testOwlTable within owldatabase testOwldatabase with partition ( year = 2009 )
+<RESULT> OwlPartitionProperty 1
+{"keyValues":[{"dataType":"INT","intValue":8,"keyName":"month","keyType":"PROPERTY"},{"dataType":"INT","intValue":1,"keyName":"retention","keyType":"PROPERTY"},{"dataType":"INT","intValue":1,"keyName":"date","keyType":"PROPERTY"}]}
+<COMMAND> select partitionproperty objects from owltable testOwlTable within owldatabase testOwldatabase with partition ( year < 2009 )
+<RESULT> OwlPartitionProperty 1
+{"keyValues":[{"dataType":"INT","intValue":7,"keyName":"month","keyType":"PROPERTY"},{"dataType":"INT","intValue":0,"keyName":"retention","keyType":"PROPERTY"},{"dataType":"INT","intValue":0,"keyName":"date","keyType":"PROPERTY"}]}
+<COMMAND> select partitionproperty objects from owltable testOwlTable within owldatabase testOwldatabase with partition ( year > 2009 )
+<RESULT> OwlPartitionProperty 1
+{"keyValues":[{"dataType":"INT","intValue":9,"keyName":"month","keyType":"PROPERTY"},{"dataType":"INT","intValue":2,"keyName":"retention","keyType":"PROPERTY"},{"dataType":"INT","intValue":2,"keyName":"date","keyType":"PROPERTY"}]}
+<COMMAND> select partitionproperty objects from owltable testOwlTable within owldatabase testOwldatabase with partition ( year > 2011 )
+<SUCCESS>
+<COMMAND> select partitionproperty objects from owltable testOwlTable within owldatabase testOwldatabase with partition ( year < 2007 )
+<SUCCESS>
+<COMMAND> select partitionproperty objects from owltable testOwlTable1 within owldatabase testOwldatabase with partition ( year = 2009 )
+<RESULT> OwlPartitionProperty 1
+{"keyValues":[{"dataType":"INT","intValue":8,"keyName":"month","keyType":"PROPERTY"},{"dataType":"INT","intValue":1,"keyName":"retention","keyType":"PROPERTY"},{"dataType":"INT","intValue":1,"keyName":"date","keyType":"PROPERTY"}]}
+<COMMAND> select partitionproperty objects from owltable testOwlTable1 within owldatabase testOwldatabase with partition ( year < 2009 )
+<SUCCESS>
+<COMMAND> select partitionproperty objects from owltable testOwlTable1 within owldatabase testOwldatabase with partition ( year > 2009 )
+<RESULT> OwlPartitionProperty 1
+{"keyValues":[{"dataType":"INT","intValue":9,"keyName":"month","keyType":"PROPERTY"},{"dataType":"INT","intValue":2,"keyName":"retention","keyType":"PROPERTY"},{"dataType":"INT","intValue":2,"keyName":"date","keyType":"PROPERTY"}]}
+<COMMAND> select partitionproperty objects from owltable testOwlTable1 within owldatabase testOwldatabase with partition ( year > 2011 )
+<SUCCESS>
+<COMMAND> select partitionproperty objects from owltable testOwlTable1 within owldatabase testOwldatabase with partition ( year < 2007 )
+<SUCCESS>
+<COMMAND> select partitionproperty objects from owltable testOwlTable2 within owldatabase testOwldatabase with partition ( country LIKE "%us%" )
+<RESULT> OwlPartitionProperty 1
+{"keyValues":[{"dataType":"STRING","keyName":"domain","keyType":"PROPERTY","stringValue":"us"},{"dataType":"INT","intValue":1,"keyName":"date","keyType":"PROPERTY"},{"dataType":"STRING","keyName":"climate","keyType":"PROPERTY","stringValue":"windy"}]}
+<COMMAND> select partitionproperty objects from owltable testOwlTable2 within owldatabase testOwldatabase with partition ( country = "%a%" )
+<SUCCESS>
+<COMMAND> select dataelement objects from owltable testOwlTable2 within owldatabase testOwldatabase with partition ( country < "india" )
+<SUCCESS>
+<COMMAND> select dataelement objects from owltable testOwlTable2 within owldatabase testOwldatabase with partition ( country <= "india" )
+<RESULT> OwlDataElement 1
+{"creationTime":0,"keyValues":[{"dataType":"STRING","keyName":"country","keyType":"PARTITION","stringValue":"india"},{"dataType":"STRING","keyName":"domain","keyType":"PROPERTY","stringValue":"asia"},{"dataType":"INT","intValue":10,"keyName":"date","keyType":"PROPERTY"},{"dataType":"STRING","keyName":"climate","keyType":"PROPERTY","stringValue":"sunny"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","schema":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"f1","type":"INT"},{"columnNumber":1,"name":"f2","type":"INT"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"storageLocation":"http8"}
+<COMMAND> select dataelement objects from owltable testOwlTable2 within owldatabase testOwldatabase with partition ( country > "india" )
+<RESULT> OwlDataElement 2
+{"creationTime":0,"keyValues":[{"dataType":"STRING","keyName":"country","keyType":"PARTITION","stringValue":"usa"},{"dataType":"STRING","keyName":"domain","keyType":"PROPERTY","stringValue":"us"},{"dataType":"INT","intValue":1,"keyName":"date","keyType":"PROPERTY"},{"dataType":"STRING","keyName":"climate","keyType":"PROPERTY","stringValue":"windy"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","schema":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"f1","type":"INT"},{"columnNumber":1,"name":"f2","type":"INT"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"storageLocation":"http7"}
+{"creationTime":0,"keyValues":[{"dataType":"STRING","keyName":"country","keyType":"PARTITION","stringValue":"london"},{"dataType":"STRING","keyName":"domain","keyType":"PROPERTY","stringValue":"uk"},{"dataType":"INT","intValue":11,"keyName":"date","keyType":"PROPERTY"},{"dataType":"STRING","keyName":"climate","keyType":"PROPERTY","stringValue":"rainy"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","schema":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"f1","type":"INT"},{"columnNumber":1,"name":"f2","type":"INT"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"storageLocation":"http9"}
+<COMMAND> select dataelement objects from owltable testOwlTable2 within owldatabase testOwldatabase with partition ( country >= "india" )
+<RESULT> OwlDataElement 3
+{"creationTime":0,"keyValues":[{"dataType":"STRING","keyName":"country","keyType":"PARTITION","stringValue":"usa"},{"dataType":"STRING","keyName":"domain","keyType":"PROPERTY","stringValue":"us"},{"dataType":"INT","intValue":1,"keyName":"date","keyType":"PROPERTY"},{"dataType":"STRING","keyName":"climate","keyType":"PROPERTY","stringValue":"windy"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","schema":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"f1","type":"INT"},{"columnNumber":1,"name":"f2","type":"INT"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"storageLocation":"http7"}
+{"creationTime":0,"keyValues":[{"dataType":"STRING","keyName":"country","keyType":"PARTITION","stringValue":"india"},{"dataType":"STRING","keyName":"domain","keyType":"PROPERTY","stringValue":"asia"},{"dataType":"INT","intValue":10,"keyName":"date","keyType":"PROPERTY"},{"dataType":"STRING","keyName":"climate","keyType":"PROPERTY","stringValue":"sunny"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","schema":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"f1","type":"INT"},{"columnNumber":1,"name":"f2","type":"INT"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"storageLocation":"http8"}
+{"creationTime":0,"keyValues":[{"dataType":"STRING","keyName":"country","keyType":"PARTITION","stringValue":"london"},{"dataType":"STRING","keyName":"domain","keyType":"PROPERTY","stringValue":"uk"},{"dataType":"INT","intValue":11,"keyName":"date","keyType":"PROPERTY"},{"dataType":"STRING","keyName":"climate","keyType":"PROPERTY","stringValue":"rainy"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","schema":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"f1","type":"INT"},{"columnNumber":1,"name":"f2","type":"INT"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"storageLocation":"http9"}
+<COMMAND> drop owltable testOwlTable within owldatabase testOwldatabase
+<SUCCESS>
+<COMMAND> drop owltable testOwlTable1 within owldatabase testOwldatabase
+<SUCCESS>
+<COMMAND> drop owltable testOwlTable2 within owldatabase testOwldatabase
+<SUCCESS>
+<COMMAND> drop owldatabase testOwldatabase
+<SUCCESS>
Added: hadoop/pig/trunk/contrib/owl/ci/test_results/operator_Multiple_Partition_Test.exp
URL: http://svn.apache.org/viewvc/hadoop/pig/trunk/contrib/owl/ci/test_results/operator_Multiple_Partition_Test.exp?rev=934649&view=auto
==============================================================================
--- hadoop/pig/trunk/contrib/owl/ci/test_results/operator_Multiple_Partition_Test.exp (added)
+++ hadoop/pig/trunk/contrib/owl/ci/test_results/operator_Multiple_Partition_Test.exp Thu Apr 15 23:56:44 2010
@@ -0,0 +1,48 @@
+<COMMAND> drop owltable testOwlTable within owlDatabase testOwlDatabase
+<IGNORE>
+<COMMAND> drop owltable testOwlTable1 within owlDatabase testOwlDatabase
+<IGNORE>
+<COMMAND> drop owltable testOwlTable2 within owlDatabase testOwlDatabase
+<IGNORE>
+<COMMAND> drop owlDatabase testOwlDatabase
+<IGNORE>
+<COMMAND> create owlDatabase testOwlDatabase identified by storage directory "hdfs://namenode:8080/data/testowlDatabase"
+<SUCCESS>
+<COMMAND> select owlDatabase objects where owlDatabase in (testOwlDatabase)
+<RESULT> OwlDatabase 1
+{"creationTime":0,"modificationTime":0,"name":"testOwlDatabase","storageLocation":"hdfs://namenode:8080/data/testowlDatabase"}
+<COMMAND> create owltable type basic testOwlTable within owlDatabase testOwlDatabase define property key retention:INTEGER partitioned by LIST with partition key year:INTEGER define property key month:INTEGER, date:INTEGER partitioned by INTERVAL ("2009-11-09 18:00:00 PDT", 15 Minutes) with partition key datest partitioned by LIST with partition key part2 : STRING
+<SUCCESS>
+<COMMAND> publish dataelement to owltable testOwlTable within owlDatabase testOwlDatabase partition (year = 2009, datest = "2009-11-09 18:00:00 PDT", part2 = "three") property (retention = 1, month = 8, date = 1) schema "c1:collection(f1:int, f2:int)" delocation "http"
+<SUCCESS>
+<COMMAND> select dataelement objects from owltable testOwlTable within owlDatabase testOwlDatabase with partition ( year >= 2009, datest > "2009-11-09 18:00:00 PDT", part2 = "three") property ( month >= 8, date >= 1)
+<RESULT> OwlDataElement 1
+{"creationTime":0,"keyValues":[{"dataType":"STRING","keyName":"part2","keyType":"PARTITION","stringValue":"three"},{"dataType":"LONG","keyName":"datest","keyType":"PARTITION","longValue":1257814800000},{"dataType":"INT","intValue":2009,"keyName":"year","keyType":"PARTITION"},{"dataType":"INT","intValue":8,"keyName":"month","keyType":"PROPERTY"},{"dataType":"INT","intValue":1,"keyName":"date","keyType":"PROPERTY"}],"loader":{},"modificationTime":0,"storageLocation":"http"}
+<COMMAND> select dataelement objects from owltable testOwlTable within owlDatabase testOwlDatabase with partition ( year <= 2009, datest <= "2009-11-09 18:00:00 PDT", part2 = "three") property ( month >= 8, date >= 1)
+<RESULT> OwlDataElement 1
+{"creationTime":0,"keyValues":[{"dataType":"STRING","keyName":"part2","keyType":"PARTITION","stringValue":"three"},{"dataType":"LONG","keyName":"datest","keyType":"PARTITION","longValue":1257814800000},{"dataType":"INT","intValue":2009,"keyName":"year","keyType":"PARTITION"},{"dataType":"INT","intValue":8,"keyName":"month","keyType":"PROPERTY"},{"dataType":"INT","intValue":1,"keyName":"date","keyType":"PROPERTY"}],"loader":{},"modificationTime":0,"storageLocation":"http"}
+<COMMAND> select dataelement objects from owltable testOwlTable within owlDatabase testOwlDatabase with partition ( year <= 2009, datest >= "2009-11-09 18:00:00 PDT", part2 = "three") property ( month >= 8, date >= 1)
+<RESULT> OwlDataElement 1
+{"creationTime":0,"keyValues":[{"dataType":"STRING","keyName":"part2","keyType":"PARTITION","stringValue":"three"},{"dataType":"LONG","keyName":"datest","keyType":"PARTITION","longValue":1257814800000},{"dataType":"INT","intValue":2009,"keyName":"year","keyType":"PARTITION"},{"dataType":"INT","intValue":8,"keyName":"month","keyType":"PROPERTY"},{"dataType":"INT","intValue":1,"keyName":"date","keyType":"PROPERTY"}],"loader":{},"modificationTime":0,"storageLocation":"http"}
+<COMMAND> select dataelement objects from owltable testOwlTable within owlDatabase testOwlDatabase with partition ( year <= 2009, datest >= "2009-11-09 18:00:00 PDT", part2 LIKE "%t%") property ( month >= 8, date >= 1)
+<RESULT> OwlDataElement 1
+{"creationTime":0,"keyValues":[{"dataType":"STRING","keyName":"part2","keyType":"PARTITION","stringValue":"three"},{"dataType":"LONG","keyName":"datest","keyType":"PARTITION","longValue":1257814800000},{"dataType":"INT","intValue":2009,"keyName":"year","keyType":"PARTITION"},{"dataType":"INT","intValue":8,"keyName":"month","keyType":"PROPERTY"},{"dataType":"INT","intValue":1,"keyName":"date","keyType":"PROPERTY"}],"loader":{},"modificationTime":0,"storageLocation":"http"}
+<COMMAND> select dataelement objects from owltable testOwlTable within owlDatabase testOwlDatabase with partition ( year <= 2009, datest >= "2009-11-09 18:00:00 PDT", part2 LIKE "%g%") property ( month >= 8, date >= 1)
+<SUCCESS>
+<COMMAND> select dataelement objects from owltable testOwlTable within owlDatabase testOwlDatabase with partition ( year > 2009, datest < "2009-11-09 18:00:00 PDT", part2 = "three") property ( month >= 8, date >= 1)
+<SUCCESS>
+<COMMAND> select dataelement objects from owltable testOwlTable within owlDatabase testOwlDatabase with partition ( year < 2009, datest < "2009-11-09 18:00:00 PDT", part2 = "three") property ( month >= 8, date >= 1)
+<SUCCESS>
+<COMMAND> select dataelement objects from owltable testOwlTable within owlDatabase testOwlDatabase with partition ( year >= 2007, datest > "2009-11-09 18:00:00 PDT", part2 = "three") property ( month >= 8, date >= 1)
+<RESULT> OwlDataElement 1
+{"creationTime":0,"keyValues":[{"dataType":"STRING","keyName":"part2","keyType":"PARTITION","stringValue":"three"},{"dataType":"LONG","keyName":"datest","keyType":"PARTITION","longValue":1257814800000},{"dataType":"INT","intValue":2009,"keyName":"year","keyType":"PARTITION"},{"dataType":"INT","intValue":8,"keyName":"month","keyType":"PROPERTY"},{"dataType":"INT","intValue":1,"keyName":"date","keyType":"PROPERTY"}],"loader":{},"modificationTime":0,"storageLocation":"http"}
+<COMMAND> select dataelement objects from owltable testOwlTable within owlDatabase testOwlDatabase with partition ( year <= 2007, datest > "2009-11-09 18:00:00 PDT", part2 = "three") property ( month >= 8, date >= 1)
+<SUCCESS>
+<COMMAND> drop owltable testOwlTable within owlDatabase testOwlDatabase
+<SUCCESS>
+<COMMAND> drop owltable testOwlTable1 within owlDatabase testOwlDatabase
+<SUCCESS>
+<COMMAND> drop owltable testOwlTable2 within owlDatabase testOwlDatabase
+<SUCCESS>
+<COMMAND> drop owlDatabase testOwlDatabase
+<SUCCESS>
Added: hadoop/pig/trunk/contrib/owl/ci/test_results/propertyKey.exp
URL: http://svn.apache.org/viewvc/hadoop/pig/trunk/contrib/owl/ci/test_results/propertyKey.exp?rev=934649&view=auto
==============================================================================
--- hadoop/pig/trunk/contrib/owl/ci/test_results/propertyKey.exp (added)
+++ hadoop/pig/trunk/contrib/owl/ci/test_results/propertyKey.exp Thu Apr 15 23:56:44 2010
@@ -0,0 +1,50 @@
+<COMMAND> drop owltable testkeys within owldatabase testkeyowldatabase
+<IGNORE>
+<COMMAND> drop owltable testkeys2 within owldatabase testkeyowldatabase
+<IGNORE>
+<COMMAND> drop owldatabase testkeyowldatabase
+<IGNORE>
+<COMMAND> create owldatabase testkeyowldatabase identified by storage directory "http://namenode:8080/data/testkeyowldatabase"
+<SUCCESS>
+<COMMAND> create owltable type basic testkeys within owldatabase testkeyowldatabase define property key prkot : INTEGER partitioned by LIST with partition key part1 : INTEGER define property key prk1 : INTEGER partitioned by LIST with partition key part2 : INTEGER define property key prk2 : INTEGER partitioned by LIST with partition key part3 : INTEGER define property key prk3 : INTEGER schema "test1:int"
+<SUCCESS>
+<COMMAND> create owltable type basic testkeys2 within owldatabase testkeyowldatabase partitioned by LIST with partition key part1 : STRING schema "test1:int"
+<SUCCESS>
+<COMMAND> publish dataelement to owltable testkeys within owldatabase testkeyowldatabase partition (part1 = 1, part2 = 2, part3 = 3) property (prk1 = 11, prk2 = 22, prk3 = 33) schema "c1:int" delocation "testloc1"
+<SUCCESS>
+<COMMAND> publish dataelement to owltable testkeys within owldatabase testkeyowldatabase partition (part1 = 101, part2 = 2, part3 = 3) property (prk1 = 11, prk2 = 22, prk3 = 33) schema "c1:int" delocation "testloc2"
+<SUCCESS>
+<COMMAND> publish dataelement to owltable testkeys2 within owldatabase testkeyowldatabase partition (part1 = "abc1") schema "c1:int" delocation "key2loc1"
+<SUCCESS>
+<COMMAND> publish dataelement to owltable testkeys2 within owldatabase testkeyowldatabase partition (part1 = "2abc2") schema "c1:int" delocation "key2loc2"
+<SUCCESS>
+<COMMAND> publish dataelement to owltable testkeys2 within owldatabase testkeyowldatabase partition (part1 = "3abc") schema "c1:int" delocation "key2loc3"
+<SUCCESS>
+<COMMAND> publish dataelement to owltable testkeys2 within owldatabase testkeyowldatabase partition (part1 = "def") schema "c1:int" delocation "key2loc4"
+<SUCCESS>
+<COMMAND> select partitionproperty objects from owltable testkeys within owldatabase testkeyowldatabase with partition ( part1 = 1 )
+<RESULT> OwlPartitionProperty 1
+{"keyValues":[]}
+<COMMAND> select partitionproperty objects from owltable testkeys within owldatabase testkeyowldatabase with partition ( part1 = 1, part2=2 )
+<RESULT> OwlPartitionProperty 1
+{"keyValues":[]}
+<COMMAND> select partitionproperty objects from owltable testkeys within owldatabase testkeyowldatabase with partition ( part1 = 1, part2=2, part3=3 )
+<RESULT> OwlPartitionProperty 1
+{"keyValues":[{"dataType":"INT","intValue":11,"keyName":"prk1","keyType":"PROPERTY"},{"dataType":"INT","intValue":22,"keyName":"prk2","keyType":"PROPERTY"},{"dataType":"INT","intValue":33,"keyName":"prk3","keyType":"PROPERTY"}]}
+<COMMAND> select dataelement objects from owltable testkeys within owldatabase testkeyowldatabase with partition ( part1 = 1 ) property ( prk2=22 )
+<RESULT> OwlDataElement 1
+{"creationTime":0,"keyValues":[{"dataType":"INT","intValue":3,"keyName":"part3","keyType":"PARTITION"},{"dataType":"INT","intValue":11,"keyName":"prk1","keyType":"PROPERTY"},{"dataType":"INT","intValue":22,"keyName":"prk2","keyType":"PROPERTY"},{"dataType":"INT","intValue":33,"keyName":"prk3","keyType":"PROPERTY"},{"dataType":"INT","intValue":2,"keyName":"part2","keyType":"PARTITION"},{"dataType":"INT","intValue":1,"keyName":"part1","keyType":"PARTITION"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","type":"INT"}]},"storageLocation":"testloc1"}
+<COMMAND> select dataelement objects from owltable testkeys2 within owldatabase testkeyowldatabase with partition ( part1 like "%abc%" )
+<RESULT> OwlDataElement 3
+{"creationTime":0,"keyValues":[{"dataType":"STRING","keyName":"part1","keyType":"PARTITION","stringValue":"abc1"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","type":"INT"}]},"storageLocation":"key2loc1"}
+{"creationTime":0,"keyValues":[{"dataType":"STRING","keyName":"part1","keyType":"PARTITION","stringValue":"2abc2"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","type":"INT"}]},"storageLocation":"key2loc2"}
+{"creationTime":0,"keyValues":[{"dataType":"STRING","keyName":"part1","keyType":"PARTITION","stringValue":"3abc"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","type":"INT"}]},"storageLocation":"key2loc3"}
+<COMMAND> select dataelement objects from owltable testkeys2 within owldatabase testkeyowldatabase with partition ( part1 like "%def%" )
+<RESULT> OwlDataElement 1
+{"creationTime":0,"keyValues":[{"dataType":"STRING","keyName":"part1","keyType":"PARTITION","stringValue":"def"}],"loader":{},"modificationTime":0,"owlSchema":{"columnSchema":[{"columnNumber":0,"name":"c1","type":"INT"}]},"storageLocation":"key2loc4"}
+<COMMAND> drop owltable testkeys within owldatabase testkeyowldatabase
+<SUCCESS>
+<COMMAND> drop owltable testkeys2 within owldatabase testkeyowldatabase
+<SUCCESS>
+<COMMAND> drop owldatabase testkeyowldatabase
+<SUCCESS>
Added: hadoop/pig/trunk/contrib/owl/ci/test_results/schemaAlter.exp
URL: http://svn.apache.org/viewvc/hadoop/pig/trunk/contrib/owl/ci/test_results/schemaAlter.exp?rev=934649&view=auto
==============================================================================
--- hadoop/pig/trunk/contrib/owl/ci/test_results/schemaAlter.exp (added)
+++ hadoop/pig/trunk/contrib/owl/ci/test_results/schemaAlter.exp Thu Apr 15 23:56:44 2010
@@ -0,0 +1,55 @@
+<COMMAND> drop owltable testschema1 within owldatabase testSchemaAlterDB
+<IGNORE>
+<COMMAND> drop owltable testschema2 within owldatabase testSchemaAlterDB
+<IGNORE>
+<COMMAND> drop owldatabase testSchemaAlterDB
+<IGNORE>
+<COMMAND> create owldatabase testSchemaAlterDB identified by storage directory "http://namenode:8080/data/testSchemaAlterDBdir"
+<SUCCESS>
+<COMMAND> create owltable type basic testschema1 within owldatabase testSchemaAlterDB schema "test1:int"
+<SUCCESS>
+<COMMAND> create owltable type basic testschema2 within owldatabase testSchemaAlterDB partitioned by LIST with partition key year:INTEGER partitioned by LIST with partition key month:INTEGER schema "c1:int,c2:record(c22:collection(c222:record(c2222:bool)))"
+<SUCCESS>
+<COMMAND> publish dataelement to owltable testschema1 within owldatabase testSchemaAlterDB schema "c1:int" delocation "testloc1nopart"
+<SUCCESS>
+<COMMAND> describe owltable testschema1 within owldatabase testSchemaAlterDB
+<RESULT> OwlTable 1
+{"creationTime":0,"modificationTime":0,"name":{"databaseName":"testschemaalterdb","tableName":"testschema1"},"partitionKeys":[],"propertyKeys":[],"propertyValues":[],"schema":{"columnSchema":[{"columnNumber":0,"name":"test1","type":"INT"},{"columnNumber":1,"name":"c1","type":"INT"}]}}
+<COMMAND> alter owltable testschema1 within owldatabase testSchemaAlterDB set schema "test2:int"
+<SUCCESS>
+<COMMAND> describe owltable testschema1 within owldatabase testSchemaAlterDB
+<RESULT> OwlTable 1
+{"creationTime":0,"modificationTime":0,"name":{"databaseName":"testschemaalterdb","tableName":"testschema1"},"partitionKeys":[],"propertyKeys":[],"propertyValues":[],"schema":{"columnSchema":[{"columnNumber":0,"name":"test2","type":"INT"}]}}
+<COMMAND> select partition objects from owltable testschema1 within owldatabase testSchemaAlterDB
+<RESULT> OwlPartition 1
+{"creationTime":0,"keyValues":[],"leaf":true,"loader":{},"modificationTime":0,"partitionLevel":0,"schema":{"columnSchema":[{"columnNumber":0,"name":"c1","type":"INT"}]},"storageLocation":"testloc1nopart"}
+<COMMAND> publish dataelement to owltable testschema2 within owlDatabase testSchemaAlterDB partition (year = 2009, month = 1) schema "x1:int,c2:record(c22:collection(c222:record(c2222:bool)))" delocation "testloc1"
+<SUCCESS>
+<COMMAND> publish dataelement to owltable testschema2 within owlDatabase testSchemaAlterDB partition (year = 2009, month = 2) schema "y1:int,c2:record(c22:collection(c222:record(c2222:bool)))" delocation "testloc2"
+<SUCCESS>
+<COMMAND> alter owltable testschema2 within owldatabase testSchemaAlterDB set schema "c2:record(c22:collection(c222:record(c2222:bool))),c1:int,y1:int"
+<SUCCESS>
+<COMMAND> describe owltable testschema2 within owldatabase testSchemaAlterDB
+<RESULT> OwlTable 1
+{"creationTime":0,"modificationTime":0,"name":{"databaseName":"testschemaalterdb","tableName":"testschema2"},"partitionKeys":[{"dataType":"INT","level":1,"listValues":[],"name":"year","partitioningType":"LIST"},{"dataType":"INT","level":2,"listValues":[],"name":"month","partitioningType":"LIST"}],"propertyKeys":[],"propertyValues":[],"schema":{"columnSchema":[{"columnNumber":0,"name":"year","type":"INT"},{"columnNumber":1,"name":"month","type":"INT"},{"columnNumber":2,"name":"c2","schema":{"columnSchema":[{"columnNumber":0,"name":"c22","schema":{"columnSchema":[{"columnNumber":0,"name":"c222","schema":{"columnSchema":[{"columnNumber":0,"name":"c2222","type":"BOOL"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"type":"RECORD"},{"columnNumber":3,"name":"c1","type":"INT"},{"columnNumber":4,"name":"y1","type":"INT"}]}}
+<COMMAND> publish dataelement to owltable testschema2 within owlDatabase testSchemaAlterDB partition (year = 2009, month = 3) schema "z1:int" delocation "testloc3"
+<SUCCESS>
+<COMMAND> describe owltable testschema2 within owldatabase testSchemaAlterDB
+<RESULT> OwlTable 1
+{"creationTime":0,"modificationTime":0,"name":{"databaseName":"testschemaalterdb","tableName":"testschema2"},"partitionKeys":[{"dataType":"INT","level":1,"listValues":[],"name":"year","partitioningType":"LIST"},{"dataType":"INT","level":2,"listValues":[],"name":"month","partitioningType":"LIST"}],"propertyKeys":[],"propertyValues":[],"schema":{"columnSchema":[{"columnNumber":0,"name":"year","type":"INT"},{"columnNumber":1,"name":"month","type":"INT"},{"columnNumber":2,"name":"c2","schema":{"columnSchema":[{"columnNumber":0,"name":"c22","schema":{"columnSchema":[{"columnNumber":0,"name":"c222","schema":{"columnSchema":[{"columnNumber":0,"name":"c2222","type":"BOOL"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"type":"RECORD"},{"columnNumber":3,"name":"c1","type":"INT"},{"columnNumber":4,"name":"y1","type":"INT"},{"columnNumber":5,"name":"z1","type":"INT"}]}}
+<COMMAND> alter owltable testschema2 within owldatabase testSchemaAlterDB set schema "y1:int,year:int,month:int,c1:int"
+<SUCCESS>
+<COMMAND> describe owltable testschema2 within owldatabase testSchemaAlterDB
+<RESULT> OwlTable 1
+{"creationTime":0,"modificationTime":0,"name":{"databaseName":"testschemaalterdb","tableName":"testschema2"},"partitionKeys":[{"dataType":"INT","level":1,"listValues":[],"name":"year","partitioningType":"LIST"},{"dataType":"INT","level":2,"listValues":[],"name":"month","partitioningType":"LIST"}],"propertyKeys":[],"propertyValues":[],"schema":{"columnSchema":[{"columnNumber":0,"name":"y1","type":"INT"},{"columnNumber":1,"name":"year","type":"INT"},{"columnNumber":2,"name":"month","type":"INT"},{"columnNumber":3,"name":"c1","type":"INT"}]}}
+<COMMAND> select partition objects from owltable testschema2 within owldatabase testSchemaAlterDB
+<RESULT> OwlPartition 3
+{"creationTime":0,"keyValues":[{"dataType":"INT","intValue":1,"keyName":"month","keyType":"PARTITION"},{"dataType":"INT","intValue":2009,"keyName":"year","keyType":"PARTITION"}],"leaf":true,"loader":{},"modificationTime":0,"partitionLevel":2,"schema":{"columnSchema":[{"columnNumber":0,"name":"x1","type":"INT"},{"columnNumber":1,"name":"c2","schema":{"columnSchema":[{"columnNumber":0,"name":"c22","schema":{"columnSchema":[{"columnNumber":0,"name":"c222","schema":{"columnSchema":[{"columnNumber":0,"name":"c2222","type":"BOOL"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"type":"RECORD"}]},"storageLocation":"testloc1"}
+{"creationTime":0,"keyValues":[{"dataType":"INT","intValue":2,"keyName":"month","keyType":"PARTITION"},{"dataType":"INT","intValue":2009,"keyName":"year","keyType":"PARTITION"}],"leaf":true,"loader":{},"modificationTime":0,"partitionLevel":2,"schema":{"columnSchema":[{"columnNumber":0,"name":"y1","type":"INT"},{"columnNumber":1,"name":"c2","schema":{"columnSchema":[{"columnNumber":0,"name":"c22","schema":{"columnSchema":[{"columnNumber":0,"name":"c222","schema":{"columnSchema":[{"columnNumber":0,"name":"c2222","type":"BOOL"}]},"type":"RECORD"}]},"type":"COLLECTION"}]},"type":"RECORD"}]},"storageLocation":"testloc2"}
+{"creationTime":0,"keyValues":[{"dataType":"INT","intValue":3,"keyName":"month","keyType":"PARTITION"},{"dataType":"INT","intValue":2009,"keyName":"year","keyType":"PARTITION"}],"leaf":true,"loader":{},"modificationTime":0,"partitionLevel":2,"schema":{"columnSchema":[{"columnNumber":0,"name":"z1","type":"INT"}]},"storageLocation":"testloc3"}
+<COMMAND> drop owltable testschema1 within owldatabase testSchemaAlterDB
+<SUCCESS>
+<COMMAND> drop owltable testschema2 within owldatabase testSchemaAlterDB
+<SUCCESS>
+<COMMAND> drop owldatabase testSchemaAlterDB
+<SUCCESS>
Added: hadoop/pig/trunk/contrib/owl/ci/test_results/schemaEvolution.exp
URL: http://svn.apache.org/viewvc/hadoop/pig/trunk/contrib/owl/ci/test_results/schemaEvolution.exp?rev=934649&view=auto
==============================================================================
--- hadoop/pig/trunk/contrib/owl/ci/test_results/schemaEvolution.exp (added)
+++ hadoop/pig/trunk/contrib/owl/ci/test_results/schemaEvolution.exp Thu Apr 15 23:56:44 2010
@@ -0,0 +1,47 @@
+<COMMAND> drop owltable testSchemaEvolutionTable within owldatabase testSchemaEvolutionDB
+<IGNORE>
+<COMMAND> drop owltable testComplexSchema within owldatabase testSchemaEvolutionDB
+<IGNORE>
+<COMMAND> drop owldatabase testSchemaEvolutionDB
+<IGNORE>
+<COMMAND> create owldatabase testSchemaEvolutionDB identified by storage directory "hdfs://localhost:9000/data/testSchemaEvolutionDB"
+<SUCCESS>
+<COMMAND> create owltable type basic testSchemaEvolutionTable within owldatabase testSchemaEvolutionDB partitioned by LIST with partition key c1 : INTEGER schema "c1:int,c2:string"
+<SUCCESS>
+<COMMAND> publish dataelement to owltable testSchemaEvolutionTable within owldatabase testSchemaEvolutionDB partition (c1 = 2008 ) schema "c1:int,c2:string,c3:int" delocation "testSchemaEvolutionTable/partition1" loader "testloader"
+<SUCCESS>
+<COMMAND> describe owltable testSchemaEvolutionTable within owldatabase testSchemaEvolutionDB
+<RESULT> OwlTable 1
+{"creationTime":0,"modificationTime":0,"name":{"databaseName":"testschemaevolutiondb","tableName":"testschemaevolutiontable"},"partitionKeys":[{"dataType":"INT","level":1,"listValues":[],"name":"c1","partitioningType":"LIST"}],"propertyKeys":[],"propertyValues":[],"schema":{"columnSchema":[{"columnNumber":0,"name":"c1","type":"INT"},{"columnNumber":1,"name":"c2","type":"STRING"},{"columnNumber":2,"name":"c3","type":"INT"}]}}
+<COMMAND> publish dataelement to owltable testSchemaEvolutionTable within owldatabase testSchemaEvolutionDB partition (c1 = 2009 ) schema "c1:int,c2:string,c4:int" delocation "testSchemaEvolutionTable/partition2" loader "testloader"
+<SUCCESS>
+<COMMAND> describe owltable testSchemaEvolutionTable within owldatabase testSchemaEvolutionDB
+<RESULT> OwlTable 1
+{"creationTime":0,"modificationTime":0,"name":{"databaseName":"testschemaevolutiondb","tableName":"testschemaevolutiontable"},"partitionKeys":[{"dataType":"INT","level":1,"listValues":[],"name":"c1","partitioningType":"LIST"}],"propertyKeys":[],"propertyValues":[],"schema":{"columnSchema":[{"columnNumber":0,"name":"c1","type":"INT"},{"columnNumber":1,"name":"c2","type":"STRING"},{"columnNumber":2,"name":"c3","type":"INT"},{"columnNumber":3,"name":"c4","type":"INT"}]}}
+<COMMAND> select partition objects from owltable testSchemaEvolutionTable within owldatabase testSchemaEvolutionDB
+<RESULT> OwlPartition 2
+{"creationTime":0,"keyValues":[{"dataType":"INT","intValue":2008,"keyName":"c1","keyType":"PARTITION"}],"leaf":true,"loader":{"inputDriverClass":"testloader"},"modificationTime":0,"partitionLevel":1,"schema":{"columnSchema":[{"columnNumber":0,"name":"c1","type":"INT"},{"columnNumber":1,"name":"c2","type":"STRING"},{"columnNumber":2,"name":"c3","type":"INT"}]},"storageLocation":"testSchemaEvolutionTable/partition1"}
+{"creationTime":0,"keyValues":[{"dataType":"INT","intValue":2009,"keyName":"c1","keyType":"PARTITION"}],"leaf":true,"loader":{"inputDriverClass":"testloader"},"modificationTime":0,"partitionLevel":1,"schema":{"columnSchema":[{"columnNumber":0,"name":"c1","type":"INT"},{"columnNumber":1,"name":"c2","type":"STRING"},{"columnNumber":2,"name":"c4","type":"INT"}]},"storageLocation":"testSchemaEvolutionTable/partition2"}
+<COMMAND> create owltable type basic testComplexSchema within owldatabase testSchemaEvolutionDB partitioned by LIST with partition key c1 : INTEGER schema "c1:int,c2:string,s_bytes:bytes,s_int:int,s_long:long,s_float:float,s_double:double,m_1:map,m_2:map,m_3:map,ml_1:collection(r1:record(m:map)),ml_2:collection(r2:record(m:map)),ml_3:collection(r3:record(m:map))"
+<SUCCESS>
+<COMMAND> describe owltable testComplexSchema within owldatabase testSchemaEvolutionDB
+<RESULT> OwlTable 1
+{"creationTime":0,"modificationTime":0,"name":{"databaseName":"testschemaevolutiondb","tableName":"testcomplexschema"},"partitionKeys":[{"dataType":"INT","level":1,"listValues":[],"name":"c1","partitioningType":"LIST"}],"propertyKeys":[],"propertyValues":[],"schema":{"columnSchema":[{"columnNumber":0,"name":"c1","type":"INT"},{"columnNumber":1,"name":"c2","type":"STRING"},{"columnNumber":2,"name":"s_bytes","type":"BYTES"},{"columnNumber":3,"name":"s_int","type":"INT"},{"columnNumber":4,"name":"s_long","type":"LONG"},{"columnNumber":5,"name":"s_float","type":"FLOAT"},{"columnNumber":6,"name":"s_double","type":"DOUBLE"},{"columnNumber":7,"name":"m_1","schema":{"columnSchema":[{"columnNumber":0,"name":"","type":"STRING"}]},"type":"MAP"},{"columnNumber":8,"name":"m_2","schema":{"columnSchema":[{"columnNumber":0,"name":"","type":"STRING"}]},"type":"MAP"},{"columnNumber":9,"name":"m_3","schema":{"columnSchema":[{"columnNumber":0,"name":"","type":"STRING"}]},"type":"MAP"},{"columnN
umber":10,"name":"ml_1","schema":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"m","schema":{"columnSchema":[{"columnNumber":0,"name":"","type":"STRING"}]},"type":"MAP"}]},"type":"RECORD"}]},"type":"COLLECTION"},{"columnNumber":11,"name":"ml_2","schema":{"columnSchema":[{"columnNumber":0,"name":"r2","schema":{"columnSchema":[{"columnNumber":0,"name":"m","schema":{"columnSchema":[{"columnNumber":0,"name":"","type":"STRING"}]},"type":"MAP"}]},"type":"RECORD"}]},"type":"COLLECTION"},{"columnNumber":12,"name":"ml_3","schema":{"columnSchema":[{"columnNumber":0,"name":"r3","schema":{"columnSchema":[{"columnNumber":0,"name":"m","schema":{"columnSchema":[{"columnNumber":0,"name":"","type":"STRING"}]},"type":"MAP"}]},"type":"RECORD"}]},"type":"COLLECTION"}]}}
+<COMMAND> publish dataelement to owltable testComplexSchema within owldatabase testSchemaEvolutionDB partition (c1 = 2008 ) schema "c1:int,c2:string,s_bytes:bytes,s_int:int,s_long:long,s_float:float,s_double:double,yy:bytes, m_1:map,m_2:map,m_3:map,ml_1:collection(r1:record(m:map)),ml_2:collection(r2:record(m:map)),ml_3:collection(r3:record(m:map))" delocation "testComplexSchema/partition1" loader "testloader"
+<SUCCESS>
+<COMMAND> publish dataelement to owltable testComplexSchema within owldatabase testSchemaEvolutionDB partition (c1 = 2009 ) schema "c1:int,c2:string,s_bytes:bytes,s_int:int,s_long:long,s_float:float,tt:int,s_double:double,m_1:map,m_2:map,m_3:map,ml_1:collection(r1:record(m:map)),ml_2:collection(r2:record(m:map)),ml_3:collection(r3:record((m:map))" delocation "testComplexSchema/partition2" loader "testloader"
+<EXCEPTION> org.apache.hadoop.owl.common.OwlException : 6002 : Error occurred while processing schema string. Cause : Encountered " "(" "( "" at line 1, column 209.
+<COMMAND> describe owltable testComplexSchema within owldatabase testSchemaEvolutionDB
+<RESULT> OwlTable 1
+{"creationTime":0,"modificationTime":0,"name":{"databaseName":"testschemaevolutiondb","tableName":"testcomplexschema"},"partitionKeys":[{"dataType":"INT","level":1,"listValues":[],"name":"c1","partitioningType":"LIST"}],"propertyKeys":[],"propertyValues":[],"schema":{"columnSchema":[{"columnNumber":0,"name":"c1","type":"INT"},{"columnNumber":1,"name":"c2","type":"STRING"},{"columnNumber":2,"name":"s_bytes","type":"BYTES"},{"columnNumber":3,"name":"s_int","type":"INT"},{"columnNumber":4,"name":"s_long","type":"LONG"},{"columnNumber":5,"name":"s_float","type":"FLOAT"},{"columnNumber":6,"name":"s_double","type":"DOUBLE"},{"columnNumber":7,"name":"m_1","schema":{"columnSchema":[{"columnNumber":0,"type":"STRING"}]},"type":"MAP"},{"columnNumber":8,"name":"m_2","schema":{"columnSchema":[{"columnNumber":0,"type":"STRING"}]},"type":"MAP"},{"columnNumber":9,"name":"m_3","schema":{"columnSchema":[{"columnNumber":0,"type":"STRING"}]},"type":"MAP"},{"columnNumber":10,"name":"ml_1","schem
a":{"columnSchema":[{"columnNumber":0,"name":"r1","schema":{"columnSchema":[{"columnNumber":0,"name":"m","schema":{"columnSchema":[{"columnNumber":0,"type":"STRING"}]},"type":"MAP"}]},"type":"RECORD"}]},"type":"COLLECTION"},{"columnNumber":11,"name":"ml_2","schema":{"columnSchema":[{"columnNumber":0,"name":"r2","schema":{"columnSchema":[{"columnNumber":0,"name":"m","schema":{"columnSchema":[{"columnNumber":0,"type":"STRING"}]},"type":"MAP"}]},"type":"RECORD"}]},"type":"COLLECTION"},{"columnNumber":12,"name":"ml_3","schema":{"columnSchema":[{"columnNumber":0,"name":"r3","schema":{"columnSchema":[{"columnNumber":0,"name":"m","schema":{"columnSchema":[{"columnNumber":0,"type":"STRING"}]},"type":"MAP"}]},"type":"RECORD"}]},"type":"COLLECTION"},{"columnNumber":13,"name":"yy","type":"BYTES"}]}}
+<COMMAND> publish dataelement to owltable testSchemaEvolutionTable within owldatabase testSchemaEvolutionDB partition (c1 = 2010 ) schema "c3:string" delocation "testSchemaEvolutionTable/partition4" loader "testloader"
+<EXCEPTION> org.apache.hadoop.owl.common.OwlException : 6002 : Error occurred while processing schema string. Cause : Different types of column c3 in schema union
+<COMMAND> describe owltable testSchemaEvolutionTable within owldatabase testSchemaEvolutionDB
+<RESULT> OwlTable 1
+{"creationTime":0,"modificationTime":0,"name":{"databaseName":"testschemaevolutiondb","tableName":"testschemaevolutiontable"},"partitionKeys":[{"dataType":"INT","level":1,"listValues":[],"name":"c1","partitioningType":"LIST"}],"propertyKeys":[],"propertyValues":[],"schema":{"columnSchema":[{"columnNumber":0,"name":"c1","type":"INT"},{"columnNumber":1,"name":"c2","type":"STRING"},{"columnNumber":2,"name":"c3","type":"INT"},{"columnNumber":3,"name":"c4","type":"INT"}]}}
+<COMMAND> drop owltable testSchemaEvolutionTable within owldatabase testSchemaEvolutionDB
+<SUCCESS>
+<COMMAND> drop owltable testComplexSchema within owldatabase testSchemaEvolutionDB
+<SUCCESS>
+<COMMAND> drop owldatabase testSchemaEvolutionDB
+<SUCCESS>