[jira] [Commented] (IGNITE-12852) Comma in field is not supported by COPY command
[ https://issues.apache.org/jira/browse/IGNITE-12852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17584664#comment-17584664 ] Taras Ledkov commented on IGNITE-12852: --- [~antkr], please add release notes because two options are added for COPY command. > Comma in field is not supported by COPY command > --- > > Key: IGNITE-12852 > URL: https://issues.apache.org/jira/browse/IGNITE-12852 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.8 >Reporter: YuJue Li >Assignee: Anton Kurbanov >Priority: Critical > Fix For: 2.14 > > Time Spent: 1h 10m > Remaining Estimate: 0h > > CREATE TABLE test(a int,b varchar(100),c int,PRIMARY key(a)); > > a.csv: > 1,"a,b",2 > > COPY FROM '/data/a.csv' INTO test (a,b,c) FORMAT CSV; > > The copy command fails because there is a comma in the second field,but this > is a fully legal and compliant CSV format -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (IGNITE-12852) Comma in field is not supported by COPY command
[ https://issues.apache.org/jira/browse/IGNITE-12852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17584361#comment-17584361 ] Anton Kurbanov commented on IGNITE-12852: - [~tledkov], I've created ticket for that: https://issues.apache.org/jira/browse/IGNITE-17573 > Comma in field is not supported by COPY command > --- > > Key: IGNITE-12852 > URL: https://issues.apache.org/jira/browse/IGNITE-12852 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.8 >Reporter: YuJue Li >Assignee: Anton Kurbanov >Priority: Critical > Fix For: 2.14 > > Time Spent: 1h > Remaining Estimate: 0h > > CREATE TABLE test(a int,b varchar(100),c int,PRIMARY key(a)); > > a.csv: > 1,"a,b",2 > > COPY FROM '/data/a.csv' INTO test (a,b,c) FORMAT CSV; > > The copy command fails because there is a comma in the second field,but this > is a fully legal and compliant CSV format -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (IGNITE-12852) Comma in field is not supported by COPY command
[ https://issues.apache.org/jira/browse/IGNITE-12852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17584241#comment-17584241 ] Taras Ledkov commented on IGNITE-12852: --- @[~antkr] 1. I guess this patch could me merged because it fixes significant functionality for users. 2. Agreed. I guess we can introduce one or more parse option to tune parser behavior. However, checking that the number of fields in the rows is the same looks good. > Comma in field is not supported by COPY command > --- > > Key: IGNITE-12852 > URL: https://issues.apache.org/jira/browse/IGNITE-12852 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.8 >Reporter: YuJue Li >Assignee: Anton Kurbanov >Priority: Critical > Fix For: 2.14 > > Time Spent: 1h > Remaining Estimate: 0h > > CREATE TABLE test(a int,b varchar(100),c int,PRIMARY key(a)); > > a.csv: > 1,"a,b",2 > > COPY FROM '/data/a.csv' INTO test (a,b,c) FORMAT CSV; > > The copy command fails because there is a comma in the second field,but this > is a fully legal and compliant CSV format -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (IGNITE-12852) Comma in field is not supported by COPY command
[ https://issues.apache.org/jira/browse/IGNITE-12852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17584216#comment-17584216 ] Anton Kurbanov commented on IGNITE-12852: - [~tledkov] So, the two major points we are currently missing from the RFC are: ability to parse optional CSV file header and fields with linebreaks. I absolutely agree that we must support both of them, please let me know your opinion whether: 1. should it be implemented as part of this ticket or as a separate issue? 2. we may think of some cumbersome corner case, like: — in current implementation we have relaxed requirements on number of fields in the record, RFC4180 explicitly requires that a number of fields in each row should be the same — this may lead to delayed detection of whether the row is on multiple lines or the record is broken as we may potentially lookup for enclosing bracket until the unknown place in the file which may be even not found, a simple example would be a single column CSV file (something like dictionary) with broken record in the very beginning with the linebreak. so the question is that do we want to commit to RFC or leave this option as a flag and attempt to introduce some fail-fast option? > Comma in field is not supported by COPY command > --- > > Key: IGNITE-12852 > URL: https://issues.apache.org/jira/browse/IGNITE-12852 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.8 >Reporter: YuJue Li >Assignee: Anton Kurbanov >Priority: Critical > Fix For: 2.14 > > Time Spent: 1h > Remaining Estimate: 0h > > CREATE TABLE test(a int,b varchar(100),c int,PRIMARY key(a)); > > a.csv: > 1,"a,b",2 > > COPY FROM '/data/a.csv' INTO test (a,b,c) FORMAT CSV; > > The copy command fails because there is a comma in the second field,but this > is a fully legal and compliant CSV format -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (IGNITE-12852) Comma in field is not supported by COPY command
[ https://issues.apache.org/jira/browse/IGNITE-12852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17584050#comment-17584050 ] Taras Ledkov commented on IGNITE-12852: --- [~antkr], the patch is OK with me. What doyou think about CSV that contains values with line separator, e.g: {code} ID, Comment, LikesCount 0, "Single line comment", 28 1. "Multiple line comment", 42 {code} Looks like it isn't supported now. May be we have to file issues to implement Ignite CSV parser according with [RFC-4180|https://www.rfc-editor.org/rfc/rfc4180]? > Comma in field is not supported by COPY command > --- > > Key: IGNITE-12852 > URL: https://issues.apache.org/jira/browse/IGNITE-12852 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.8 >Reporter: YuJue Li >Assignee: Anton Kurbanov >Priority: Critical > Fix For: 2.14 > > Time Spent: 1h > Remaining Estimate: 0h > > CREATE TABLE test(a int,b varchar(100),c int,PRIMARY key(a)); > > a.csv: > 1,"a,b",2 > > COPY FROM '/data/a.csv' INTO test (a,b,c) FORMAT CSV; > > The copy command fails because there is a comma in the second field,but this > is a fully legal and compliant CSV format -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (IGNITE-12852) Comma in field is not supported by COPY command
[ https://issues.apache.org/jira/browse/IGNITE-12852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17572473#comment-17572473 ] Anton Kurbanov commented on IGNITE-12852: - [~dpavlov][~nizhikov] Could you please check the patch once again as the branch has been rebased agains fresher master and TC re-run for this ticket? > Comma in field is not supported by COPY command > --- > > Key: IGNITE-12852 > URL: https://issues.apache.org/jira/browse/IGNITE-12852 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.8 >Reporter: YuJue Li >Assignee: Anton Kurbanov >Priority: Critical > Fix For: 2.14 > > Time Spent: 50m > Remaining Estimate: 0h > > CREATE TABLE test(a int,b varchar(100),c int,PRIMARY key(a)); > > a.csv: > 1,"a,b",2 > > COPY FROM '/data/a.csv' INTO test (a,b,c) FORMAT CSV; > > The copy command fails because there is a comma in the second field,but this > is a fully legal and compliant CSV format -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (IGNITE-12852) Comma in field is not supported by COPY command
[ https://issues.apache.org/jira/browse/IGNITE-12852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17565870#comment-17565870 ] Ignite TC Bot commented on IGNITE-12852: {panel:title=Branch: [pull/10141/head] Base: [master] : No blockers found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel} {panel:title=Branch: [pull/10141/head] Base: [master] : New Tests (90)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1} {color:#8b}JDBC Driver{color} [[tests 90|https://ci.ignite.apache.org/viewLog.html?buildId=6671694]] * {color:#013220}IgniteJdbcDriverTestSuite: JdbcThinBulkLoadSelfTest.testCsvLoadWithCommaDelimiter[0] - PASSED{color} * {color:#013220}IgniteJdbcDriverTestSuite: JdbcThinBulkLoadSelfTest.testCsvLoadWithPipeDelimiter[0] - PASSED{color} * {color:#013220}IgniteJdbcDriverTestSuite: JdbcThinBulkLoadSelfTest.testCsvLoadWithCommaDelimiter[1] - PASSED{color} * {color:#013220}IgniteJdbcDriverTestSuite: JdbcThinBulkLoadSelfTest.testCsvLoadWithPipeDelimiter[1] - PASSED{color} * {color:#013220}IgniteJdbcDriverTestSuite: JdbcThinBulkLoadSelfTest.testOneLineFileForSingleEndQuote[0] - PASSED{color} * {color:#013220}IgniteJdbcDriverTestSuite: JdbcThinBulkLoadSelfTest.testCsvLoadWithDefaultDelimiter[0] - PASSED{color} * {color:#013220}IgniteJdbcDriverTestSuite: JdbcThinBulkLoadSelfTest.testOneLineFileForQuoteInContent[0] - PASSED{color} * {color:#013220}IgniteJdbcDriverTestSuite: JdbcThinBulkLoadSelfTest.testOneLineFileForQuoteInQuotedContent[0] - PASSED{color} * {color:#013220}IgniteJdbcDriverTestSuite: JdbcThinBulkLoadSelfTest.testOneLineFileForUnmatchedEndQuote[0] - PASSED{color} * {color:#013220}IgniteJdbcDriverTestSuite: JdbcThinBulkLoadSelfTest.testOneLineFileForUnmatchedStartQuote[0] - PASSED{color} * {color:#013220}IgniteJdbcDriverTestSuite: JdbcThinBulkLoadSelfTest.testCsvLoadWithCommaDelimiter[4] - PASSED{color} ... and 79 new tests {panel} [TeamCity *-- Run :: All* Results|https://ci.ignite.apache.org/viewLog.html?buildId=6671748buildTypeId=IgniteTests24Java8_RunAll] > Comma in field is not supported by COPY command > --- > > Key: IGNITE-12852 > URL: https://issues.apache.org/jira/browse/IGNITE-12852 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.8 >Reporter: YuJue Li >Assignee: Anton Kurbanov >Priority: Critical > Fix For: 2.14 > > Time Spent: 50m > Remaining Estimate: 0h > > CREATE TABLE test(a int,b varchar(100),c int,PRIMARY key(a)); > > a.csv: > 1,"a,b",2 > > COPY FROM '/data/a.csv' INTO test (a,b,c) FORMAT CSV; > > The copy command fails because there is a comma in the second field,but this > is a fully legal and compliant CSV format -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (IGNITE-12852) Comma in field is not supported by COPY command
[ https://issues.apache.org/jira/browse/IGNITE-12852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17565166#comment-17565166 ] Ignite TC Bot commented on IGNITE-12852: {panel:title=Branch: [pull/10141/head] Base: [master] : Possible Blockers (1)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#F7D6C1} {color:#d04437}Basic 1{color} [[tests 0 Exit Code |https://ci.ignite.apache.org/viewLog.html?buildId=6673569]] {panel} {panel:title=Branch: [pull/10141/head] Base: [master] : New Tests (90)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1} {color:#8b}JDBC Driver{color} [[tests 90|https://ci.ignite.apache.org/viewLog.html?buildId=6671694]] * {color:#013220}IgniteJdbcDriverTestSuite: JdbcThinBulkLoadSelfTest.testCsvLoadWithCommaDelimiter[0] - PASSED{color} * {color:#013220}IgniteJdbcDriverTestSuite: JdbcThinBulkLoadSelfTest.testCsvLoadWithPipeDelimiter[0] - PASSED{color} * {color:#013220}IgniteJdbcDriverTestSuite: JdbcThinBulkLoadSelfTest.testCsvLoadWithCommaDelimiter[1] - PASSED{color} * {color:#013220}IgniteJdbcDriverTestSuite: JdbcThinBulkLoadSelfTest.testCsvLoadWithPipeDelimiter[1] - PASSED{color} * {color:#013220}IgniteJdbcDriverTestSuite: JdbcThinBulkLoadSelfTest.testOneLineFileForSingleEndQuote[0] - PASSED{color} * {color:#013220}IgniteJdbcDriverTestSuite: JdbcThinBulkLoadSelfTest.testCsvLoadWithDefaultDelimiter[0] - PASSED{color} * {color:#013220}IgniteJdbcDriverTestSuite: JdbcThinBulkLoadSelfTest.testOneLineFileForQuoteInContent[0] - PASSED{color} * {color:#013220}IgniteJdbcDriverTestSuite: JdbcThinBulkLoadSelfTest.testOneLineFileForQuoteInQuotedContent[0] - PASSED{color} * {color:#013220}IgniteJdbcDriverTestSuite: JdbcThinBulkLoadSelfTest.testOneLineFileForUnmatchedEndQuote[0] - PASSED{color} * {color:#013220}IgniteJdbcDriverTestSuite: JdbcThinBulkLoadSelfTest.testOneLineFileForUnmatchedStartQuote[0] - PASSED{color} * {color:#013220}IgniteJdbcDriverTestSuite: JdbcThinBulkLoadSelfTest.testCsvLoadWithCommaDelimiter[4] - PASSED{color} ... and 79 new tests {panel} [TeamCity *-- Run :: All* Results|https://ci.ignite.apache.org/viewLog.html?buildId=6671748buildTypeId=IgniteTests24Java8_RunAll] > Comma in field is not supported by COPY command > --- > > Key: IGNITE-12852 > URL: https://issues.apache.org/jira/browse/IGNITE-12852 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.8 >Reporter: YuJue Li >Assignee: Anton Kurbanov >Priority: Critical > Fix For: 2.14 > > Time Spent: 50m > Remaining Estimate: 0h > > CREATE TABLE test(a int,b varchar(100),c int,PRIMARY key(a)); > > a.csv: > 1,"a,b",2 > > COPY FROM '/data/a.csv' INTO test (a,b,c) FORMAT CSV; > > The copy command fails because there is a comma in the second field,but this > is a fully legal and compliant CSV format -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (IGNITE-12852) Comma in field is not supported by COPY command
[ https://issues.apache.org/jira/browse/IGNITE-12852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17563516#comment-17563516 ] YuJue Li commented on IGNITE-12852: --- ok. > Comma in field is not supported by COPY command > --- > > Key: IGNITE-12852 > URL: https://issues.apache.org/jira/browse/IGNITE-12852 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.8 >Reporter: YuJue Li >Assignee: YuJue Li >Priority: Critical > Fix For: 2.14 > > Time Spent: 50m > Remaining Estimate: 0h > > CREATE TABLE test(a int,b varchar(100),c int,PRIMARY key(a)); > > a.csv: > 1,"a,b",2 > > COPY FROM '/data/a.csv' INTO test (a,b,c) FORMAT CSV; > > The copy command fails because there is a comma in the second field,but this > is a fully legal and compliant CSV format -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (IGNITE-12852) Comma in field is not supported by COPY command
[ https://issues.apache.org/jira/browse/IGNITE-12852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17563409#comment-17563409 ] Anton Kurbanov commented on IGNITE-12852: - [~liyuj] would it be ok for me to get this ticket assigned back to me? > Comma in field is not supported by COPY command > --- > > Key: IGNITE-12852 > URL: https://issues.apache.org/jira/browse/IGNITE-12852 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.8 >Reporter: YuJue Li >Assignee: YuJue Li >Priority: Critical > Fix For: 2.14 > > Time Spent: 50m > Remaining Estimate: 0h > > CREATE TABLE test(a int,b varchar(100),c int,PRIMARY key(a)); > > a.csv: > 1,"a,b",2 > > COPY FROM '/data/a.csv' INTO test (a,b,c) FORMAT CSV; > > The copy command fails because there is a comma in the second field,but this > is a fully legal and compliant CSV format -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (IGNITE-12852) Comma in field is not supported by COPY command
[ https://issues.apache.org/jira/browse/IGNITE-12852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17364016#comment-17364016 ] YuJue Li commented on IGNITE-12852: --- I don't know why the test didn't pass. Can you let [~antkr] (the patch provider) or [~rkondakov] or [~nizhikov] have a look at this problem? > Comma in field is not supported by COPY command > --- > > Key: IGNITE-12852 > URL: https://issues.apache.org/jira/browse/IGNITE-12852 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.8 >Reporter: YuJue Li >Assignee: YuJue Li >Priority: Critical > Fix For: 2.11 > > Time Spent: 0.5h > Remaining Estimate: 0h > > CREATE TABLE test(a int,b varchar(100),c int,PRIMARY key(a)); > > a.csv: > 1,"a,b",2 > > COPY FROM '/data/a.csv' INTO test (a,b,c) FORMAT CSV; > > The copy command fails because there is a comma in the second field,but this > is a fully legal and compliant CSV format -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (IGNITE-12852) Comma in field is not supported by COPY command
[ https://issues.apache.org/jira/browse/IGNITE-12852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17363762#comment-17363762 ] Dmitry Pavlov commented on IGNITE-12852: [~liyuj] could you please merge actual master into your PR branch? Unfortunately current failed test number makes it impossible to ananlyse if it is safe to merge. > Comma in field is not supported by COPY command > --- > > Key: IGNITE-12852 > URL: https://issues.apache.org/jira/browse/IGNITE-12852 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.8 >Reporter: YuJue Li >Assignee: YuJue Li >Priority: Critical > Fix For: 2.11 > > Time Spent: 0.5h > Remaining Estimate: 0h > > CREATE TABLE test(a int,b varchar(100),c int,PRIMARY key(a)); > > a.csv: > 1,"a,b",2 > > COPY FROM '/data/a.csv' INTO test (a,b,c) FORMAT CSV; > > The copy command fails because there is a comma in the second field,but this > is a fully legal and compliant CSV format -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (IGNITE-12852) Comma in field is not supported by COPY command
[ https://issues.apache.org/jira/browse/IGNITE-12852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17357344#comment-17357344 ] Ignite TC Bot commented on IGNITE-12852: {panel:title=Branch: [pull/7661/head] Base: [master] : Possible Blockers (59)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#F7D6C1} {color:#d04437}Control Utility (Zookeeper){color} [[tests 0 Exit Code |https://ci.ignite.apache.org/viewLog.html?buildId=6035313]] {color:#d04437}SPI{color} [[tests 3|https://ci.ignite.apache.org/viewLog.html?buildId=6035248]] * IgniteSpiTestSuite: TcpClientDiscoverySpiFailureTimeoutSelfTest.testDisconnectAfterNetworkTimeout - Test has low fail rate in base branch 0,0% and is not flaky * IgniteSpiTestSuite: GridTcpCommunicationSpiTcpNoDelayOffSelfTest.testSendToManyNodes - Test has low fail rate in base branch 0,0% and is not flaky * IgniteSpiTestSuite: GridTcpCommunicationSpiTcpNoDelayOffSelfTest.testSendToOneNode - Test has low fail rate in base branch 0,0% and is not flaky {color:#d04437}Examples{color} [[tests 10|https://ci.ignite.apache.org/viewLog.html?buildId=6035230]] * IgniteExamplesSelfTestSuite: SpringDataExampleSelfTest.testSpringDataExample - History for base branch is absent. * IgniteExamplesSelfTestSuite: CacheContinuousQueryExamplesSelfTest.testCacheContinuousAsyncQueryExample - Test has low fail rate in base branch 0,0% and is not flaky * IgniteExamplesSelfTestSuite: CacheContinuousQueryExamplesSelfTest.testCacheContinuousQueryExample - Test has low fail rate in base branch 0,0% and is not flaky * IgniteExamplesSelfTestSuite: BasicExamplesMultiNodeSelfTest.testRunnableExample - Test has low fail rate in base branch 0,0% and is not flaky * IgniteExamplesSelfTestSuite: BasicExamplesMultiNodeSelfTest.testClosureExample - Test has low fail rate in base branch 0,0% and is not flaky * IgniteExamplesSelfTestSuite: BasicExamplesMultiNodeSelfTest.testCallableExample - Test has low fail rate in base branch 0,0% and is not flaky * IgniteExamplesSelfTestSuite: BasicExamplesMultiNodeSelfTest.testExecutorExample - Test has low fail rate in base branch 0,0% and is not flaky * IgniteExamplesSelfTestSuite: TutorialStepByStepExampleSelfTest.testExample - New test duration 204s is more that 1 minute * IgniteExamplesSelfTestSuite: ClusterGroupExampleSelfTest.testComputeClusterGroupsExample - Test has low fail rate in base branch 0,0% and is not flaky * IgniteExamplesSelfTestSuite: BasicExamplesMultiNodeSelfTest.testReducerExample - Test has low fail rate in base branch 0,0% and is not flaky {color:#d04437}Platform .NET (Inspections)*{color} [[tests 0 Failure on metric |https://ci.ignite.apache.org/viewLog.html?buildId=6035295]] {color:#d04437}Platform .NET (Core Linux){color} [[tests 2 TC_SERVICE_MESSAGE |https://ci.ignite.apache.org/viewLog.html?buildId=6035294]] * dll: IgnitionStartTest.TestIgniteStartsFromSpringXml - History for base branch is absent. * dll: IgniteConfigurationTest.TestSpringXml - Test has low fail rate in base branch 0,0% and is not flaky {color:#d04437}Cache (Restarts) 1{color} [[tests 1|https://ci.ignite.apache.org/viewLog.html?buildId=6035271]] * IgniteCacheRestartTestSuite: IgniteCacheNearRestartRollbackSelfTest.testRestarts - New test duration 75s is more that 1 minute {color:#d04437}Cache 5{color} [[tests 1|https://ci.ignite.apache.org/viewLog.html?buildId=6035278]] * IgniteCacheTestSuite5: GridExchangeFreeCellularSwitchComplexOperationsTest.testComplexOperationsRecoveryOnCellularSwitch[Isolation = OPTIMISTIC, Concurrency = SERIALIZABLE, Started from = NEAR] - History for base branch is absent. {color:#d04437}Platform .NET (Long Running){color} [[tests 1|https://ci.ignite.apache.org/viewLog.html?buildId=6035297]] * exe: ExamplesTest.TestRemoteNodes(SqlExample) - New test duration 63s is more that 1 minute {color:#d04437}Control Utility{color} [[tests 0 Exit Code |https://ci.ignite.apache.org/viewLog.html?buildId=6035312]] {color:#d04437}Cache 8{color} [[tests 1|https://ci.ignite.apache.org/viewLog.html?buildId=6035281]] * IgniteCacheTestSuite8: RandomLruPageEvictionWithRebalanceTest.testEvictionWithRebalance - Test has low fail rate in base branch 0,0% and is not flaky {color:#d04437}Thin client: Node.js{color} [[tests 1|https://ci.ignite.apache.org/viewLog.html?buildId=6035315]] * execute auth example : AuthTlsExample - Test has low fail rate in base branch 0,0% and is not flaky {color:#d04437}Queries 1{color} [[tests 4|https://ci.ignite.apache.org/viewLog.html?buildId=6035299]] * IgniteBinaryCacheQueryTestSuite: IndexingCachePartitionLossPolicySelfTest.checkLostPartition[ATOMIC READ_ONLY_SAFE 1 true 4 false] - Test has low fail rate in base branch 0,0% and is not flaky * IgniteBinaryCacheQueryTestSuite: IgniteCacheQueryH2IndexingLeakTest.testLeaksInIgniteH2IndexingOnTerminatedThread - Test has low fail rate in base branch 0,0% and is not flaky
[jira] [Commented] (IGNITE-12852) Comma in field is not supported by COPY command
[ https://issues.apache.org/jira/browse/IGNITE-12852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17357220#comment-17357220 ] Dmitry Pavlov commented on IGNITE-12852: Do we have a TC run for this PR? > Comma in field is not supported by COPY command > --- > > Key: IGNITE-12852 > URL: https://issues.apache.org/jira/browse/IGNITE-12852 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.8 >Reporter: YuJue Li >Assignee: YuJue Li >Priority: Critical > Fix For: 2.11 > > Time Spent: 0.5h > Remaining Estimate: 0h > > CREATE TABLE test(a int,b varchar(100),c int,PRIMARY key(a)); > > a.csv: > 1,"a,b",2 > > COPY FROM '/data/a.csv' INTO test (a,b,c) FORMAT CSV; > > The copy command fails because there is a comma in the second field,but this > is a fully legal and compliant CSV format -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (IGNITE-12852) Comma in field is not supported by COPY command
[ https://issues.apache.org/jira/browse/IGNITE-12852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17255952#comment-17255952 ] YuJue Li commented on IGNITE-12852: --- I recommend that this patch be included in version 2.10. The copy command is very useful in some test scenarios > Comma in field is not supported by COPY command > --- > > Key: IGNITE-12852 > URL: https://issues.apache.org/jira/browse/IGNITE-12852 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.8 >Reporter: YuJue Li >Assignee: YuJue Li >Priority: Critical > Fix For: 2.10 > > Time Spent: 0.5h > Remaining Estimate: 0h > > CREATE TABLE test(a int,b varchar(100),c int,PRIMARY key(a)); > > a.csv: > 1,"a,b",2 > > COPY FROM '/data/a.csv' INTO test (a,b,c) FORMAT CSV; > > The copy command fails because there is a comma in the second field,but this > is a fully legal and compliant CSV format -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (IGNITE-12852) Comma in field is not supported by COPY command
[ https://issues.apache.org/jira/browse/IGNITE-12852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17255885#comment-17255885 ] Maxim Muzafarov commented on IGNITE-12852: -- [~liyuj], [~nizhikov] Do we have any unresolved comments? Can we proceed with this patch? > Comma in field is not supported by COPY command > --- > > Key: IGNITE-12852 > URL: https://issues.apache.org/jira/browse/IGNITE-12852 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.8 >Reporter: YuJue Li >Assignee: YuJue Li >Priority: Critical > Fix For: 2.10 > > Time Spent: 0.5h > Remaining Estimate: 0h > > CREATE TABLE test(a int,b varchar(100),c int,PRIMARY key(a)); > > a.csv: > 1,"a,b",2 > > COPY FROM '/data/a.csv' INTO test (a,b,c) FORMAT CSV; > > The copy command fails because there is a comma in the second field,but this > is a fully legal and compliant CSV format -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (IGNITE-12852) Comma in field is not supported by COPY command
[ https://issues.apache.org/jira/browse/IGNITE-12852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17111940#comment-17111940 ] YuJue Li commented on IGNITE-12852: --- OK > Comma in field is not supported by COPY command > --- > > Key: IGNITE-12852 > URL: https://issues.apache.org/jira/browse/IGNITE-12852 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.8 >Reporter: YuJue Li >Assignee: YuJue Li >Priority: Critical > Fix For: 2.9 > > Time Spent: 0.5h > Remaining Estimate: 0h > > CREATE TABLE test(a int,b varchar(100),c int,PRIMARY key(a)); > > a.csv: > 1,"a,b",2 > > COPY FROM '/data/a.csv' INTO test (a,b,c) FORMAT CSV; > > The copy command fails because there is a comma in the second field,but this > is a fully legal and compliant CSV format -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (IGNITE-12852) Comma in field is not supported by COPY command
[ https://issues.apache.org/jira/browse/IGNITE-12852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17111936#comment-17111936 ] Nikolay Izhikov commented on IGNITE-12852: -- Hello, [~liyuj] It seems there is no chance for this fix to squeeze into 2.8.1 scope. So I moved it into 2.9. > Comma in field is not supported by COPY command > --- > > Key: IGNITE-12852 > URL: https://issues.apache.org/jira/browse/IGNITE-12852 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.8 >Reporter: YuJue Li >Assignee: YuJue Li >Priority: Critical > Fix For: 2.9 > > Time Spent: 0.5h > Remaining Estimate: 0h > > CREATE TABLE test(a int,b varchar(100),c int,PRIMARY key(a)); > > a.csv: > 1,"a,b",2 > > COPY FROM '/data/a.csv' INTO test (a,b,c) FORMAT CSV; > > The copy command fails because there is a comma in the second field,but this > is a fully legal and compliant CSV format -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (IGNITE-12852) Comma in field is not supported by COPY command
[ https://issues.apache.org/jira/browse/IGNITE-12852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17086715#comment-17086715 ] YuJue Li commented on IGNITE-12852: --- Can someone help merge into master and branch 2.8.1? > Comma in field is not supported by COPY command > --- > > Key: IGNITE-12852 > URL: https://issues.apache.org/jira/browse/IGNITE-12852 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.8 >Reporter: YuJue Li >Assignee: YuJue Li >Priority: Critical > Fix For: 2.8.1 > > Time Spent: 10m > Remaining Estimate: 0h > > CREATE TABLE test(a int,b varchar(100),c int,PRIMARY key(a)); > > a.csv: > 1,"a,b",2 > > COPY FROM '/data/a.csv' INTO test (a,b,c) FORMAT CSV; > > The copy command fails because there is a comma in the second field,but this > is a fully legal and compliant CSV format -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (IGNITE-12852) Comma in field is not supported by COPY command
[ https://issues.apache.org/jira/browse/IGNITE-12852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17085560#comment-17085560 ] Roman Kondakov commented on IGNITE-12852: - [~nizhikov] the patch looks good to me. > Comma in field is not supported by COPY command > --- > > Key: IGNITE-12852 > URL: https://issues.apache.org/jira/browse/IGNITE-12852 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.8 >Reporter: YuJue Li >Assignee: YuJue Li >Priority: Critical > Fix For: 2.8.1 > > Time Spent: 10m > Remaining Estimate: 0h > > CREATE TABLE test(a int,b varchar(100),c int,PRIMARY key(a)); > > a.csv: > 1,"a,b",2 > > COPY FROM '/data/a.csv' INTO test (a,b,c) FORMAT CSV; > > The copy command fails because there is a comma in the second field,but this > is a fully legal and compliant CSV format -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (IGNITE-12852) Comma in field is not supported by COPY command
[ https://issues.apache.org/jira/browse/IGNITE-12852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17085066#comment-17085066 ] Nikolay Izhikov commented on IGNITE-12852: -- Hello [~rkondakov] Can you, please, take a look at this changes? > Comma in field is not supported by COPY command > --- > > Key: IGNITE-12852 > URL: https://issues.apache.org/jira/browse/IGNITE-12852 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.8 >Reporter: YuJue Li >Assignee: YuJue Li >Priority: Critical > Fix For: 2.8.1 > > Time Spent: 10m > Remaining Estimate: 0h > > CREATE TABLE test(a int,b varchar(100),c int,PRIMARY key(a)); > > a.csv: > 1,"a,b",2 > > COPY FROM '/data/a.csv' INTO test (a,b,c) FORMAT CSV; > > The copy command fails because there is a comma in the second field,but this > is a fully legal and compliant CSV format -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (IGNITE-12852) Comma in field is not supported by COPY command
[ https://issues.apache.org/jira/browse/IGNITE-12852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17072784#comment-17072784 ] YuJue Li commented on IGNITE-12852: --- !image-2020-04-01-21-39-43-371.png! It's not enough to just use the Pattern.split() method. > Comma in field is not supported by COPY command > --- > > Key: IGNITE-12852 > URL: https://issues.apache.org/jira/browse/IGNITE-12852 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.8 >Reporter: YuJue Li >Priority: Critical > Fix For: 2.8.1 > > Attachments: image-2020-04-01-21-39-20-055.png, > image-2020-04-01-21-39-43-371.png > > > CREATE TABLE test(a int,b varchar(100),c int,PRIMARY key(a)); > > a.csv: > 1,"a,b",2 > > COPY FROM '/data/a.csv' INTO test (a,b,c) FORMAT CSV; > > The copy command fails because there is a comma in the second field,but this > is a fully legal and compliant CSV format -- This message was sent by Atlassian Jira (v8.3.4#803005)