Mongo的Invalid BSON field name $gte

mongoDB | 2021-09-16 21:41:22

1.异常原因

使用spark插入数据到Mongo遇到这个问题,属性名不能包含 {.}点 和 {$}符号。但是mongo本身是支持点和美元符号的,这是mongo-java-driver的问题。

断点进去发现验证类确实不允许出现点和美元符号。

/*
 * Copyright 2008-present MongoDB, Inc.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *   http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

package com.mongodb.internal.validator;

import org.bson.FieldNameValidator;

import java.util.Arrays;
import java.util.List;

/**
 * A field name validator for document that are meant for storage in MongoDB collections.  It ensures that no fields contain a '.',
 * or start with '$' (with the exception of "$db", "$ref", and "$id", so that DBRefs are not rejected).
 *
 * <p>This class should not be considered a part of the public API.</p>
 */
public class CollectibleDocumentFieldNameValidator implements FieldNameValidator {
    // Have to support DBRef fields
    private static final List<String> EXCEPTIONS = Arrays.asList("$db", "$ref", "$id");

    @Override
    public boolean validate(final String fieldName) {
        if (fieldName == null) {
            throw new IllegalArgumentException("Field name can not be null");
        }

        if (fieldName.contains(".")) {
            return false;
        }

        if (fieldName.startsWith("$") && !EXCEPTIONS.contains(fieldName)) {
            return false;
        }
        return true;
    }

    @Override
    public FieldNameValidator getValidatorForField(final String fieldName) {
        return this;
    }
}

 

解决方法:

使用同名覆盖的方式重写这个类

建同样的包名类名,然后覆盖原来的类

/*
 * Copyright 2008-present MongoDB, Inc.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *   http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

package com.mongodb.internal.validator;

import org.bson.FieldNameValidator;

import java.util.Arrays;
import java.util.List;

/**
 * A field name validator for document that are meant for storage in MongoDB collections.  It ensures that no fields contain a '.',
 * or start with '$' (with the exception of "$db", "$ref", and "$id", so that DBRefs are not rejected).
 *
 * <p>This class should not be considered a part of the public API.</p>
 */
public class CollectibleDocumentFieldNameValidator implements FieldNameValidator {
  // Have to support DBRef fields
  private static final List<String> EXCEPTIONS = Arrays.asList("$db", "$ref", "$id");

  @Override
  public boolean validate(final String fieldName) {
    if (fieldName == null) {
      throw new IllegalArgumentException("Field name can not be null [hy]");
    }

    if (fieldName.contains(".")) {
      return true;
    }

    if (fieldName.startsWith("$") && !EXCEPTIONS.contains(fieldName)) {
      return false;
    }
    return true;
  }

  @Override
  public FieldNameValidator getValidatorForField(final String fieldName) {
    return this;
  }
}

 

 

 

登录后即可回复 登录 | 注册
    
关注编程学问公众号